Solution:
Open the SQL file and add the following in the first line of the SQL file
/*!40101 SET NAMES UTF8 * *;
Save SQL file as UTF-8 NO BOM format
Upload the SQL file via FTP, and put it in the root directory.
Enter your cpanel, see the Cron Jobs icon, click In, and then select Advanced (Unix Style)
Because only need to run once, so minute, Hour, day, Month all fill in ready to run the specific time, leave two minutes margin on the line (if the virtual host is not local, you can check the host time on the FTP), weekday fill * No. command to fill in the commands to be run, the import command:
Mysql-u User name-p password [h database host] Database < database backup. sql
Suppose the IP of the remote host is: 10.0.0.1, the username is root, and the password is 123. Type the following command:
Mysql-h10.0.0.1-uroot-p123
Note:
You can have no space with root, and the rest is the same. For example, my settings are as follows:
Mysql-ucpanel123_cpuser-pcpanel-hlocalhost CPANEL123_CP
Then check the import in the phpMyAdmin. This way to import SQL files quickly, I wish you success.