Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions

  




 

 

5.4.3. MySQL Instance Manager Command Options

The MySQL Instance Manager supports a number of command line options. For a brief listing, invoke mysqlmanager with the --help option.

mysqlmanager supports the following options:

  • --help, -?

    Display a help message and exit.

  • --bind-address=IP

    The IP address to bind to.

  • --default-mysqld-path=path

    On Unix, the pathname of the MySQL Server binary, if no path was provided in the instance section. Example: --default-mysqld-path=/usr/sbin/mysqld

  • --defaults-file=file_name

    Read Instance Manager and MySQL Server settings from the given file. All configuration changes by the Instance Manager will be made to this file. This must be the first option on the command line if it is used.

  • --install

    On Windows, install Instance Manager as a Windows service.

  • --log=file_name

    The path to the IM log file. This is used with the --run-as-service option.

  • --monitoring-interval=seconds

    The interval in seconds for monitoring instances. The default value is 20 seconds. Instance Manager tries to connect to each monitored instance to check whether it is alive/not hanging. In the case of a failure, IM performs several attempts to restart the instance. The nonguarded option in the appropriate instance section disables this behavior for a particular instance.

  • --passwd, -P

    Prepare an entry for the password file and exit.

  • --password-file=file_name

    Look for the Instance Manager users and passwords in this file. The default file is /etc/mysqlmanager.passwd.

  • --pid-file=file_name

    The process ID file to use. By default, this file is named mysqlmanager.pid.

  • --port=port_num

    The TCP/IP port number to use for incoming connections. (The default port number assigned by IANA is 2273).

  • --print-defaults

    Print the current defaults and exit. This must be the first option on the command line if it is used.

  • --remove

    On Windows, removes Instance Manager as a Windows service. This assumes that Instance Manager has been run with --install previously.

  • --run-as-service

    Daemonize and start the angel process. The angel process is simple and unlikely to crash. It will restart the Instance Manager itself in case of a failure.

  • --socket=path

    On Unix, the socket file to use for incoming connections. By default, the file is named /tmp/mysqlmanager.sock.

  • --standalone

    On Windows, run Instance Manager in standalone mode.

  • --user=user_name

    Username to start and run the mysqlmanager under. It is recommended to run mysqlmanager under the same user account used to run the mysqld server. (“User” in this context refers to a system login account, not a MySQL user listed in the grant tables.)

  • --version, -V

    Output version information and exit.


 
 
  Published under the terms of the GNU General Public License Design by Interspire