Pages

MySql Is There a Limit on the size of a query

Monday, May 5, 2014

I am trying to restore a MySql database I had from version 3 of MySql from backups I saved. I have installed version 5.6.17. When I try to create a table from a file that is 60+ lines long it fails with ERROR 1064 in line 22. If I delete line 22 it complains about the new line 22.

I trust the sql file I am using because I got it from a backup of the old MySql.

Is ther a limit that can be increased to allow this table create to work?