Login or Register to Ask a Question and Join Our Community

Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

mysql(1) [redhat man page]

MYSQL(1)						      General Commands Manual							  MYSQL(1)

NAME

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

SYNOPSIS

       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]

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

       -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

SEE ALSO

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

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

								   13 June 1997 							  MYSQL(1)

Check Out this Related Man Page

mysqlshow(1)							  MySQL database						      mysqlshow(1)

NAME

       mysqlshow
	- Shows the structure of a mysql database (databases,tables and columns)

USAGE

       shell> mysqlshow [OPTIONS] [database [table [column]]]

SYNOPSIS

       mysqlshow   [-#|--debug=...]    [-?|--help]   [-c|--character-sets-dir=...]   [-C|--compress]  [-h|--host=...]	[-i|--status]  [-k|--keys]
       [-p|--password[=...]]  [-P|--port=...]  [-S|--socket=...]  [-u|--user=#] [-V|--version]

DESCRIPTION

       -#|--debug=...
	      output debug log. Often this is 'd:t:o,filename`

       -?|--help
	      display help and exit

       -c|--character-sets-dir=...
	      Directory where character sets are

       -C|--compress
	      Use compression in server/client protocol

       -h|--host=...
	      connect to host

       -i|--status
	      Shows a lot of extra information about each table

       -k|--keys
	      show keys for table

       -p|--password[=...]
	      password to use when connecting to server If password is not given it's asked from the tty.

       -P|--port=...
	      Port number to use for connection

       -S|--socket=...
	      Socket file to use for connection

       -u|--user=#
	      user for login if not current user

       -V|--version
	      output version information and exit

NOTE

       If last argument contains a shell or SQL wildcard (*,?,% or _) then only what's matched by the wildcard is shown.  If no database is  given
       then  all matching databases are shown.	If no table is given then all matching tables in database are shown If no column is given then all
       matching columns and columntypes in table are shown

SEE ALSO

       isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi-
       lege_tables(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://www.mysql.com/doc/en/

BUGS

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

AUTHOR

       Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/).  This  software  comes  with	no
       warranty.   Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercur-
       media.com)

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +--------------------+------------------------------------+
       |  ATTRIBUTE TYPE    |	       ATTRIBUTE VALUE		 |
       +--------------------+------------------------------------+
       |Availability	    | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
       +--------------------+------------------------------------+
       |Interface Stability | External				 |
       +--------------------+------------------------------------+
NOTES

       Source for mysql is available on http://opensolaris.org.

MySQL 4.0							 19 December 2000						      mysqlshow(1)
Man Page