mysqlshow(1) [opensolaris 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)

Check Out this Related Man Page

safe_mysqld(1)							  MySQL database						    safe_mysqld(1)

NAME

       mysqld_safe - start the mysqld daemon on Unix.

SYNOPSIS

       mysqld_safe  [--basedir=path]  [--core-file-size=#]  [--defaults-extra-file=path]  [--defaults-file=path] [--open-files=#] [--datadir=path]
       [--err-log=path] [--ledir=path] [--log=path] [--no-defaults] [--open-files=#] [--pid-file=path] [--port=#]  [--socket=path]  [--timezone=#]
       [--user=#]

DESCRIPTION

       mysqld_safe adds some safety features such as restarting the server when an error occurs and logging run-time information to a log file.

       --basedir=path

       --core-file-size=#
	      Size of the core file mysqld should be able to create. Passed to ulimit -c.

       --defaults-extra-file=path

       --defaults-file=path

       --datadir=path

       --err-log=path

       --ledir=path
	      Path to mysqld

       --log=path

       --no-defaults

       --open-files=#
	      Number of files mysqld should be able to open. Passed to ulimit -n.

       --pid-file=path

       --port=#

       --socket=path

       --timezone=#
	      Set the timezone (the TZ) variable to the value of this parameter.

       --user=#

NOTE

       Note  that  all options on the command line to mysqld_safe are passed to mysqld. If you wants to use any options in mysqld_safe that mysqld
       doesn't support, you must specify these in the option file.

SEE ALSO

       isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(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://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 war-
       ranty.	Manual	page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercurme-
       dia.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						    safe_mysqld(1)

Linux and UNIX Man Pages

mysqlshow(1) [opensolaris man page]

Check Out this Related Man Page