A product from

• Frequently asked questions
• News archive
• Help and tutorials
  • User Interface
  • Functions and tools
  • Configuration and customization
  • Detailed information
    • Album Artist
    • Collections and Volumes
    • How albums are interpreted
    • Multiple Artists
    • Plug-ins
    • Rating your music
    • Release Types
    • Report Wizard template specification
    • Supported MySQL setups
    • Tag compatibility chart
    • Tag editors
    • Using MySQL as database backend
    • Templates
    • Using WMA files
    • Visualisation plug-ins
    • Multi-user Support
  • Tutorials, tips and tricks
• Forum
• Customer Center
• Contact us
• About us

Supported MySQL setups

MySQL is one of the supported database types in Helium Music Manager. Although we recommend using SQL Express for larger music collections for optimal performance there are cases where a MySQL installation is the better choice, such as when your music is stored on a NAS drive which has MySQL functionality built-in.

There are many different versions of MySQL available on different devices, each with a potentially different setup and configuration. Therefore it may be a bit tricky to set things up correctly so that Helium Music Manager can operate without problems. This page aims to be an informative resource to which MySQL versions that are known to work, which are not, and also discusses a few important settings and their recommended values.

MySQL Versions known to work

 

MySQL 5.1.47 on Windows

MySQL 5.1.57 on Windows

MySQL 5.5.8 on Windows

MySQL 5.5.13 on Windows

Important Settings

set lower_case_table_names=1 in my.ini (Windows) or my.cnf (Linux / NAS) - When set to 1 table names are stored in lowercase on disk and table names will be case-insensitive.