14.0 MySQL—Backup and Restore from the Command Prompt

IMPORTANT:If you deploy the Micro Focus MySQL appliance, use the phpMyAdmin web front end to back up the Filr database.

A “Hot Backup” process for MySQL is available from Oracle as part of the paid-for version of MySQL.

Backing Up MySQL from the Command Line

If you need to back up or restore the Filr database from the command line, do the following:

  1. Shut down the MySQL service.

  2. 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.

  3. Restart MySQL.

Restoring MySQL from a Backup File

  1. (Optional) If a filr table does not exist in the location where you want to restore the Filr database, you must create it as follows:

    1. Log in to MySQL using the following command:

      mysql -p

    2. Create the database using the following command:

      create database filr;

  2. When a filr table exists on the location where you want to restore the database, do the following:

    1. Quit MySQL

    2. Run the following command:

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

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