Recent Changes Printable View Page History Edit Page

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 Reference Manual : Backup and Recovery.

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
SourceForge.net Logo
Edit Page - Page History - Printable View - Recent Changes - Search
Page last modified on May 06, 2014, at 10:43 PM