anybody know why I get error when I try to import my production data base. I copied using phpmyadmin but when I import into local MAMP using phpmyadmin I get following error

Error

SQL query:

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

MySQL said: Documentation
#1065 - Query was empty

TIA for any insight.

Comments

Road Runner’s picture

anybody know why I get error when I try to import my production data base. I copied using phpmyadmin but when I import into local MAMP using phpmyadmin I get following error

Error

SQL query:

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

MySQL said: Documentation
#1065 - Query was empty

oneiropolos’s picture

subscribing :P
Does anyone know what is to be done?

oneiropolos’s picture

I solved it, the problem is based on an incompatibility of the different MySQL versions.
I was using Apache2triad in the beginning (in the local machine) but it had some outdated MySQL and phpmyadmin components, so after uninstalling that and installing WAMP instead, I was able to import my .sql database with no problem!