[mythtv-users] Backing up mysql database.

Andrew Burgess aab at cichlid.com
Thu Sep 6 16:03:14 UTC 2007


>> I also like that when I dump my database, it's human-readable so if I 
>> ever need to restore, I can actually see at what point I'm restoring and 
>> if I need to make any modifications before I restore, I can do that by hand.
>> 
>Good luck inspecting that ~20Mb text file...

Yeah that's a problem. I like backing it up as xml too, that generates
vastly shorter lines so grep is actually useful to inspect it.

There's probably an sql prettyprinter somewhere...



More information about the mythtv-users mailing list