[mythtv-users] Getting database info to a new backend

[Richard C. Isaacson]

This is what I used.
I then just pumped it into the new database

mysqldump -u root -p -Av --lock-tables --add-drop-table --add-locks -r 
/data05/mythBACKUPS/20050614

Bob Weber wrote:

>Hello. I'm building a new backend, and am trying to move my database to the 
>new system so I don't end up rerecording my old shows. So I'm trying to 
>follow the docs at mythtv, and doing:
>
>$ mysqldump -u mythtv -pmythtv mythconverg -c > mythtv_backup.sql
>$ grep "INSERT INTO record "         mythtv_backup.sql > restore.sql
>$ grep "INSERT INTO recorded "       mythtv_backup.sql >> restore.sql
>$ grep "INSERT INTO oldrecorded "    mythtv_backup.sql >> restore.sql
>$ grep "INSERT INTO recordedmarkup " mythtv_backup.sql >> restore.sql
>
>The problem is, while I get a rather large mythtv_backup.sql file, the greps 
>don't find anything. Has the layout of the database changed, or what am I 
>missing? Tnx.
>
>- Bob
>  
>
>------------------------------------------------------------------------
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>  
>