[mythtv-users] cannot restore database

John Pilkington J.Pilk at tesco.net
Sat Feb 21 14:29:54 UTC 2015


On 21/02/15 13:52, UB40D wrote:
> I am looking at the docs for myisamchk, REPAIR TABLE and the like.
> Should I make myself a script to repair all these tables "marked as
> crashed and should be repaired" in the error log (see bpaste above)
> before I can run the restore script to drop the database, recreate it
> and restore it from the backup?
>
> Does it make sense to have to repair the tables before dropping the
> database or am I on the wrong trail?

There doesn't seem much point in repairing it before dropping.   From:

/usr/share/mythtv/mythconverg_restore.pl

( and mythconverg_restore --help   (?) )

If you are replacing an existing database,
you must first drop the old database. You may do this using the mysql client
executable by issuing the command:

# mysql -umythtv -p mythconverg -e "DROP DATABASE IF EXISTS mythconverg;"

(fix the database name and username, as required). Then, execute the mc.sql
script as described in the MythTV HOWTO ( http://www.mythtv.org/docs/ ) to
prepare a new (empty) database.

John





More information about the mythtv-users mailing list