*****Before dumping bring the database offline so no one can use it.*****
Otherwise you may have doom and disaster
I recommend unplugging the cable from all NIC(s) during the mysqldump process.
I assume NO LIABILITY of any kind, but I have done this before for other programs.
LinuxMCE PC
mysqldump -c -u <username> -p <database name> >/path-of output/linuxmce-backup.sql
Obviously you need to supply valid credentials including password.
There is a command line switch to dump all databases, but I forgot what that was try mysqldump --help.
(something like --all-databases)
You may/or may not have to add "connect <database name>;" as the first line of code. If you use the all switch you won't have to, but if you use the "all" you could wipe out existing username and passwords if your not careful. ***If both systems have a user joe some of the data could be overlayed especially the password.**
***Other bad things can occur****
copy linuxmce-backup.sql to your other machine.
I also recommend(strongly!!) using the same procedure to back up your other database in case something goes horribly wrong.
You need to find and use the "all database" switch for your original database, on the destination pc, because that will backup usernames,passwords, and permissions.
Destination PC
EITHER
mysqldump -c -u <username> -p <database name> >/path-of output/orginal-db-on-destination-pc.sql
OR (better)
mysqldump -c -u <username> -p --all-databases >/path-of output/orginal-db-on-destination-pc.sql
Using the same steps with a different filename.
Now hopefully you backed up both of them in case of disaster.
No backup=No recovery
mysql -u <username> -p <database name> /path-to existing file/linuxmce-backup.sql
If your doing all you omitted the database name.
Specify credentials and wait for the process to complete.
If something goes horribly wrong you'll be glad you backed up.
---In case of doom as disaster:----------
mysql -u root -p
delete each affect database one at a time
commit;
exit or bye I forget which.
mysql -u root -p <database name> </path-of output/orginal-db-on-destination-pc.sql
Specify credentials and wait for the process to complete.
You are now restored
---End of doom and disaster---------------
I have no idea where the setting is located, but all thats left is to change the IP address that LinuxMCE is trying to connect to from localhost to the ip address of your other machine and your done.
Assuming you found this location you and now migrated.
