Did I really do a databasebackup?

  • poster59

    (@poster59)


    13 years, 1 month ago

    I started trying to do a backup of my database using MySQL and the screenshots on the instructions didn’t lead me in the same direction so I somehow ended up in phpMyAdmin with a screen that looked like it had some wp tables (wp_categories, wp_comments, wp_links, etc.) I selected all of them and then clicked the “export” button at the top I left the drop down menu on “MySql” and then clicked go. It downloaded a file named “pooust5_wrdp2.sql” Did I do it wight? Is there a way I can tell for sure that this will be what I need if I ever have to backup my site? It’s 2.3 MB – so there’s SOMETHING there. I wish I could upload the screenshots so you could see what I did.

    Thanks for any help you can give me.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Chris Olbekson

    (@c3mdigital)

    13 years, 1 month ago

    Yes you did it right, pooust5_wrdp2.sql is a MySql dump file and can be imported into another database to restore all your content and settings for your site. You can actually open the file in a text editor to see how it instructs MySql to create the proper tables and insert the data back in.

    You should also keep a backup of your files including your theme and any plugins not readily available for download and do the database backup at least once a week or whatever the amount of time you feel comfortable with.

    Thread Starter poster59

    (@poster59)

    13 years, 1 month ago

    Thanks Chris, when you talk about backing up the files including theme and plugins, are you talking about everything that’s in the “public_html” folder on the ftp upload?

    Chris Olbekson

    (@c3mdigital)

    13 years, 1 month ago

    Everything in the wp-content directory and your wp-config.php file should be fine. This will give you a copy of all your uploaded images, themes and plugins.

    Thread Starter poster59

    (@poster59)

    13 years, 1 month ago

    I see the “wp-content” file. Is the “wp-config.php just one file? I don’t see it.

    Oh! I think I found it. It’s a single file in the “wp-admin” folder.

    Actually, no it’s not. It’s floating around in the “blog” folder.

    But that’s the file I need to back up along with the wp-content directory folder. Correct?

    Chris Olbekson

    (@c3mdigital)

    13 years, 1 month ago

    wp-config.php is in the root directory of your install and contains your database settings which are helpful if you need to restore from a backup or move your site.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Did I really do a databasebackup?’ is closed to new replies.