Article
3090
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:
- SSH to Exsiting MySQL Server .. and type:
- mysqldump -u root -p DatabaseName > DatabaseName.sql
- Copy the DatabaseName.sql file to the new server and type:
- mysqladmin -u root -p CREATE DatabaseName
- mysql -u root -p DatabaseName < DatabaseName.sql
Here is the Copy Process from step 3 above.
- Find the dir on the src server which was /apps in this scenario..Now, ssh to the target server
- Issue scp -r root@sourceip:/dirname . (notice the space dot at the end)
- The server will ask for the root password
- 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!
Disclaimer: As with everything else at Cool Solutions, this content is definitely not supported by Novell (so don't even think of calling Support if you try something and it blows up).
It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test, test, test before you do anything drastic with it.
Related Articles
User Comments
I would just add this
Submitted by grimlock on 10 July 2009 - 11:07am.
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.
- Be the first to comment! To leave a comment you need to Login or Register
1