MYSQL

mysql − text-based client for mysqld, a SQL-based relational database daemon

mysql [−B|−−batch] [−#|−−debug= logfile] [−T|−−debug-info] [−e|−−exec= command] [−f|−−force] [−?|−−help] [−h|−−host= hostname] [−n|−−unbuffered] [−p[pwd]] [−−password=[pwd]] [−P|−−port= pnum] [−q|−−quick] [−r|−−raw] [−s|−−silent] [−S|−−socket= snum] [−u|−−user= uname] [−v|−−verbose] [−V|−−version] [−w|−−wait]

The mysql program provides a curses-based interface to the SQL-based database server daemon, mysqld(1). Full fuller documentation, refer to the HTML documents installed with the package.

−B|−−batch

Print results with a tab as separator, each row on a new line.

−#|−−debug=logfile

Employ the specified debug log.

−T|−−debug-info

Print debug information upon exiting.

−e | −−exec=command

Execute the specified command and quit (−−batch is implicit).

−f|−−force

Continue even if the face of a SQL error.

−?|−−help

Display a help message and exit.

−h|−−host=hostname

Connect to the specified host.

−n|−−unbuffered

Flush the buffer after each query.

−p|−−password[=pwd]

Employ the specified password when connecting to the database server. If a password is not supplied, it will be requested interactively.

−P|−−port=pnum

Employ the specified port number for connecting to the database server.

−q|−−quick

Do not cache the result; print it row by row. This may slow down the server if the output is suspended.

−r|−−raw

Write fields without conversion. (used with −−batch).

−s|−−silent

Silent mode: reduce the amount of output.

−S|−−socket=snum

Employ the specified socket file for connecting to the database server.

−u|−−user=uname

Employ the specified user name for logging in to the server.

−v|−−verbose

Verbose mode: write more Specifying this option twice produces a tabular output format.

−V|−−version

Print the mysql version number and exit.

−w|−−wait

Wait and retry if the database server connection is down.

/depot/bin/mysql

executable

/depot/bin/mysqld

executable

/depot/bin/safe_mysqld

executable shell script for starting mysqld safely

/site/var/mysql/data

location of database files

You can also read a backup dump file back into MySQL with:

mysql

database < backup-file.sql

isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror (1), replace (1), safe_mysqld (1), which1 (1), zap (1),

Ver 6.3, distribution 3.20.20 Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se). This software comes with no warranty. Manual page by R. P. C. Rodgers, Lister Hill National Center for Biomedical Communication, U.S. National Library of Medicine (rodgers@nlm.nih.gov).