Backing up and restoring OpenBiblio data is the same as backing up and restoring any MySQL database. You can use a tool like PhpMyAdmin, or you can use the programs that come with MySQL. For more information, see MySql:disaster-prevention.html.
For convenience, here are quick command-line recipes:
Backup
- Look in openbiblio/database_constants.php for the database name, username, and password OpenBiblio uses to access its data. For this example we'll use OpenBiblio as the database name and obiblio as the username.
- Save the OpenBiblio data to a file named backup.sql (you will be prompted to enter the password for obiblio):
mysqldump -u obiblio -p OpenBiblio > backup.sql
- Copy backup.sql onto backup media, another computer, etc.
Restore
- Look in openbiblio/database_constants.php for the database name, username, and password OpenBiblio uses to access its data. For this example we'll use OpenBiblio as the database name and obiblio as the username.
- Restore the OpenBiblio data from a file named backup.sql (you will be prompted to enter the password for obiblio):
mysql -u obiblio -p OpenBiblio < backup.sql
