MySQL import error

Ask Time：2011-02-25T18:31:49 Author：Kaspars Milbergs

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

Author:Kaspars Milbergs，eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/5116133/mysql-import-error

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

MySQL import error

mysql database data import error

Error on MySQL Data Import

import CSV to MySQL error

Sqoop MySQL Data import error