I am trying to import a wordpress
database to other server, but that server have old phpMyAdmin 2.5.6
version.
When I am importing that database I am getting
error :#1064 - You have an error in your SQL syntax near 'SQL_MODE="NO_AUTO_VALUE_ON_ZERO"' at line 1
When I comment that line out, I get another error.
Is there any way to get it work on this server?
Thanks, I fixed it.
I used a SQL compatibility mode - MYSQL323
keatch :
This is not a phpmyadmin problem, but is related to your MySQL export.\nWhen you have exported the database, how do you have setup the export method ? Seems like you have a Mysql 5.0 dump and try to import in a MySQL versione that is older.\n\nI suggest you to export your database with \"Compatibiliy Mode\" NONE, if you use phpmyadmin to export it!",
2011-02-25T10:36:02