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 _______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
