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

DONE.

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

(Visited 1 times, 1 visits today)
Tags: ,
Category: SUSE Linux Enterprise Server, Technical Solutions, Virtualization
This entry was posted Thursday, 9 July, 2009 at 1:14 pm
You can follow any responses to this entry via RSS.

Comments

  • 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. Required fields are marked *