I always import the database file to the server with the way that I'm using again. But this time when I want to do this I get this following error :
SQL query:
phpMyAdmin SQL Dump SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"
MySQL said: Documentation
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
Does anyone can help me to solve this problem? I always use this method but this time I have this error.
Thanks in advance
In this case it seems the problem is because of your MYSQL version. As I asked you in the comment below of your question, it seems you are using WAMPSERVER. So because of your WAMPSERVER version it has different version for your MYSQL.
The server you're trying to import may has newer version of MYSQL. So you can simply update your WAMP and then you have updated your MYSQL version. Then try to import them to the server. so you can fix this problem.
Hope it helps
Always try to be update
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments