Backup and Restore your MYSQL Database on GoDaddy

Top is pecil & under it the buttons for backup and restore

Top is pencil & under it the buttons for backup and restore

This past weekend I combined two blogs into a single one.   It all went, it didn’t all go smooth.   But in the end they are now combined and happy campers.

I’ve told the story in   a couple of post about the process if integration and the duplicated posts, categories and unpublished posts (I found those today).

Since the integration the admin panel seems slow and I often get apache error popping up which a refresh so far has handled.   I decided one more step in the process might be appropriate.

Lay down the Data To a New Database

There are a lot of ways to backup a database.   Most are pretty easy to do.   What I’ve found a bit daunting is Restoring the database.   Today after an hour of feeling my way around the various methods for both backup and restore landed on the one I wanted to try.   It worked, flawlessly and fast.   You can do this too.

  1. I created a new database.
  2. I went to the hosting package, databases, selected the existing old DB, clicked on the pencil to the right of the database name and chose the “Backup” button at the top of the window.
  3. Backup was pending, then completed in a couple of minutes.
  4. Verified the file created and placed in the root directory for the hosting package folder named “_db_backups”
  5. exited from the existing database
  6. clicked on the new database and the pencil to the right.
  7. selected import and the newly created file is the one available.
  8. select that file and click “go” in the lower right hand corner
  9. restore “pending”   in a couple of minutes “done”
  10. made a note of the database code to be placed in the wp-config.php file
  11. changed the database in the wp-config.php file and FTP the new config file to the blog directory (I changed the name of the original file rather than overwrite it)
  12. Went to the blog, everything looked the same. (As it should)

It has the effect of doing a defrag on your database.   It also means I have a backup database up to today if for some reason I need it.

So far no apache errors, the editor seems to load and save faster than it was before the new database was created and attached.

If you are going to integrate two blogs I would recommend doing this procedure to give yourself a nice clean copy of the database.

The graphic at the top is a combination of two screens.   The first above the line shows the database name and pencil to the right.   Under it is the window that is opened when you click on the pencil.

Good Holiday Geek Project

It is also something you can do once a quarter or once a year depending on how desperate you are for something to do on the next holiday weekend.

Comments

  1. I’m laughing at “Good Holiday Geek Project” – I am an ex godaddy customer…their interface is not easy to understand at all!

  2. What hosting package did you move to when you left GoDaddy