如何使用PHP在服务器mysql中导入大型sql文件（108MB）？

Question

I have a 108MB SQL file, how can i import this file in server using PHP Script?

I try to do this, but no result

mysql -h 213.xyz.200.xx -u myUsername -p MyPassword MyDatabase < temporarytable.sql

Answer 1

Take the space out after the -p or don't put the password in at all and it will prompt you for it.

mysql -h 213.xyz.200.xx -u myUsername -pMyPassword MyDatabase < temporarytable.sql