mysql(1) MySQL database mysql(1) NAME mysql - text-based client for mysqld, a SQL-based relational database daemon USAGE mysql [OPTIONS] [Database] SYNOPSIS mysql [-B|--batch] [-#|--debug= logfile] [-T|--debug-info] [-e|--exec= command] [-f|--force] [-?|--help] [-h|--host= hostname] [-n|--unbuffered] [-p[pwd(1,n,1 builtins)]] [--password=[pwd(1,n,1 builtins)]] [-P|--port= pnum] [-q|--quick] [-r|--raw] [-s|--silent] [-S|--socket= snum] [-u|--user= uname(1,2)] [-v|--verbose] [-V|--version] [-w|--wait] 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(3,n) 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(1,n,1 builtins)] 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(3,n) 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(2,7,n) file(1,n) for connecting to the database server. -u|--user=uname(1,2) Employ the specified user name for logging in(1,8) to the server. -v|--verbose Verbose mode: write(1,2) more Specifying this option twice produces a tabular output format. -V|--version Print the mysql version(1,3,5) number and exit. -w|--wait Wait and retry if(3,n) the database server connection is down. FILES /etc/my.cnf MySQL configuration file(1,n) /usr/bin/mysql Client executable /usr/libexec/mysqld Server executable /usr/bin/mysqld_safe executable shell script for starting mysqld safely /var/lib/mysql location of database files EXAMPLE You can also read(2,n,1 builtins) a backup dump file(1,n) back into MySQL with: mysql database < backup-file.sql SEE ALSO isamchk(1), isamlog(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi- lege_tables(1), mysqlshow(1), mysql_zap(1), perror(1,3)(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://www.mysql.com/doc/en/ BUGS Please refer to http://bugs.mysql.com/ to report bugs. AUTHOR Ver 6.3, distribution 4.0.21 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). MySQL 4.0 19 December 2000 mysql(1)