[Koha] Backing up 3.0

Frederic Demians frederic at tamil.fr
Fri Dec 19 07:11:01 NZDT 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