MOVE MySQL TO NEW SERVER

Ubuntu LTS is supported for 5 years. This means that occasionally a new server has to be created and the database copied. It will take some time depending on several factors.

mysqldump -u root -p –opt [database name] > [database name].sql

The dump SQL file can then be copied to the new machine (disk). Then it can be loaded up.

mysql -u root -p newdatabase < /path/to/newdatabase.sql

That is all that is needed. You can gzip the file if you are transferring it over a slow internet connection.

With Linux scp is available to securely copy, but Azure where we operate has other secure options to move data as well.

https://dev.mysql.com/doc/refman/5.7/en/copying-databases.html