Note Prior to populating the Word Press databases with your backup youll need to ensure that all the current information in there is removed by using the Drop Table command in MySQL The process used by the WPDB Backup plugin does this for you when restorin

Figure 18-5. Restoring WordPress database backup using phpMyAdmin

Note that the file upload method can accept gzipped compressed files. This is perfect if you've followed my recommendation and used the WP-DB Backup plug-in, which generates such a compressed file type.

To restore your backup, upload the latest archive file generated by the WP-DB Backup plug-in and click the Go button. You will eventually (this can take up to a few minutes) be presented with a page containing a message similar to the one in Figure 18-6, indicating that the upload was successful.

Your SQL-query has been executed successfully : The content of your file has been inserted. (140 Instructions)

Figure 18-6. Successful WordPress database restore using phpMyAdmin

Check your blog site now to determine that all is well. Sometimes, a faulty theme can display a blank page at this stage. If so, swap out the theme to the Default theme (see Chapter 16) to see if that solves the problem. If that fails to resolve the situation, you may need to resort to reapplying a new set of WordPress files, but that is a rare event.

Was this article helpful?

0 0

Post a comment