18 Dec
2008
18 Dec
'08
2:01 p.m.
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@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