[Koha] Backing up 3.0

Frederic Demians frederic at tamil.fr
Thu Dec 18 18:11:01 UTC 2008


> 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




More information about the Koha mailing list