> CommCell Console > Backup and Restore Agents > Databases > MySQL > Command Line

Command Line Interface - Configuration

Log On to the CommServe

To run command line operations, you must first login to the CommServe.

From Command prompt, navigate to <Software_Installation_Directory>/Base and run the following command:

 
qlogin -cs commserve name -u user name

For example, to log on to CommServe 'server1' with username 'user1':

qlogin -cs server1 -u user1

Instance Configuration

Creating an Instance

  1. Download the create_instance_template.xml file and save it on the computer from where the command will be executed.

  2. Execute the following command from the <Software_Installation_Directory>/Base folder after substituting the parameters values.

On a UNIX client:
 
qoperation execute -af create_instance_template.xml -appName 'MySQL' -clientName xxxxx -instanceName xxxxx -credentialEntity/credentialName xxxxx -BinaryDirectory xxxxx -LogDataDirectory xxxxx -configFile xxxxx -port xxxxx -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName xxxxx -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName xxxxx

Example:

 
qoperation execute -af create_instance_template.xml -appName 'MySQL' -clientName client1 -instanceName instance1 -credentialEntity/credentialName ay_root_default -BinaryDirectory /usr/bin -LogDataDirectory var/log/mysql -configFile etc/mysql/my.cnf -port /var/run/mysqld/mysqld.sock -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName SP1 -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName SP1

Example to create an instance with XtraBackup option enabled:

 
qoperation execute -af create_instance_template.xml -appName 'MySQL' -clientName client1 -instanceName instance1 -credentialEntity/credentialName ay_root_default -BinaryDirectory /usr/bin -LogDataDirectory var/log/mysql -configFile etc/mysql/my.cnf -port /var/run/mysqld/mysqld.sock -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName SP1 -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName SP1 -xtraBackupSettings/enableXtraBackup true -xtraBackupSettings/xtraBackupBinPath /usr/bin

Example to create MySQL instance with MySQL Enterprise backup option enabled:

 
qoperation execute -af create_instance_template.xml -appName 'MySQL' -clientName client1 -instanceName instance1 -credentialEntity/credentialName ay_root_default -BinaryDirectory /usr/bin -LogDataDirectory var/log/mysql -configFile etc/mysql/my.cnf -port /var/run/mysqld/mysqld.sock -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName SP1 -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName SP1 -mebSettings/enableMEB true -mebSettings/mebBinPath /usr/bin
On a Windows client:
 
qoperation execute -af create_instance_template.xml -appName 'MySQL' -clientName xxxxx -instanceName xxxxx -userGroupName xxxxx -BinaryDirectory xxxxx -LogDataDirectory xxxxx -configFile xxxxx -port xxxxx -SAUser/userName xxxxx -SAUser/password xxxxx -NTUser/userName xxxxx -NTUser/password xxxxx -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName xxxxx -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName xxxxx

Example:

 
qoperation execute -af create_instance_template.xml -appName 'MySQL' -clientName client1 -instanceName instance1 -BinaryDirectory 'C:Program FilesMySQLMySQL Server 5.1bin' -LogDataDirectory 'C:Program FilesMySQLMySQL Server 5.1' -configFile 'C:Program FilesMySQLMySQL Server 5.1my.ini' -port 3306 -SAUser/userName root -SAUser/password mysql -NTUser/userName 'testwinadministrator' -NTUser/password 'password' -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName SP1 -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName SP1
Modifying an Instance

  1. Download the modify_instance_template.xml file and save it on the computer from where the command will be executed.

  2. Execute the following command from the <Software_Installation_Directory>/Base folder after substituting the parameters values.

     
    qoperation execute -af modify_instance_template.xml -appName 'MySQL' -clientName xxxxx -instanceName xxxxx -credentialEntity/credentialName xxxxx -BinaryDirectory xxxxx -LogDataDirectory xxxxx -ConfigFile xxxxx -port xxxxx -enableAutoDiscovery xxxxx -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName xxxxx -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName xxxxx

The following examples show some common modification operations.

Modifying the Credential
 
qoperation execute -af modify_instance_template.xml -appName 'MySQL' -clientName 'client1' -instanceName 'instance1' -credentialEntity/credentialName 'ay_root_emt' -BinaryDirectory '/usr/bin' -LogDataDirectory '/var/lib/mysql' -ConfigFile 'C:Program FilesMySQLMySQL Server 5.5my.ini' -port '/var/lib/mysql/mysql.sock' -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName 'storage_policy_name' -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName 'storage_policy_name'
Specifying the Configuration File
 
qoperation execute -af modify_instance_template.xml -appName 'MySQL' -clientName client1 -instanceName instance1 -ConfigFile 'C:Program FilesMySQLMySQL Server 5.5my.ini'
Specifying the Binary and Log Data Directory
 
qoperation execute -af modify_instance_template.xml -appName 'MySQL' -clientName client1 -instanceName instance1 -BinaryDirectory 'C:Program FilesMySQLMySQL Server 5.5bin' -LogDataDirectory 'C:Program FilesMySQLMySQL Server 5.5data' -SAUser/userName 'user1' -SAUser/password 'pwd1'
Modifying Xtrabackup Bin Path
 
