I try to execute query from PHP / CMD / Terminal
mysql -u admin --password='jaydip' --host='localhost' 'mg_kansagra' < '/var/www/html/magento/dump/db.sql'
Its show me following error
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 3167 (HY000) at line 17: The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled; see the documentation for 'show_compatibility_56'
ANSWER
Run the following query in your MySQL database:
set @@global.show_compatibility_56=ON;
No comments:
Post a Comment