The manage_mysql_profiles Script

Overview

The /usr/local/cpanel/scripts/manage_mysql_profiles allows you to import and export MySQL® profiles.

To use the /usr/local/cpanel/scripts/manage_mysql_profiles script to import or export MySQL profiles, run the following command:

/usr/local/cpanel/scripts/manage_mysql_profiles [options]

When you run the /usr/local/cpanel/scripts/manage_mysql_profiles script, you can specify the following options:

Option	Description	Example
`--import [/path/to/json/file]`	Import the profiles contained in the specified JSON file. Note: You can specify `--force` to forcibly import and overwrite any existing profiles.	/usr/local/cpanel/scripts/manage_mysql_profiles --import import.json
`--export [profile name]`	Export one or more profiles. To export more than one profile, specify multiple switches. To export the list to a file, specify the `export_to` switch or redirect via `STDOUT`.	/usr/local/cpanel/scripts/manage_mysql_profiles --export profile /usr/local/cpanel/scripts/manage_mysql_profiles --export profile1 --export profile2 /usr/local/cpanel/scripts/manage_mysql_profiles --export profile1 --export_to export.json
`--activate [profile name]`	Activate the specified profile, and mark it as the active profile for the system.	/usr/local/cpanel/scripts/manage_mysql_profiles --activate profile1
`--recreate_active_profile`	If no active profile exists on the system, this option creates a profile from the information in the `/root/.my.cnf` file.	/usr/local/cpanel/scripts/manage_mysql_profiles --recreate_active_profile