Server Change & MYsql Restore Error

[bdwebmaster]

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
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

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

[robfico]

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.