Knowledgebase: Wordpress Tutorials
How to backup WordPress Files and Database
Posted by RAJU K, Last modified by RAJU K on 07 March 2013 08:59 PM

How to backup up WordPress Files and Database:

The most important thing in managing wordpress site is backups!  It's amazing how many people don't do this. WordPress security landscape is changing and you can never be 100% safe. Making regular backups is the only real way to be sure you can recover from disaster if it ever strikes.

Let's see how you can backup your wordpress site.

Your WordPress database contains every post, every comment and every link you have on your blog. If your database gets erased or corrupted, you stand to lose everything you have written. There are many reasons why this could happen and not all are things you can control. With a proper backup of your WordPress database and files, you can quickly restore things back to normal.

There are two parts to backing up your WordPress site: Database and Files. You need to back up the entire site, and you need to back up your WordPress database.

We will start with backing up your WordPress site Files.


Copy WordPress Files to Your Desktop:

Your WordPress site consists of the following:

  1. WordPress Core Installation
  2. WordPress Plugins
  3. WordPress Themes
  4. Images and Files
  5. JavaScript and PHP scripts, and other code files
  6. Additional Files and Static Web Pages
All of these are used in various combinations to generate your website.

Using FTP Clients    you can copy the files to a folder on your computer. Once there, you can zip or compress them into a zip file to save space, allowing you to keep several versions.


WordPress DataBase Backup with phpMyAdmin:


The database contains your posts and a lot of data generated on your site, but it does not include the above elements that all come together to create the look and information on your site. These need to be saved.

The following is a very simple version of how to use phpMyAdmin   to back up your WordPress database.

1. Begin by clicking database in your phpMyAdmin panel. (It may not be necessary to do this, depending on your version of PHPMyAdmin)

phpMyAdmin Databases

2. You may have several databases. Click the one that holds your WordPress data, the database you created when you installed WordPress  (In older versions this may be done through a pull-down menu.)

3. Below is a picture of the default tables in the Structure view tab. You may have more tables -- this would happen if you have any statistics plugins or anti-spam plugins.

4. Click "Export". (The next picture shows the Export tab view.)

  1. Select All the tables, and check the SQL radio button.
  2. Check the "Add DROP TABLE" box. (This can be useful for over-writing an existing database.)
  3. Check the "Add IF NOT EXISTS" check box. (This prevents errors during restores if the tables are already there.) You can optionally check the "Complete inserts" box. (Though it won't matter too much if you don't.) You can optionally check the Extended Inserts if you wish. (This gives a smaller, but less readable, output file.)
  4. Check the "Save as File" box
  5. Check the "None" for compression. If your database is very large use a compression method.
  6. Click Go. The data will now be saved into your computer.

5. Keep these files safe, copied and stored in separate places on separate media.

Restoring Your Database From Backup

Restore Process

Using phpMyAdmin, follow the steps below to restore a MySQL database.

  1. Login to phpMyAdmin. ( cPanel )
  2. Click databases, and select the database that you will be importing your data into.
  3. You will then see either a list of tables already inside that database or a screen that says no tables exist. This depends on your setup.
  4. Across the top of the screen will be a row of tabs. Click the Import tab.
  5. On the next screen will be a Location of Text File box, and next to that a button named Browse.
  6. Click Browse. Locate the backup file stored on your computer.
  7. Make sure the SQL radio button is checked.
  8. Click the Go button.

Now grab a coffee. This bit takes a while. Eventually you will see a success screen. :)

If you get an error message while backup or restore, your best bet is to open helpdesk ticket at

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).