Posts: 369
Joined: Jan 2011
Reputation:
3
Hello
I happily use MySQL shared database with xbmc 12. I would like to move to Gotham, with option to eventually downgrade if it doesn't meet my needs. Let's say I will backup my current database and run Gotham. Will it upgrade my database, or fail?
How can I have two databases, old and new?
Posts: 942
Joined: Oct 2011
Reputation:
64
gibxxi
Posting Freak
Posts: 942
If you have a MySQL server setup correctly, and the User for the XBMC databases has the correct permissions, the DBs should be ported across to new versions automatically. The old (existing) databases aren't deleted, so all you would need to do to go back to your old setup (if required) in as far as the DBs are concerned, is to delete the newer ones.
Before migrating, I would however suggest doing a full backup with the XBMC Backup add-on to backup the rest of the XBMC settings, thumbnail cache, add-ons, and add-on settings before you do the upgrade.
To revert, uninstall XBMC, clear out any remaining files, and clean the profile folder (%Appdata%\XBMC on Windows), then install the previous version of XBMC, start it up, and install the XBMC Backup add-on from the official XBMC repository, then configure it to point to where you saved your previous backup, and do a restore.
Finally delete the newer MySQL DBs from the Gotham version, if required, from the MySQL server. HeidiSQL is a good tool for managing the MySQL server and is free.
Bear in mind that you will probably need to save your guisettings.xml and advancedsettings.xml files seperately from XBMC Backup, and restore these after the restore operation, by exiting XBMC then restoring those files. Personally, I make a seperate copy of ALL the xml files in the userdata folder (%AppData%/XBMC/userdata) and restore those seperately myself. Everything else I leave to XBMC Backup.
Posts: 369
Joined: Jan 2011
Reputation:
3
Thank you for complete reply. It works as you said, old database were migrated and works both.
I think you could add your post to xbmc wiki.