Elastic Cloud Server innodb single database recovery method

Elastic Cloud Server innodb Single Database Recovery Method

1. First attach the backup disk, assign it as drive E, then create the service

sc create mysqlbak binpath= "E:\SOFT_PHP_PACKAGE\mysql\bin\mysqld.exe"

Change the listening port in my.ini to 3307, then start the service

E:\SOFT_PHP_PACKAGE\mysql\bin\mysql.exe -u username -p password  Log in to verify

use database;

show tables; If all tables can be listed, it is correct.

Then export: E:\SOFT_PHP_PACKAGE\mysql\bin\mysqldump.exe -u username -p password database_name>D:\xxx.sql

2. First clear the database tables, then use the command to import.

Import: mysql -u username -p password database_name<D:\xxx.sql

Data is at risk. Please back up regularly and have a complete backup mechanism. If you need our company to handle it, the fee is 50 yuan/time. Please provide explicit authorization in the ticket.