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

mysql [OPTIONS] [Database]

mysql [-B|--batch] [-#|--debug= logfile] [-T|--debug-info] [-e|--exec= command] [-f|--force] [-?|--help] [-h|--host= hostname] [-n|--unbuffered] [-p[pwd]] [--password=[pwd] (INSECURE)] [-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 mysql online HTML documention at http://dev.mysql.com/doc/. NOTE: Unfortunately this documentation is not released under a license that makes Debian able to redistribute it (not even legally!), so there is no package available with this documentation. Feel free to contact mysql if you'd like to share your opinion on the matter :)

-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. WARNING: This is insecure as the password is visible for anyone through /proc for a short time.

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

/etc/my.cnf

MySQL configuration file

/usr/bin/mysql

Client executable

/usr/sbin/mysqld

Server executable

/usr/bin/mysqld_safe

executable shell script for starting mysqld safely

/var/lib/mysql

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), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privilege_tables(1), mysqlshow(1), mysql_zap(1), perror(1), replace(1)

For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online at http://dev.mysql.com/doc/mysql/en

Please refer to http://bugs.mysql.com/ to report bugs.

Ver 6.3, distribution 4.1.15 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/) 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).