[mythtv-users] getting error when restoring database

[Tom Dexter]

On Wed, Jun 11, 2008 at 12:23 PM, Matthew McClement <mythtv at macker.co.uk> wrote:
> Johnny Russ wrote:
> *snip*
>>
>> /var/backups$ mysql -u root -p mythconverg < mythconverg.daily.sql.gz
>>
>> I get this error: ERROR at line 1: Unknown command '\5'.
>
> Try the following instead:
>
> zcat mythconverg.daily.sql.gz | mysql -u root -p mythconverg
>
> Matt
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

...or just gunzip it first:

gunzip mythconverg.daily.sql.gz

...which will give you the file without the '.gz' extension, and then:

mysql -u root -p mythconverg < mythconverg.daily.sql

Tom