Tips in Backing Up Your WordPress Site
June 21st, 2012 by admin | Type: Standard

Coming up with high quality content for any type of website could take weeks, even months of planning, writing, editing, and posting. Even with the use of WordPress or other blogging tool, you can still spend a long time in creating the site’s materials. Not having a backup for all these means you are putting all of your effort and time at risk. If your website suddenly gets hacked or you make any mistake in configuring your site, you may have to start over. This is the reason why many experts advice webmasters to regularly back up their websites.

Popular misconception in creating a website backup

Some web hosts offer free regular backing up of WordPress sites. However, it is still a good idea to have a local back up of your own. This way, should your website suddenly go offline and stays empty for any reason; you have a copy that is ready to be loaded anytime. In order to properly create a copy of the WordPress site, you will need to back up all of the files, including your database. In short, don’t just make a copy of your WordPress files. Your blog is driven by its mySQL database. Without this, your blog will basically be empty. Even if you have all the files, you will still not be able to restore the WordPress site without the database. What most do not know is that this database is separate from the files on the hosting server. Since the files and the database are separate, they need to be copied separately.

First phase in creating your WordPress site backup

The first thing to do is to make a copy of the WordPress files. This is fairly simple. Here are the steps:

1. Connect to the host of your blog via an FTP program. A good example of such is FileZilla. You will need to provide your FTP username together with the password.
2. Once a connection has been established, go to a local directory and view the left pane. Here, you will be able to see the desired destination of your copied files.
3. Look at the right pane and select all of the files from the host. To begin the transfer, simply right click on the files and click on the download option.

You may also drag the files towards the desired destination, from the right towards the left pane.
4. Once the download is complete, compress the WordPress files using any compression program of your choice.

Second Phase of the backup

Now that you have the WordPress files saved, you can now move on to the more important part. To save the website’s mySQL database, just follow these steps:

1. Log into your mySQL administration’s Web interface. This is more commonly known as the phpMyAdmin. If you are not aware of the steps in logging in or accessing the interface, contact your hosting service provider for instructions.
2. Choose the WordPress database from the list of databases found in the left column of the admin panel.
3. Go to the “Export” tab and click on the “Select All” option. Choose “SQL”. Check all the boxes for the following:

  • Add AUTO_INCREMENT value
  • Add IF NOT EXISTS
  • Add DROP TABLE / VIEW / PROCEDURE / FUNCTION
  • Enclose table and field names with back quotes
  • Complete inserts
  • Save file as

4. Click on the “Go” option to begin exporting the database.
5. Enter a destination for the file when prompted.

Some reminders for the backing up process

If you are not knowledgeable with the other areas shown on the dashboard, do not fiddle with it. Making changes on the database can be costly since it is permanent. Once the backup is complete, burn the files onto a DVD or CD.