1. Main page
  2. Knowledgebase
  3. WHM
  4. Scripts
  5. The manage_mysql_profiles Script

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

  Tag Cloud

iPhone Android Phone Mobile Installatron Backup Clone Import Server Application uninstall Upgrade Edit View Introduction Backups word press wordpress staging dev site development site wp dev environment gmail mail client databases phpmyadmin ftp notepad++ host record host file windows mac weebly #gmail #email google e-mail

  Support

My Support Tickets Announcements Knowledgebase Downloads Network Status Open Ticket