GNU/Linux man pages
Livre :
Expressions régulières,
Syntaxe et mise en oeuvre :
GNU/Linux |
RedHat 9.0(Shrike) |
|
 |
mysql(1) |
 |
mysql − text-based client for mysqld, a SQL-based relational database daemon
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]
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.
−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.
|
/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 |
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), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror (1), replace (1), safe_mysqld (1), which1 (1), zap (1),
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).
|
mysql(1) | |