qoperation execute -af modify_instance_template.xml -appName 'MySQL' -clientName client1 -instanceName instance1 -credentialEntity/credentialName ay_root_default -BinaryDirectory /usr/bin -LogDataDirectory var/log/mysql -configFile etc/mysql/my.cnf -port /var/run/mysqld/mysqld.sock -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName SP1 -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName SP1 -xtraBackupSettings/enableXtraBackup 'true' -xtraBackupSettings/xtraBackupBinPath '/xtrabackupbin/'
Modifying Mysql Enterprise Backup binary path
 
qoperation execute -af modify_instance_template.xml -appName 'MySQL' -clientName client1 -instanceName instance1 -credentialEntity/credentialName ay_root_default -BinaryDirectory /usr/bin -LogDataDirectory var/log/mysql -configFile etc/mysql/my.cnf -port /var/run/mysqld/mysqld.sock -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName SP1 -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName SP1 -mebSettings/enableMEB true -mebSettings/mebBinPath /mysqlbackupbin
Disabling Mysql Enterprise Backup
 
qoperation execute -af modify_instance_template.xml -appName 'MySQL' -clientName client1 -instanceName instance1 -credentialEntity/credentialName ay_root_default -BinaryDirectory /usr/bin -LogDataDirectory var/log/mysql -configFile etc/mysql/my.cnf -port /var/run/mysqld/mysqld.sock -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName SP1 -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName SP1 -mebSettings/enableMEB false
Changing the Instance Name
 
qoperation execute -af modify_instance_template.xml -appName 'MySQL' -clientName client1 -instanceName instance1 -newName instance2 -credentialEntity/credentialName ay_root_default -BinaryDirectory /usr/bin -LogDataDirectory var/log/mysql -configFile etc/mysql/my.cnf -port /var/run/mysqld/mysqld.sock -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName SP1 -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName SP1
Enabling Proxy Backup Operation

  1. Download the enable_proxy_instance_template.xml file and save it on the computer from where the command will be executed.

  2. Execute the following command from the <Software_Installation_Directory>/Base folder after substituting the parameters values.

     
    qoperation execute -af enable_proxy_instance_template.xml -appName 'MySQL' -clientName xxxxx -instanceName xxxxx -isProxyEnabled true -proxyInstance/clientName xxxxx -proxyInstance/instanceName xxxxx -runBackupOnProxy true -isUseSSL true

Example:

 
qoperation execute -af enable_proxy_instance_template.xml -appName 'MySQL' -clientName 'client1' -instanceName 'instance1' -isProxyEnabled true -proxyInstance/clientName  ‘client2’ -proxyInstance/instanceName 'instance2' -runBackupOnProxy true -isUseSSL true
Getting Instance Properties

  1. Download the get_instance_properties_template.xml file and save it on the computer from where the command will be executed.

  2. Execute the following command from the <Software_Installation_Directory>/Base folder after substituting the parameters values.

     
    qoperation execute -af get_instance_properties_template.xml -appName 'MySQL' -clientName xxxxx -instanceName xxxxx
Deleting an Instance

  1. Download the delete_instance_template.xml file and save it on the computer from where the command will be executed.

  2. Execute the following command from the <Software_Installation_Directory>/Base folder after substituting the parameters values.

     
    qoperation execute -af delete_instance_template.xml -appName 'MySQL' -clientName xxxxx -instanceName xxxxx
Available Parameters for Instance Configuration

The following table displays all the parameters you can use with the commands mentioned in the above sections. To add a parameter to your command, use the following syntax: (A example is provided at the end of the table.)

qoperation execute -af template XML file -parameter name value

Parameter

Description of Parameter Values

clientName

Name of the client computer.

appName

Name of the application. In this case it would be 'MySQL'.

instanceName

Name of the MySQL instance. If you are specifying an instance other than the default instance, the name must be entered along with the client name, e.g. client1\instance1.

userGroupName

Name of the user group to be associated to the instance. This is the user group that you associate from the Security tab of the instance properties dialog box in the CommCell Console.

associatedUserGroupsOperationType

Specifies the operation that you want to perform on the user groups. Valid values are:

  • ADD, to add a new user group.

  • OVERWRITE, to change the existing user groups with others.

  • DELETE, to delete a user group.

BinaryDirectory

Path of the binary directory for the database instance.

LogDataDirectory

Path of the directory where the logs are stored for the database instance.

ConfigFile

Path of the configuration file for the database instance.

port

The port (on Windows) or socket file (on Unix) to open the communication between the MySQL server and its clients.

enableAutoDiscovery

Option to search in the MySQL instance for databases that are not configured in order to add them to the system. This discovery process runs on the entire instance prior a backup operation.

Valid values are True/False.

logStoragePolicy/storagePolicyName

Name of the storage policy used to back up this instance.

newName

New name of the MySQL instance.

The following example show how to add a parameter for a command:

Specifying the Configuration File

qoperation execute -af modify_instance_template.xml -appName 'MySQL' -clientName client1 -instanceName instance1 -ConfigFile 'C:\Program Files\MySQL\MySQL Server 5.5\my.ini' -SAUser/userName 'user1' -SAUser/password 'pwd1'
×

Loading...