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

[Bob Weber]

On Wednesday 13 July 2005 07:09 am, Bruce Markey wrote:
> 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

>
> Yeah, more recent versions of mysqldump (www.mysql.org) seem
> to want to put backticks around the table names. look at your
> backup file and see if they are "INSERT INTO `record` ".
>
Maybe there are more changes. This worked fine in extracting the data (after 
adding backslashes) but when I tried to import it with:

$ mysql -u mythtv -pmythtv mythconverg < restore.sql

I get the error:
ERROR 1136 at line 1: Column count doesn't match value count at row 1