Why do I get an error from phpmyadmin in HeidiSQL?
| User, date | Message |
|---|---|
|
Written by ConfusedUser
10 months ago Category: Import/Export 2 posts since Fri, 20 Jul 12 |
When trying to locally import a ~40MB SQL file using the HediSQL GUI I get the following error after about 5 seconds: exception message : SQL Error (1064): 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 'Fatal error: Maximum execution time of 60 seconds exceeded in /var/www/phpMyAdmi' at line 112. It is strange that HeidiSQL depends on something in the phpMyAdmin directory. It is also strange that I get the 60 second execution timeout when I changed it to 3000 seconds. It is ALSO strange that it happens after 5 seconds. How can this be connected to HeidiSQL? |
|
Written by ConfusedUser
10 months ago 2 posts since Fri, 20 Jul 12 |
Sorry my bad, after a few hours (should have been minutes!) I found the problem. When exporting the DB from the first place it timed out and wrote that error line as a last row. Of course SQL can't process it! |
|
Written by ansgar
10 months ago 3950 posts since Fri, 07 Apr 06 |
Hehe, yes that's indeed a confusing dump. |
|
Please login to leave a reply, or register at first. |