Mysql Question.....
 

New Version on one box , older version on other box

Trying to take DB dump from new box and put into old box.

Now I will need to upgrade Mysql on older box correct? Seem to be getting errors importing the dump..

The dump should be backwards compatible - there should be no problem importing a dump to an older MySql version. A dump file should just contain data, and create and alter statements - nothing special.

Have you tried a backup and restore, or just the dump file? Restore could screw up, as could directly attaching a newer DB.

What errors are you seeing?

dumps are from phpMyadmin

error upon import is "No SQL query!"

do in phpmyadmin.

I am yo :Oh crap :Oh crap

Would it be possible to look at your dump file?

what error are you getting?

How big is the DB? Can you do it in steps (like by table/data) until it throws the error?

Example, run a basic INSERT command and see if that works, just create a table or something. If that works try to poulate the table with data. if you don't get the error then move to the next query until it breaks.

you prob have a field with a timestamp. phpmyadmin has a problem with that.

do the dump and delete all the stuf behind the comma where the timestamp field is and replace it with the term : default.

hope this solves your problem.