Importing Old Database
From MythTV
Cleanup: This article or section may require cleanup. Discuss the issue on the talk page
Objective
The objective of this page is to help you import old MythTV database information into your new database! I had recently upgraded to a whole new system with a fresh install of everything. I didn't want to start with my old database that had my old settings. There are some database script utilities in the /contrib folder of your MythTV source, but either they didn't do what I wanted or required way too much manual input.
Note: The whole purpose of this page is to help people upgrade the db schema version of their old databases (versions 0.17, 0.18, etc.) to the current installed version so that they may then take that data and import it into their current working database.
- Backup your old database...just incase.
- Shutdown mythbackend & mysqld
- Go to your MySQL data directory where your databases are
- mv mythconverg mythCUR
- Move your old database in place of mythCUR to mythconverg
- Start mysqld & mythbackend
mythbackend should upgrade your db schema version on your old database now. - Revert to your current mythconverg by stopping mysqld and mythbackend and moving mythCUR back to mythconverg and then restart them.
- mv mythconverg mythold
- mv mythCUR mythconverg
Now take whatever data from your old database with mysqldump or phpMyAdmin and import it into your current working mythconverg database. My goal was to import my old recorded (I had my old recordings still in my recorded folder) and oldrecorded (I didn't want MythTV re-recording any of my Coronation Street)
