Busy — Fri, 10 Mar 2006 21:09:54 +0000

I have had same problem, i remember if I downloaded a sql, csf or whatever it wouldn't upload but if I returned the results on screen and copy and pasted it worked. I think that time it was a size issue

confusedxx — Fri, 10 Mar 2006 11:52:03 +0000

Hi Busy and thanks for the reply. I could understand the versions of sql being different, but the databases are on the same domain/host and even trying to import the sql extract to the db from which I took it, failed.

Busy — Fri, 10 Mar 2006 09:21:08 +0000

The reason I have come across for this is the versions of mysql are different.

depending on the size of the databse you can edit the .sql file and removed the ` (back comma under the ~ which is before the 1) and possibliy the empty defaults.
Other options included backup seperate tables (each table seperatly), and/or choose full inserts which can sometimes do the trick.

someone else maybe (hopefully) have an easier answer for you