Doing backups of your WordPress site is essential for making quick restorations of any accidentally deleted or corrupted data in your WordPress installation. Securing your WordPress backups comes in two parts - Backing up your site data and backing up your database contents. You need to complete both of these actions in order to have a full backup of your Wordpress site.
How often you do these backs is up to you and largely depends on how often you update your WordPress site. A site that has new information or posts on a daily basis should be backed up very frequently. A site that has updates or changes made infrequently does not need to be backed up as often. Once you decide how frequently you need to make backups, it’s just important to stick with it.
It’s also recommend that you keep copies of your backups in more than one place. For example - one copy on your desktop computer and another on a external hard drive. This means that if anything goes wrong with one source, you have a backup of your backup!
Datarealm does maintain backups your site files and databases, but we make no guarantees that we will be able to restore any specific file or piece of information. Ultimately, you are responsible for your files and your backups.
When you install WordPress into your account, several folders and files are installed directly into your hosting account. Often users choose to install WordPress into a subdirectory. Others install WordPress right into the home or root directory of the account. You can determine exactly where your Wordpress installation is installed by looking at the Wordpress installation page in your /admin (Under Website Tools and Blogging Software) -
The above example shows that the Wordpress installation was placed in a folder called “wordpress”. Your folder name may very. If your installation was originally placed in the root directory of your hosting account, you will simply see the following slash (/) under “Location”
Once you have established where your WordPress files are located, your next step will be to make an FTP connection to your account to download a copy of all of your WordPress files.
IMPORTANT - Your hosting account contains the majority of the files WordPress needs to function. That includes the following -
The WordPress Core Installation
All installed Themes
All installed Plugins
Static Web Pages
For a complete list of the WordPress core installation files, please see this page on wordpress.org - http://codex.wordpress.org/WordPress_Files
You will need to download everything in order to have a complete backup. If you are unsure where your WordPress files reside or what files you need to download to make a complete backup, please contact us.
Wordpress stores a great deal of data and configuration for your site in a MySql database. Datarealm offers a program called PhpMyAdmin to access and manipulate your MySql database. You don’t have to be PhpMyAdmin savvy to follow these instructions to export and save your Wordpress data. Just take it one step at a time and let us know if you need any help at any point!
1) Access your PhpMyAdmin here - https://secure.datarealm.com/phpMyAdmin/. You will be presented with the following -
On this login screen, you will be asked for three things -
Your MySql Username - This is the same as your Datarealm FTP/admin username. If you are not sure what to enter, please contact us.
Your MySql Password - This is the password you submitted when your installed WordPress into your account. If you need to look it up, it can be found within the wp-config.php file with your WordPress installation. If you need help determining your MySql password, please let us know.
Your MySql Server - All WordPress users are using the mysql5.datarealm.com server, so you must be sure to select it from the drop down menu -
Once you have entered the required information, click GO.
2) You are now logged into to PhpMyAdmin. In the lefthand frame, you will see the following -
Your Wordpress database is listed in this lefthand menu. It’s the link with the “WP” prefix.
Note in the example above, you see “WP_dris”. This is the Wordpress db for the account ‘dris’. Your Wordpress db will be listed like so, “WP_username”, so if your username is “bob”, you will see “WP_bob”. Please ignore the Database called “information_schema”.
To begin, click on your WP database link.
3) In the left hand frame, you should now see the expanded list of all of the tables in your database. It will look something like this -
Now, please focus on the new set of options in the righthand frame, specificity these tabs -
Select the Export tab -
4) You will now see a set of options in the main frame. First, turn your attention to these -
By default, all of your WordPress data tables will be selected. If you happen to have tables that are not related to your Wordpress installation, you may wish to “Unselect All” and manually select your Wordpress tables. If you only use Mysql for your Wordpress installation, just leave the selection as is or to be sure, to click the Select All link.
Additionally, please be that the SQL radio button is selected.
5) Now, there are many settings under Options in the main frame, but you can leave these all with their defaults. Please focus on the Save As File”area. Be sure to click in the box to the right of the words Save As File. Leave all the other settings as is. It should look like this -
Please note - if you have a very large database, you may want to consider using a compression method.
6) Once you have all these settings ready, it’s time to save the file. Look for the small GO button in the bottom right hand corner - - Click this button!
7) Your local computer will now prompt you to select a location for downloading and saving your database backup. Select a place you will be able to easily find the data when you need it and follow the prompts to save to your computer.
You are done!
Great News! There are several WordPress Plugins for doing automated backups (and restorations) of your site and database files. As always, it’s important to select Plugins are that from reputable sources. We recommend searching the WordPress Plugin directory to find the Plugin that will work best for you.
Search the WordPress Plugin directory (http://wordpress.org/plugins/) or go directly to a list of Backup Plugins (http://wordpress.org/plugins/tags/backup).