how to fix error #1064 ?

[supermonkey1]

i have zen-cart database in my computer
I export into a file
then when i try to import this database file to my webhost
i get such error
how to fix it?
thx

#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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 35

[Wouter]

Please give the full query.


"supermonkey1" <fu********@hotmail.com> wrote in message
news:f5**************************@posting.google.c om...
:i have zen-cart database in my computer
: I export into a file
: then when i try to import this database file to my webhost
: i get such error
: how to fix it?
: thx
:
: #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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 35

[Wendell Jones]

supermonkey1 wrote:

i have zen-cart database in my computer
I export into a file
then when i try to import this database file to my webhost
i get such error
how to fix it?
thx

#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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 35

Need full query but my guess is that your autoincrement variable is the
problem. I would run a test by removing the autoincrement part of the
query and re-run it to see if you get the error but I think you won't.
I do not rememeber how to fix the incrementation though after the
restore from the file. :-(

Regards,

Wendell

[Wouter]

It can also be that the charset should be quoted; 'latin1'
But he did probable fix it, because he did not post the full query :)
"Wendell Jones" <wp*******@yahoo.com> wrote in message
news:nM********************@comcast.com...
: supermonkey1 wrote:
: > i have zen-cart database in my computer
: > I export into a file
: > then when i try to import this database file to my webhost
: > i get such error
: > how to fix it?
: > thx
: >
: > #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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 35
: Need full query but my guess is that your autoincrement variable is the
: problem. I would run a test by removing the autoincrement part of the
: query and re-run it to see if you get the error but I think you won't.
: I do not rememeber how to fix the incrementation though after the
: restore from the file. :-(
:
: Regards,
:
: Wendell