Restore WordPress mySql Database

  • I have been using the WordPress Backup for Dropbox in a site that I setup 2-3 years ago. The site crashed a couple of days ago when the sites user was updating and editing a slider on the home page. Now you can not open the site due a parsing error within a slider module.

    I have a successful SQL backup out of the Dropbox backup prior to the crash and have read in one of the www.remarpro.com articles that you uses phpMyAdmin to import the backup (restore) back to the time of the imported sql file.

    My question is, do you need to empty the tables that are setup for the site before the import? Delete the tables for the database? Or can you run the import as is and it will reset the data in the tables to the previous point?

    Thank you for your time and assistance.

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

  • Many backups include instructions to drop the tables before restoring the backup. This is typical, but I’m not sure how your particular backup works. If the instructions are there great. If not, the restore will likely fail and you’ll know it so you can take the appropriate steps.

    You may want to try restoring to a temporary, empty, and different database just to be sure your backup works. Some people have run into problems with their backup files.

    Thread Starter HGodwin

    (@hgodwin)

    Thank you – one other developer told me this also. I really appreciate you taking the time and answering my question.

    I will try loading to my local mySql Database first.

    Again – thank you.

    Just a question…

    If the “slider module” is in a theme, or is a plugin, could you not just go through your cPanel file manager, or FTP, and rename or delete the theme or plugin? Would not that restore the site?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Restore WordPress mySql Database’ is closed to new replies.

Tags