[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