mysql

NAME

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

SYNOPSIS

DESCRIPTION

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.

OPTIONS

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

FILES

/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

EXAMPLE

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

mysql: database < backup-file.sql

AUTHOR

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