Question

Error in importing mysql file using command line

Posted September 24, 2021 85 views
UbuntuCentOSMySQLDebianBackupsMariaDBDatabases

Thank you for these useful commands
I try to import a large SQL file but I have this error

<b>Fatal error</b>:  Maximum execution time of 300 seconds exceeded in <b>C:inNMPWW

I tried to increase maxexecutiontime in php.ini
but the error did not fixed.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer

mysql -u root -p xxxxdb < xxxdb_file.sql