Mysql Question.....

[Juicy D. Links]

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..

[fusionx]

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?

[Juicy D. Links]

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!"

[2HousePlague]

do in phpmyadmin.

[Juicy D. Links]

do in phpmyadmin.

I am yo

[fusionx]

dumps are from phpMyadmin

error upon import is "No SQL query!"

Would it be possible to look at your dump file?

[pornpf69]

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..

what error are you getting?

[newbreed]

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.

[grumpy]

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.