4 methods for common Linux VPS hosts to back up MYSQL databases

After transitioning from a virtual host to a VPS, the average webmaster may feel that the cost of operation and maintenance time is still relatively large. Although sometimes a cheap VPS is slightly cheaper than a virtual host, the operation and maintenance of a VPS is more expensive than a virtual host. The host has something to worry about. For example, in terms of VPS maintenance and data backup, if the regular automatic backup function is not used but manual backup is used, the backup cycle should be much shorter than that of the virtual host. For web page files, we can compress and package them for FTP downloading. The backup of the MYSQL database requires special care. Once the backup is missing by mistake, it may cause a lot of losses when it is really necessary to restore it.

The following is a summary of the MYSQL database backup methods for Linux VPS hosting website environments that are commonly used by most users:

First, PHPMYADMIN export method

Whether we are using the WEB panel or the one-click package, PHPMYADMIN should be installed. We can log in directly and export the database of a separate website. Before proceeding, in order to reduce unnecessary database capacity as much as possible, we can clean and optimize the database file, and then export the database.

Second, mysqldump command export

You can refer to \\"Linux VPS using commands to quickly import/backup MYSQL database\\", use SSH to log in to the VPS, then use the mysqldump command to export the database to the root directory, and then download it to a local backup through FTP.

Third, download the original MYSQL database file

The method of directly downloading the database file may not be commonly used, but it is a good method. Basically, the database restoration will not be lost. Find it according to the panel or script path we use. For example, the AMH panel is under the database name corresponding to /usr/local/mysql/data/, and the original database file of the WDCP panel is in the database name folder corresponding to /www/wdlinux/mysql/var. . Download it locally, and then upload and replace it if you need to restore the corresponding database name.

Fourth, use Imperial Backup King backup software

Empire Backup King software is also a good MYSQL database backup software. We can download it from the official website, and then put it in the root directory of the website. After opening and logging in, set the binding database link file. After backing up the data, download Backup King to the local area. If you need to restore the database, you can directly bind the new database and then choose to restore the database directory.

If it is a relatively large website, or a more important website, we can use multiple methods to back up. It is best to test that there is no problem with data recovery, and then delete the old data, because it is still scary if it cannot be restored. things.

Recommended site searches: Hong Kong cloud host, station group server rental, foreign server rental price, Hong Kong host high defense, US high defense space, domain name transfer, cloud host, telecom host rental, server, Korean independent server,