[mythtv-users] Mythsqlhotcopy restore

[William Munson]

stan wrote:
> I'm using the mythsqlhotcopy script to back up the mythTV database. How do
> you do a restore?
>
> The comments say to copy the files back, run a few mySQL utilities for fix
> up, and tell mySQL to use the restored files. Do you really need to tell
> mySQL to use the restored files, or is this done automatically assuming you
> stop the daemon before replacing the current files with the backup versions?
>
> --stan
>
>   
I do my backups manually using mysqldump and I use the --add-drop-table 
option so for me its as simple as:

mythbackend stop
mysql -p mythconverg < /path/to/backup
mythbackend start
(restart frontends)

Yours should be similar although you may have to manually drop the table.

Can you post a url for that script? I would be interested in checking it 
out.