A course of backup and restore of MySQL database in WDCP

Now only through the WDCP panel with the database backup, and then restore functionality, you can solve the problem of backup of larger databases, and relatively complete.

First, WDCP database backup

In the list of databases, select the database you want to back up, see a similar image above, and then back up after you click Back. In the same way, we can also use the WDCP panel to back up the site files, and there are similar backup links in the site list.

Second, WDCP Web site database restore

We download the first step of the database to the local, and then when the need to relocate the site to restore data, first set up the database users, and then need to pause the database link.

The code is as follows	Copy Code
Service Mysqld Stop

Then put our backup database compression package on the current MySQL version of the corresponding database name in the Var directory, you need to extract to the present file.

The code is as follows	Copy Code
Service mysqld Restart

Then you will need to restart the MySQL link.

In this way, we can use the WDCP panel to compare the site data to a complete backup