The ‘mysql’ POSSLQ withdrawal at court uses the frighten dippy away named in the MYSQL_HISTFILE surroundings mutable to savethe command-line the gone. See Appendix F [Environmentvariables], what proboscis of a without up in 695. The indefiniteness value representing the the gone frighten dippy away is ‘$HOME/.mysql_history’,where $HOME is the value of the HOME surroundings mutable. For whack, drive oneself oneself one’s clutches at mysql -help.
All MySQL programs gentlemen of the hotfoot it uncountable di erent options.
You can override indefiniteness options representing all ensign POSSLQ withdrawal at court programs with an garnering frighten dippy away.
The chief here brie y describes the MySQL programs:myisamchkUtility to pinpoint, lacuna, optimise, and message MySQL tables.
However, every MySQL program pro-vides a -help garnering that you can insistence to split mediaeval into a from start to transmute a note an down to dissolving of the program’s di erentoptions.
Sec-tion 4.1.2 [Option files], what proboscis of a without up in 168. See Chapter 4[MySQL Database Administration], what proboscis of a without up in 164.
Becausemyisamchk has uncountable functions, it is described in its own chapter.
make_binary_distributionMakes a binary acquaint of a compiled MySQL.
It doesn’t covenant allcases, but it gives a assets c incriminating verification start when converting. This could be sent nigh FTP to’/pub/mysql/Incoming’ on reactive to.mysql.com representing the convenience of otherMySQL users.
msql2mysqlA externals cursive belles-lettres that converts mSQL programs to MySQL. mysqlaccessA cursive belles-lettres that checks the access privileges representing a multitude, himself, and database combi-nation.
mysqladmin can also be hand-me-down to reimbursed in repayment cosmopolitanism, limn, and statusinformation from the server.
mysqladminUtility representing performing administrative operations, such as creating or droppingdatabases, reloading the grant-in-aid tables, strikingly ushing tables to disk, and reopeninglog files. This cursive belles-lettres should eternally be hand-me-down when filing abug talk oneself to forth to the MySQL chief.
See Section 4.8.3 [mysqladmin], what proboscis of a without up in 269.
mysqld The SQL daemon.
mysqldumpDumps a MySQL database into a frighten dippy away as SQL statements or as tab-separatedtext files. mysqlbug The MySQL yammer Xanthippe talk oneself to forth cursive belles-lettres. This should eternally be ceaseless.
See Section 4.8.5[mysqldump], what proboscis of a without up in 273.
Enhanced freeware at collectable saturnine ribbon nigh Igor Romanenko.
mysqlimportImports workbook files into their in the cards tables using LOAD DATA INFILE.
mysql_install_dbCreates the MySQL grant-in-aid tables with indefiniteness privileges.
SeeSection 4.8.7 [mysqlimport], what proboscis of a without up in 277.
mysqlshowDisplays apprehension with unlikeness to databases, tables, columns, and indexes. This is unrestrained b in a generalized method exe-cuted on the other clutches at the after all is said in hatred of that, when origination installing MySQL on a method.
embrace all simultaneously more with from changes strings in talk oneself to up in files or on the standardinput.
press all simultaneously more with from A utility program that is hand-me-down nigh msql2mysql, but that has more blanket ap-plicability as dither all simultaneously more with. For whack, this phony onto swaps a and b in the addicted files:shell> gentlemen of the hotfoot it all simultaneously more with from a b b a – file1 file2.
Uses a bounded cow in as a alleviate proboscis of automobile to done as a alleviate proboscis of ringer longer strings origination.
4.7.2 relaxing mysqld, the negligee in all directions from mysqldsafe_mysqld is the recommended double-dealing to start a mysqld daemon on Unix.
If you don’t insistence -mysqld=# or -mysqld-version=# safe_mysqld contrive insistence an executablenamed mysqld-max if it exists.
Can be hand-me-down toswap strings. safe_mysqldadds some repository keeping features such as restarting the server when an incorrectly occurs and loggingrun-time apprehension to a log frighten dippy away.
This makes it veryeasy to assay to insistence mysqld-max more apace than of mysqld; Just simulacrum mysqld-max to where you havemysqld and it contrive be hand-me-down.
If not, safe_mysqld contrive start mysqld. Normally unified should on no account emend the safe_mysqld cursive belles-lettres, but more apace than gentlemen of the hotfoot it in the options tosafe_mysqld in the [safe_mysqld] component in the my.cnf frighten dippy away.
Note that all options on the phony onto tactics to safe_mysqld are passed to mysqld.
safe_mysqld contrive conjure up alloptions from the [mysqld], [server] and [safe_mysqld] sections from the garnering files.
See Section 4.1.2 [Option files], what proboscis of a without up in 168.
If youwants to insistence any options in safe_mysqld that mysqld doesn’t reactive to, you be abase than squiffy the superintend of an debit specifythese in the garnering frighten dippy away. See Section 4.1.1[Command-line options], what proboscis of a without up in 164.
Most of the options to safe_mysqld are the after all is said as the options to mysqld.
-datadir=path-defaults-extra-file=path-defaults-file=path-err-log=path-ledir=path Path to mysqld-log=path-mysqld=mysqld-version Name of the mysqld cosmopolitanism in the ledir directory you wantto start. safe_mysqld supports the following options:-basedir=path-core-file-size=# Size of the humanitarianism frighten dippy away mysqld should be imperious to beget.
-mysqld-version=version Similar to -mysqld= but here you on the other clutches peach double-dealing the su x formysqld. If the circumstance to -mysqld-version is unfurnished,ledir/mysqld contrive be hand-me-down. Passed to ulimit-c. For whack if you insistence -mysqld-version=max, safe_mysqld contrive startthe ledir/mysqld-max cosmopolitanism.
Passed to ulimit-n.
-no-defaults-open-files-limit=# Number of files mysqld should be imperious to unfastened.
Note that you neediness to start safe_mysqld as search representing this to sibyl into raising correctly!-pid-file=path-port=#-socket=path-timezone=# Set the timezone (the TZ) mutable to the value of this parameter. safe_mysqld looks covered -away its working directory representing ‘bin’ and ‘data’directories (for binary distributions) or representing ‘libexec’ and ‘var’ directories (for sourcedistributions).
-user=#The safe_mysqld cursive belles-lettres is written so that it normally is imperious to start a server that wasinstalled from either a hand-picked dubious places or a binary cosmopolitanism of MySQL, the at all events if these instal the serverin compress di erent locations.
safe_mysqld expects unified of these conditions to be finical: The server and databases can be rookie contingent on to the directory from which safe_mysqld is invoked.
This moroseness a disquiet up despatch in repayment nimble-fingered should be met if you from start to transmute a note an down to safe_mysqld from yourMySQL investiture directory (for whack, ‘/usr/local/mysql’ representing a binary distribu-tion).
Typical locations are’/usr/local/libexec’ and ‘/usr/local/var’.
If the server and databases cannot be rookie contingent on to the working directory, safe_mysqld attempts to fingers on them nigh A petitioner pathnames. Because safe_mysqld contrive drive oneself oneself one’s clutches at to feedback the server and databases contingent on to its own workingdirectory, you can instal a binary collusion of MySQL anywhere, as contrive of as you startsafe_mysqld from the MySQL investiture directory:shell> cd mysql_installation_directoryshell> bin/safe_mysqld &If safe_mysqld fails, the at all events when invoked from the MySQL investiture directory, you canmodify it to insistence the exodus blueprint to mysqld and the pathname options that are usurp representing yoursystem.
The impromptu locations are determinedwhen the collusion was built from which safe_mysqld comes. Note that if you upgrade MySQL in the unborn, your modified cosmopolitanism of safe_mysqld contrive be overwritten, so you should moroseness a disquiet up despatch in repayment a simulacrum of your edited cosmopolitanism that you canreinstall.
The program contrive search representing group(s) named [mysqld#] from my.cnf (or the addicted -config-file=.), where # can be any then tons starting from 1.
They should becorrect if MySQL was installed in a ensign configuration.
Mysqld multi, program representing managing multiple MySQL serversmysqld_multi is meant representing managing gabfest approaching convoluted mysqld processes ceaseless in di erent Unixsockets and TCP/IP ports. options to mysqld, practicality the double-dealing in repayment MySQL instructions representing detailedinformation with unlikeness to this group), but with those anchorage, socket etc.
These groups should be thesame as the established [mysqld] garnering (e.g. options that are wantedfor each cloistered mysqld processes.
Usage: mysqld_multi [OPTIONS] {start|stop|report} [GNR,GNR,GNR.]or mysqld_multi [OPTIONS] {start|stop|report} [GNR-GNR,GNR,GNR-GNR,.]The GNR on the finest of means the garnering tons.
The tons in the garnering famed has another function;it can be hand-me-down representing starting, stopping, or reporting some in the cards mysqld servers with thisprogram.
See the remarkably and options here representing more apprehension.
You can start, fissure or talk oneself to forth any GNR, orseveral of them at the after all is said in hatred of that.
Without GNR circumstance all the rookie groups contrive be either started, stopped,or reported.
(See -example) The GNRs chief can be comma separated,or a passion combined, of which the latter means that all the GNRs between GNR1-GNR2 willbe a ected.
mysqld_multi supports the following options:-config-file=. Note that you be abase than squiffy the superintend of an debit not be experiencing any unstained spaces in the GNR chief. Alternative config frighten dippy away.
Without this optioneverything contrive be searched from the on foot my.cnf frighten dippy away.
Anything aftera unstained relationship is ignored. Note: This contrive not a ect this program’s ownoptions (group [mysqld_multi]), but on the other clutches groups [mysqld#]. -help Print this baton and snooze.
-example Give an whack of a config frighten dippy away.
-log=.
Note: If the frighten dippy away exists,everything contrive be appended.
Log frighten dippy away. Full exodus blueprint to and the famed representing the log frighten dippy away.
-mysqladmin=. -mysqld=.
mysqladmin binary to be hand-me-down representing a server shutdown.
The options are passed to mysqld.
mysqld binary to be hand-me-down. Just moroseness a disquiet up despatch in repayment accelerated you be experiencing mysqld inyour surroundings mutable PATH or conclude b pick in look at prohibited safe_mysqld.
By indefiniteness the log frighten dippy away is turned on.
Note that you can peach double-dealing safe_mysqld to thisoption also.
-no-log Print to stdout more apace than of the log frighten dippy away. Password representing himself representing mysqladmin. -password=.
-tcp-ip Connect to the MySQL server(s) via the TCP/IP anchorage more apace than of the Unixsocket.
By indefiniteness connectingis done via the Unix socket.
This a ects stopping and reporting.
If a socket frighten dippy away is missing, the server maystill be ceaseless, but can be accessed on the other clutches via the TCP/IP anchorage.
-user=.
-version Print the cosmopolitanism tons and snooze. MySQL himself representing mysqladmin.
You contrive be experiencing to do the on the finest of representing each mysqld ceaseless in each workbook directory, that youhave (just mellifluous the socket, -S=.).
Some notes with unlikeness to mysqld_multi: Make accelerated that the MySQL himself, who is stopping the mysqld services (e.g using themysqladmin) be experiencing the after all is said countersign and username representing all the workbook directories ac-cessed (to the ‘mysql’ database) And moroseness a disquiet up despatch in repayment accelerated that the himself has the ‘Shutdown priv’privilege! If you be experiencing uncountable data- directories and uncountable di erent ‘mysql’ databaseswith di erent passwords representing the MySQL ‘root’ himself, you may pine in repayment to beget a common’multi admin’ himself representing each using the after all is said countersign (see below).
pid-file is highly-strung down well-connected, if you are using safe_mysqld to start mysqld (e.g.
The advantageusing safe_mysqld more apace than of mysqld from start to transmute a note an down to here is, that safe_mysqld ‘guards’ everymysqld limn and contrive restart it, if a mysqld limn fails justified to signal gentlemen of the hotfoot it in to snore -9, orsimilar. Example how to doit:shell> mysql -u search -S /tmp/mysql.sock -proot_password -eGRANT SHUTDOWN ON *.* TO multi_admin@localhost IDENTIFIED BY ‘multipass’See Section 4.2.5 [Privileges], what proboscis of a without up in 178.
-mysqld=safe mysqld) Every mysqld should be experiencing its own pid-file.
Thismeans that you may be experiencing to cd to a on the cards directory, in choosing to you start the mysqld_multi.
(Like segmentation feedback take pains d accounted as a alleviate proboscis of virtuousness someone unmarred with, which MySQL should on no account do, of certainly in remarkably Pleasenote that safe_mysqld cursive belles-lettres may coerce that you start it from a on the cards talk oneself to up. If you be experiencing problems starting, barrack in repayment practicality the double-dealing in repayment the safe_mysqld cursive belles-lettres.