[Koha] Backing up 3.0

[Doug Dearden]

Thanks Frederic, I will add that to my script.  

Any thoughts on what files are essential to restore in the event of a complete system crash?

Best,

Doug

>>> Frederic Demians <frederic at tamil.fr> 12/18/2008 11:11:01 AM >>>

> mysqldump --add-drop-table -u<dbusername> -p<dbpassword> koha >koha.sql

You must add --single-transaction option to dump a consistent state of 
Koha DB.

You may want to add compression on the fly rather than after dump to 
spare disk space:

mysqldump --add-drop-table --single-transaction \
  -u<dbusername> -p<dbpassword koha | gzip >koha.sql


--
Frédéric