Introduction
In MySQL there is a tool called mysqldump available. To get a consistent backup you need to use the InnoDB storage engine and specify the mysqldump option --single-transaction
. The backups generated by mysqldump contain the complete SQL code to recreate the YAWL database.
Backup
For example a full backup of all databases with MySQL is get by:
mysqldump --all-databases --single-transaction > yawlDatabase.sql
To backup only your YAWL database, you can specify the name (usually "yawl") by:
mysqldump --databases yaug --single-transaction > yawlDatabase.sql
Restore
To restore the YAWL database please first shutdown all running YAWL services. Then issue the following command:
mysql < yawlDatabase.sql
You may also supply username and password of a database user.