You should move the database via SSH
mysqldump -u DATABASE_USERNAME -p DATABSE_NAME > DATABASE_NAME.SQL
It'll prompt you for password.
then scp DATABASE_NAME.SQL username@new_server_ip_address:/
then it'll ask for your new server password.
That will move the database directly from old server to new server and place it in the / directory
simply create the database on your new server, and restore it using this command
mysql -u DATABASE_USERNAME -p DATABASE_NAME < /DATABASE_NAME.SQL
new database moved, and restored.
|