On Wed, 26 Jan 2005 17:11:29 -0500, Tim <[EMAIL PROTECTED]> wrote: > > I have the new backend up and running under a new hostsname... I have > used nuvimport to move all recordings I wanted to keep. I wasn't sure if > that was the best way of doing it, but from what I read it seemed the > safest. I think the only thing I need now is the history of recorded but > deleted programs. > > I am thinking that a mysql dump of that table and import to the new one > should work, but which table and do I need to filter? Also, are the any > issues with hostname, etc? > > Tim >
I recently moved to a new backend as well. What I did was centered around three tables: record, recorded and recrodedmarkup. From what I read, these were the most important tables to get into the new system. I used this command to dump each table: mysqldump -u root -p mythconverg record > record.table.sql mysqldump -u root -p mythconverg recorded > recorded.table.sql mysqldump -u root -p mythconverg recordedmarkup > recordedmarkup.table.sql (I suppose you could dump all three at once, but I wanted to look at each of them..and I like to do things the hard way). I then edited the dump files so that the only sql commands left were the "INSERT into..." commands. I don't need the table building commands because the tables are already there in the new backends database. Now, when I tried to import those files into my new database, I got an erro on the "recorded" table. So I looked at the new table: mysql -u root -p mythconverg mysql> show columns from recorded; and noticed that the rows lastmodified, filesize, stars, previouslyshown, and originalairdate were all new in 0.16 (I was coming from 0.15). The defaults are NULL, 0, 0, 0, NULL respectively. I simply added those five values to the end of every "INSERT into ..." line that was in my recorded.table.sql file. Then the import went fine. -- I have some G-Mail invites. Let me know if you want on
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
