Backing up your website has always been important. The issue of backing up has been brought to the forefront of every small business owner with the hacking attack on Melbourne based hosting company Distribute IT.
The hackers also managed to delete all the backups for Distribute IT meaning that over 4,800 small businesses lost their websites due to the malicious attack on the company. Many of those companies did not have their own backups.
Those lucky enough to keep back ups of their website will be ok, but for those who lost their websites could prove to be a very costly and timely process in getting their websites back online.
Backing Up Your WordPress Website
There are two steps to backing up your site;
1. Copying your wordpress files (this means your theme, uploaded media files and plugins)
2. Backing up your database (which includes all of your page and blog post content)
NOTE: These instructions are only for those who are using cpanel webhosting.
Step One: Backing Up Your WordPress Files
To do this you will need an FTP client (I highly recommend FileZilla which is free to download).
- Open File Zilla and enter in your FTP details (Host, Username and Password) then hit Quick Connect. If you are unsure speak to your website host.
- Underneath you will see two sides of files. The right side are the files that live in your website and on the left are files that are stored on your PC.
- You need to create a backup file on your PC. Right click into the left hand side and click Create Directory. This is where you will copy your files to.
- Now you want to download a copy of your live website files (right hand side) to your PC. Usually the file will be called Public_HTML or httpdocs.
- Select this file so it is highlighted. Right click and select Download.
- The FTP client will then start downloading all your files to your PC.
- Once that is completed you can go onto the next step of Backing up your Database.
Step Two: Backing up you database
For this section login to your website’s cpanel area (usually the same logins as above).
1. Go to the myPHP option
2. Select Database from the main options
3. Then from here you select the database you want to back up. For example “test_wordpress”
4. This will bring up a lot of different files that are in the database.
Click the Export tab, generally the 5th tab across.
5. In the Export box you will need to select all of the files that are to be copied.
(NB: If you have other programs that use the same database please unselect these files). All files to do with wordpress files should be wp_file name.
6. Ensure that SQL is checked!
The SQL section – Tick the following boxes:
- ‘Add DROP TABLE / VIEW / PROCEDURE / FUNCTION’
- ‘Add IF NOT EXISTS”Add AUTO_INCREMENT’ and
- ‘Enclose table and field names with backquotes’
7. The DATA section
Leave the boxes inside this section unticked, but make sure to keep the checkbox next to the “DATA” heading checked.
8. Tick the ‘Save as file’ option, and leave the template name as is.
9. Now click ‘Go’ and you should be prompted for a file to download. Save the file to your computer. Depending on the database size, this may take a few moments.
If you don’t want to risk doing this yourself ask Picasso Media Group how we can help you. We can back up and store a copy of your website in case of emergency.