How To Backup WordPress Database & Install A Backup Database
Installing a WordPress database backup via PHPmyAdmin isn’t that hard once you done it a few times, but for many people restoring a database for the first or second time can be very scary and that’s exactly why I’ve decided to make the whole process a little easier with a video tutorial.
First off, Everyone who runs self hosted WordPress site should have it setup to automatically create and store backups to the Cloud, because you never know what could happen. I’ve personally had several of my sites hacked in the past but luckily had backup copies to restore them, turned out that I had outdated versions of WordPress giving people easy access to my sites.
All of my sites and clients sites are automatically backed up into a .zip file and sent to my Google Drive account, around once a month I’ll also download backup copies to my external hard-drive. If you’re interested in seeing how this is done you can checkout my other tutorial here: How To Create A Full WordPress Blog Backup or How to move WordPress to new host
Creating A Database Backup
A WordPress database contains all of the content from all the posts and pages on your site, it also contains all of the website, user, plugin and theme setting. I’d actually say it’s the most important part of a site that should be backed up. In the video below I’m going to be teaching you how to setup a plugin called “WP DB Backup” and have it automatically backup and email you the wordpress database.sql.gz file every hour/day/week/month.
You can checkout more details about this plugin here: http://wordpress.org/extend/plugins/wp-db-backup/
You’ll notice that the plugin hasn’t been updated in a long time and that’s because it works fine and doesn’t need to be updated, if you do run into any problems, feel free to contact me and I’ll gladly help you out.
Restoring A Database Via PHPmyAdmin
This video below is also going to cover removing the corrupt database and restoring the SQL backup file via phpmyadmin, it’s actually not that hard once you’ve done it once or seen it done via a video, just remember that you’ll need to DROP ALL the database tables before Importing the backup SQL database.
If you have several wordpress installation or perhaps other software installed, maybe you’re not sure what database you need to edit/restore, if that’s the case, you can always edit/view the sites wp-config.php file, this will reveal the database name that you need to edit/restore.
If you have any questions or comments about this video/topic, please post them below or on the Youtube video page and I’ll answer them ASAP.
Google Plus WordPress Community
I’m a huge WordPress fan/geek and have created a free to join Google Plus Community, here myself and other members share WordPress related tutorial and reviews, we also offer help and support to members who need it. https://plus.google.com/communities/100817298545318590300