database error when moving site

[izan]

I'm moving my site from its current webhost to a new host (the new host is doing the move). The classifieds and forum (vb3) were functioning okay before I temporarily closed them while the site is being moved. They both use the same database. The new host sent me the following email:


We have transferred all the files. We also backed-up the database ****Forum in .sql file. But while restoring this backup we are getting following error.
------------------------------------
ERROR 1064 at line 13: 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 CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line
-------------------------------------
As this is a syntax error you will have to make changes to your database accordingly. Please do the necessary changes and upload the .sql file for the same to public_html folder. We will restore it for you. Please let us know when you finish.

What do I need to do to fix this so I can complete the move and reinstate my website?

Thank you.

[Frost]

What version of MySQL does your old host use?
What version of MySQL does your new host use?

[b6gm6n]

hi..

Sounds like the backup could be slightly corrupted, i would upload the .sql file to your new host in ASCII then advise your new host to install it, they may find an error, so you could try this yourself via phpmyadmin or via a cron command (if your host has cron features) if you find the line number of where the syntax error is you could open the sql file yourself via a text editor and edit the line or comment it out and re-upload it, i know this may a problem for the proper functioning of both apps but it's an option

see a guide for cron (restore database) below
---
Hi..

If you have a large .sql database to restore (over 10 megs for example) you can do this via your cpanel and cronjobs.

your host hasn't enabled shell access, and your phpmyadmin will only allow you to upload a few megs...so what to do?

Create a directory outside of your 'public_html' dir (in this example i'm gonna call my directory 'backup')

Upload your .sql database file to that 'backup' dir

Goto your cpanel > cronjobs

and simply type in this command :
---------------------------------

Content visible to verified customers only.

---------------------------------

You may be different to me in the '/home2/' section
and remember you have to have an exsiting database to restore into.... do this via cpanel > mysqldatabases (remember the name used for the command above database_name

uploadfile.sql change the name to YOUR upload sql file

and thats it..

-T

[Frost]

Maybe it'd be better to read this and this to see if there is a backwards compatibility issue before looking for corruption.