Confused: MySQL BIG Database Import and Export Problems

We have a large database with many data records. To achieve customized backup every night, we have a script that can be exported within one minute. The script is as follows: backup big database saas-skyeyes to d: mysql. sqlmysqldump-uxzknet-psaas-skyeyes -- default-character-setutf8 -- quick -- extended-insertfa

We have a large database with many data records. To achieve customized backup every night, we have a script that can be exported within one minute. The script is as follows: backup big database saas-skyeyes to d:/mysql. SQL mysqldump-uxzknet-p saas-skyeyes -- default-character-set = utf8 -- quick -- extended-insert = fa

We have a large database with many data records. To achieve customized backup every night, we have a script that can be exported within one minute. The script is as follows:

Backup big database saas-skyeyes to d:/mysql. SQL

Mysqldump-uxzknet-p saas-skyeyes -- default-character-set = utf8 -- quick -- extended-insert = false -- quick> d:/mysql. SQL


Export File 2.7 GB


Restore the database SQL file to the test-importdb database.
Mysql-uxzknet-p test-importdb
I recorded the Import and Export time:
Friday 19:42:45. 17

Sunday 00:44:07. 82

Crazy. It's been 28 hours. Which MySQL master can give you some advice.