Database (.sql) imports only partially

aaP_inc234

I haven't been able to import a database from an sql file. I've tried both local import and the terminal. Same result.

The file contains approx 2 million rows (500MB). The first part (90-150k rows) was imported immediately. The rest never appeared. Tried several times.

What could possibly cause this to happen?

aaPanel 7.0.16
Nginx, MySQL, phpMyAdmin

aaPanel_Kern

Hello, is there any error message? If the data is large, it is recommended that you use the command line to restore it

aaP_inc234

aaPanel_Kern No errors. I waited until finished. I used a command line like mysql -u demo2 -p demo2 < /www/server/mysql/bin/post_list.sql

aaPanel_Kern

Hello,
Is it normal to import using the command line?

aaP_inc234

SOLVED

After installing aaPanel on a higher performance hosting, the import was completed successfully. So it was either the server capabilities issues or something wrong with my setup.