[mythtv-users] PostgreSQL

[David Rees]

On 7/3/06, Stuart Johnston <saj at thecommune.net> wrote:
> You might want to try setting the flush option on your mysql server.
> That should help avoid data inconsistencies when the server goes down
> unexpectedly.
>
> http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html

Thanks for that tip. While in the docs I found a useful startup option:

--myisam-recover=BACKUP,FORCE

If you add this to the server startup, mysql will automatically try to
recover any MyISAM tables marked as crashed after making a backup of
the file.

-Dave