By Road Runner on
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
strange error when trying to import database
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
subscribing :P Does anyone
subscribing :P
Does anyone know what is to be done?
I solved it, the problem is
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!