Moving a MySQL Database to a new VM or Physical SUSE Linux Enterprise Server


Scenario: We moved from VMware ESX to Citrix XenServer 5.5….We had to get our GroupLink everything HelpDesk to a new VM…..Instead of a V2V process we quickly spun up a new SLES10 Server (15 seconds) and copied the MySQL Database over to the new server:

  1. SSH to Exsiting MySQL Server .. and type:
  2. mysqldump -u root -p DatabaseName > DatabaseName.sql
  3. Copy the DatabaseName.sql file to the new server and type:
  4. mysqladmin -u root -p CREATE DatabaseName
  5. mysql -u root -p DatabaseName < DatabaseName.sql

Here is the Copy Process from step 3 above.

  1. Find the dir on the src server which was /apps in this scenario..Now, ssh to the target server
  2. Issue scp -r root@sourceip:/dirname . (notice the space dot at the end)
  3. The server will ask for the root password
  4. Now Authenticate and the source data will be copied over to the new server in root/apps


Quickly ran the install of eHD against the database and ShaZaaaam. Done!

(Visited 1 times, 1 visits today)


  • grimlock says:

    Make sure the versions are the same major version of the database, and check the character encoding of the database. You could run into issues if the old server was using something like latin1 for the encoding and the new database was using UTF8 if you didn’t convert it first.

  • Leave a Reply

    Your email address will not be published.