In fact, it is very important because you might never know when your data will be crashed or even hacked. I used to ignore backing-up before because there’s so much to do. Don’t get me wrong, I was saying that because I was being ignorant and do not want to learn.

After learning it, backing-up my data is part of my scheduled activities. I will only talk about Cpanel, MYSQL and PHPmyAdmin which is where I am familiar with. Other than this, sorry guys.

Normally a good hosting company will eventually back-up the entire server but it will take time to get those data from those guys. Therefore, creating your back-up data is important.

How to back-up your Wordpress data and files?

Basically, you will use a combination of both: FTP clients (i.e. FileZilla) and your website back-up software (as shown below). My advice would be to keep more than one back-up copy, just in case its corrupted.

Step 1: Now, let\’s start with backing-up your database. To do this, I will be using PHPMyAdmin.

• Start by accessing your cpanel >> Click MYSQL Database icon. This will bring you to MySQL Account Maintenance page
Click MySQL Database
This is how MySQL Account Maintenance page look like
• In the MySQL Account Maintenance page, scroll down and look for phpMyAdmin. Go ahead click it.
Click the MyPHPAdmin

• Now click the database as shown in the pic below


• Once you click “Database”, you will see several database, select only the data that is related to your wordpress

• This will bring you to your database page. Now, click Export

• This is the important part. In the Export column, select the database inside the column and select “SQL”. Hold Ctrl and select if more than one (it will be blue if you’ve selected it). In my case, I select all.

• In the structure and data column, select the column as shown in the pic below

• In the Save as File column, select the column as shown in the pic below and click “GO”. Save the file in your computer

• Repeat the above, but select compression to zipped, as shown below and click “GO”. Again, Save the file in your computer

• By now, you would have two database in your computer. Congrats, you’ve back-up your Wordpress data

Note: The steps above do not save your other folders such as your pictures. The step above only backs-up your Wordpress database. To back-up your other folders, use FTP to back-up the selected folders into your computer.