Maximum execution time of 300 seconds exceeded error while importing large MySQL database
Posted
by
Spacedust
on Server Fault
See other posts from Server Fault
or by Spacedust
Published on 2012-08-30T20:45:14Z
Indexed on
2012/08/30
21:40 UTC
Read the original article
Hit count: 285
I'm trying to import 641 MB MySQL database with a command:
mysql -u root -p ddamiane_fakty < domenyin_damian_fakty.sql
but I got an error:
ERROR 1064 (42000) at line 2351406: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<br />
<b>Fatal error</b>: Maximum execution time of 300 seconds exceeded in <b' at line 253
However limits are set much higher:
mysql> show global variables like "interactive_timeout";
+---------------------+-------+
| Variable_name | Value |
+---------------------+-------+
| interactive_timeout | 28800 |
+---------------------+-------+
1 row in set (0.00 sec)
and
mysql> show global variables like "wait_timeout";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout | 28800 |
+---------------+-------+
1 row in set (0.00 sec)
© Server Fault or respective owner