How to import the sql from different edition of mysql?
Posted by: moo611 (122.128.215.---)
Date: December 15, 2017 03:53AM

I and my friend use different edition of wamp server.When he exports the sql to me,I find that I can't import the sql to my mysql.It says" #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'phpMyAdmin SQL Dump SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"' at line 1"
How to solve this problem?

Options: ReplyQuote
Re: How to import the sql from different edition of mysql?
Posted by: Otomatic (Moderator)
Date: December 15, 2017 09:30AM

Hi,

Set sql_mode to none in both environments.
Left-clic wampmanager tray icon -> MySQL -> MySQL settings -> sql_mode -> sql_mode->none

Which corresponds, in the my.ini file to:

sql-mode=""

Warning : If there is no line or if it is commented, it corresponds to the default mode_sql whose values are different in terms of the MySQL versions.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.3 32 bit - Apache 2.4.34 - PHP 7.2.8/7.1.20/7.0.31/5.6.37 - MySQL 5.7.23 - MariaDB 10.3.8
Wampserver 3.1.3 64 bit - Apache 2.4.34 - PHP 7.2.8/7.1.20/7.0.31/5.6.37 - MySQL 5.7.23 - MariaDB 10.3.8
PhPMyadmin 4.8.2 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote


Sorry, only registered users may post in this forum.