Database Backup Questions

  • jandrews88

    (@jandrews88)


    19 years ago

    The e-book on Semiologic says to “Backup your databse” before upgrading to Semiologic 3.2.1, but it doesn’t give any instructions on HOW to back up the database.

    Looking at the Semiologic files from within my FTP program, I have two different backup folders inside “wp-content.” I have a folder named “backup” and a folder named “backup-be086.” Why do I have two different backup folders? Which folder should I use and how do I back up my database? Help! I’m totally new to all of this.

Viewing 4 replies - 1 through 4 (of 4 total)
  • moshu

    (@moshu)

    I don’t know anything about that semiologic stuff – don’t forget that’s a different animal.
    However, backing up the database should be pretty much the same for every database:
    Backing_Up_Your_Database

    Thread Starter jandrews88

    (@jandrews88)

    Thanks Moshu for your help. However, I get an error message when I try to use the backup feature. Here’s what happens…When I go to Admin interface > Manage > Backup, it asks me which tables I want to backup. I select the tables I want to back-up…

    wp_categories
    wp_comments
    wp_linkcategories
    wp_links
    wp_options
    wp_post2cat
    wp_postmeta
    wp_posts
    wp_usermeta
    wp_users
    wp_quotes

    and I choose to back it up to the server (wp-content/backup-be086). I hit the “Backup” button, and I get the following error message…”Backup file could not be saved. Please check the permissions for writing to your backup directory.”

    I don’t understand why I’m getting this error. The “Wp-content” folder has file permissions set to 777. Same for the “backup-be086” folder and the “backup” folder. They’re all set to 777. So, how can there be a problem with file permissions?

    I don’t get it. Puzzled.

    Denis de Bernardy

    (@denis-de-bernardy)

    you can safely delete the backup directory; it was previously used by the backup plugin.

    your permissions issue might come from a server with safe mode disabled, in which case there isn’t much you can do short of ignoring the backup plugin.

    your host shuld normally provide you with a means to backup your data using the CPanel or HSphere interface.

    if you’re just backing up before upgrading your install, it’s reasonably safe to ignore the ‘backup your database’ tip — I’ve yet to see a single error during the process.

    Thread Starter jandrews88

    (@jandrews88)

    Thanks, Denis. I think I’ll just upgrade without backing up. (Fingers crossed.)

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database Backup Questions’ is closed to new replies.