Use WDCP panel to back up MYSQL database and completely restore website data process

Last Friday, I helped a netizen solve the relocation of the Magento program. There was a security vulnerability in the original WDCP panel in the original Linode VPS (preventing WDCP panel security issues and thoroughly checking and solving security vulnerabilities). Prepare to back up the data and then restart Make the system and install the WDCP panel in the same way to restore the website. For website backup and restoration, the general method is to back up web page files and databases. After the environment is restructured, place the web page files, import the database, and then modify the new database connection. This can generally solve the problem. However, I encountered a little trouble this time. It may be that the network delay problem caused the database backup to be incomplete. Whether it was exported directly by PHPMYADMIN or backed up using Imperial Backup King, the data could not be restored completely.

Now only the database backup and restore function that comes with the WDCP panel can solve the problem of backing up larger databases, and it is relatively complete.

Article Directory Hide

First, WDCP database backup

Second, WDCP website database restoration

First, WDCP database backup

In the database list, select the database that needs to be backed up. When you see something like the picture above, click Backup to back up. Similarly, we can also back up website files through the WDCP panel, and there are similar backup links in the website list.

Second, WDCP website database restoration

We download the database backed up in the first step to the local, and then when we need to move the website to restore the data, we first create a database user, and then we need to pause the database connection first.

service mysqld stop

Then upload the compressed database package we backed up to the corresponding database name in the var directory of the current MYSQL version, and need to unzip it to the current file.

service mysqld restart

Then you also need to restart the MYSQL link.

In this way, we can use the WDCP panel to make a relatively complete backup of website data.

Recommended site search: Ministry of Industry and Information Technology domain name registration, anti-attack IP, US website server, 6 yuan per year cloud server, domain name registration website, mainland China PHP space free domain name registration platform, foreign server , permanent free server address, website registration system,