Knowledgebase

The manage_mysql_profiles Script  Print this Article

Overview:

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

Run the script

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]

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.
1
2
3
4
codeblocknumbers
/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

Was this answer helpful?

Related Articles

WHM Scripts
Overview: The cPanel & WHM installation process adds important scripts to your server’s...
The dbmaptool Script
Overview: You can use the /usr/local/cpanel/bin/dbmaptool script to grant ownership of databases...
The servers_queue Script
Overview: This script allows you to manage the task queue system. The task queue system allows...
The auto-adjust-mysql-limits Script
Overview: The /usr/local/cpanel/scripts/auto-adjust-mysql-limits script updates MySQL®...
The autossl_check Script
Overview: The /usr/local/cpanel/bin/autossl_check script allows you to manually check the SSL...