Showing results for 
Search instead for 
Did you mean: 

Server Change & MYsql Restore Error

Server Change & MYsql Restore Error

Need help to restore a Magento Website into new server.

I already restore the files to new server and tried to restore the mysql via phpadmin..But everytime i try to import the mysql, i am getting the following error:


SQL query:

Warning : USING UNIQUE OPTION prefix pass instead of PASSWORD IS deprecated AND will be removed IN a future release.Please USE the FULL name instead.-- MySQL dump 10.13 Distrib 5.5.42, for Linux (x86_64)
-- Host: localhost Database: XXXXXX
-- ------------------------------------------------------
-- Server version 5.5.42-cll

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 'Warning: Using unique option prefix pass instead of password is deprecated and w' at line 1

Tags (1)

Re: Server Change & MYsql Restore Error

Edit the sql file in "vi" and remove the warning line. Also double check MySQL's my.cnf file to see if you ave a "pass=" line and change it to "password=" to worj with MySQL 5.5 or higher.