mysql export backup, import restore, and migration (applicable to virtual hosting)

It is recommended to use database management software to perform operations; this can avoid timeouts and also supports large file import Use mysql management software to import, restore/export, and back up mysql

I. Backup

Export SQL File Backup

1. Virtual Host Management--Manage--Database Click the Import/Export via SQL button

Select the Export/Backup button to export a backup. After exporting, download the exported sql file via an ftp connection.

II. Restore

SQL File Restore

Please first upload the sql file to the space wwwroot directory, Virtual Host Management--Manage--Database--Import/Export via sql file, and select Import.

Data migration: Download the backed-up database to the local computer, then restore it using the restore method in the above tutorial.