Version 70 Documentation
Child pages
  • The manage_mysql_profiles Script
Skip to end of metadata
Go to start of metadata

This documentation is for cPanel & WHM version 70 CURRENT builds.  The "RELEASE" version of our documentation can be found in the Version 68 Documentation space.

Overview

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

The /scripts/manage_mysql_profiles 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:

OptionDescriptionExample

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

Additional documentation