This step is run on your OLD server
Next, you need to move your MySQL database. You can do this by first making a database dump on the old server, and then importing the dump on the new server.
mysqldump --opt -Q --hex-blob -u<user> -p<pass> <dbname> > db-backup.sql
You now need to move the database dump (db-backup.sql) from your old server to your new server (e.g. via SFTP). You may wish to gzip/zip the export to make the transfer quicker.
This step is run on your NEW server
You now need to import the dump into the empty database you cleaned in the 2nd step. Please check that the database is completly empty (i.e. no tables at all). If there are any tables, the process will fail.
mysql -u<user> -p<pass> <database> < db-backup.sql
You can confirm the database username, password and database name inside the
If you have a seperate database server, you can simply copy the
/config/config.database.php file from your OLD server to your NEW server.