A product from

• Frequently asked questions
• News archive
• Help and tutorials
  • User Interface
  • Functions and tools
  • Configuration and customization
  • Detailed information
  • Tutorials, tips and tricks
    • Helium Web Service API
    • How to connect your iPod and iPhone device
    • Installing Microsoft SQL Server 2008 Express
    • Setting up a working MySQL connection
    • Translating into your language
    • Using Helium Music Manager in a multi-user environment
    • Video tutorials
    • Creating or restore a MS SQL database backup on a remote server
    • Creating or restore a MySQL Database backup on a remote server
• Forum
• Customer Center
• Contact us
• About us

Creating or restore a MySQL Database backup on a remote server

Creating or restore a MySQL Database backup on a remote server

When you use the Network version of Helium Music Manager, you can choose to have your database stored on a separate server to reduce the workload on your local machine.

Databases stored on external servers cannot be backed up with Helium Music Manager’s backup tool, mainly because of various permissions and related things.

To create a backup of your database stored on your server, you will need to use the functions in MySQL Administrator or the new tool MySQL Workbench.

Follow these steps to create a backup using MySQL Administrator:

 

1. On your server machine, start MySQL Administrator
2. Check that the Server Host is set to "localhost", the port number is correct (default is 3306) and that the Username and Password are entered.
3. Click the OK button to connect to the MySQL Server.
4. Select the Backup tab in the left sidebar.
5. If this is the first time you have used MySQL Administrator to backup Helium Music Manager’s database, you will need to set-up a  backup project as follows:
   1. Click New Project.
   2. Enter a Project Name e.g "HMM Backup"
   3. Select Helium Music Manager's database from the list of databases on the left and click the > arrow to move it to the Backup Content pane
   4. All tables should be selected (they are by default)
   5. Click Save Project to save the backup definition which is now listed on under Backup Projects on the left hand side.
   6. The Backup definition is now complete and is only required for the first time. You are now ready to do the actual backup.
6. Select the Helium Music Manager backup project listed under Backup Projects on the left hand side
7. Click Execute Backup Now.
8. A Save As dialogue is shown. Select the location for the backup and alter the file name if required and click Save.
9. The backup will now proceed and then display a completion message. Click OK.
10. The backup is now complete.

Follow these steps to restore a database using MySQL Administrator:

1. On your server machine, start MySQL Administrator
2. Check that the Server Host is set to "localhost", the port number is correct (default is 3306) and that the Username and Password are entered.
3. Click the OK button to connect to the MySQL Server.
4. Select the Restore tab in the left sidebar.
5. Click Open Backup File and select the backup file previously created. Then click Open.
6. Click Another Schema radio button under Target Schema and either:
   1. Select the database you wish to restore or alternatively
   2. Enter a new database name and click Create database(s) if they don't exist.
7. Click Start Restore and the database will be restored.

Follow these steps to create a backup using MySQL Workbench

1. On your server machine, start MySQL Workbench
2. In the rightmost column, Server administration, click Manage Import/Export
3. In the dialog that’s shown, select your Local MySQL instance and click OK
4. In the left-bar, click Data Export and Restore
5. In the group-box, Select Database Objects to Export, select your database in the leftmost list and checkmark the export checkbox
6. Ensure that all tables in the right list are selected (they should be by default)
7. In the group-box, Options, select Export to Self-Contained File
8. Click the Start Export button

Follow these steps to restore a database using MySQL Workbench

1. On your server machine, start MySQL Workbench
2. In the rightmost column, Server administration, click Manage Import/Export
3. In the dialog that’s shown, select your Local MySQL instance and click OK
4. In the left-bar, click Data Export and Restore
5. Select the Import from Disk tab
6. In the Options group-box, select Import from Self-Contained file
7. Click the (...) button and browse to your dump file (created in the backup process)
8. Click the Start Import button to start the restore process