7.4 Backup and Restore of MySQL

If you deploy the MySQL Novell appliance as part of your Filr solution, then the PHPADMIN web front end can be used.

If not, then you might need to back up and restore from the command line on the MySQL Server.

The backup and restore process discussed here is not a “Hot Backup” and would require shutting down the Filr appliance. A “Hot Backup” process for MySQL is available from Oracle as part of the paid-for version of MySQL.

  1. Run the following command:

    mysqldump -u root -p filr >/backupdir/filrback.sql

    This creates a file named filrback that can be used to restore the database.

  2. If the filr table does not exist, it must be recreated by logging in to mysql using the following command:

    mysql -p

    Then creating the database using

    create database filr;

  3. After the database file is present, quit mysql and run the following command:

    mysql -p filr < /backupdir/filr-back.sql

    This completes the restore of the Filr database and its associated tables.