Welcome to Linux Knowledge Base and Tutorial
"The place where you learn linux"
International Rescue Committe

 Create an AccountHome | Submit News | Your Account  

Tutorial Menu
Linux Tutorial Home
Table of Contents

· Introduction to Operating Systems
· Linux Basics
· Working with the System
· Shells and Utilities
· Editing Files
· Basic Administration
· The Operating System
· The X Windowing System
· The Computer Itself
· Networking
· System Monitoring
· Solving Problems
· Security
· Installing and Upgrading
· Linux and Windows

Glossary
MoreInfo
Man Pages
Linux Topics
Test Your Knowledge

Site Menu
Site Map
FAQ
Copyright Info
Terms of Use
Privacy Info
Disclaimer
WorkBoard
Thanks
Donations
Advertising
Masthead / Impressum
Your Account

Communication
Feedback
Forums
Private Messages
Surveys

Features
HOWTOs
News Archive
Submit News
Topics
User Articles
Web Links

Google
Google


The Web
linux-tutorial.info

Who's Online
There are currently, 347 guest(s) and 0 member(s) that are online.

You are an Anonymous user. You can register for free by clicking here

  

mysql




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 sup­
              plied, it will be requested interactively.

       -P|--port=pnum
              Employ the specified port number for connecting  to
              the database server.

       -q|--quick

       -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/mysqld_safe
                             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), mysqld_safe  (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).

MySQL 4.0                19 December 2000                mysql(1)
  
Help us cut cost by not downloading the whole site!
Use of automated download sofware ("harvesters") such as wget, httrack, etc. causes the site to quickly exceed its bandwidth limitation and therefore is expressedly prohibited. For more details on this, take a look here

Login
Nickname

Password

Security Code
Security Code
Type Security Code


Don't have an account yet? You can create one. As a registered user you have some advantages like theme manager, comments configuration and post comments with your name.

Help if you can!


Amazon Wish List

Did You Know?
You can get all the latest Site and Linux news by checking out our news page.


Friends



Tell a Friend About Us

Bookmark and Share



Web site powered by PHP-Nuke

Is this information useful? At the very least you can help by spreading the word to your favorite newsgroups, mailing lists and forums.
All logos and trademarks in this site are property of their respective owner. The comments are property of their posters. Articles are the property of their respective owners. Unless otherwise stated in the body of the article, article content (C) 1994-2013 by James Mohr. All rights reserved. The stylized page/paper, as well as the terms "The Linux Tutorial", "The Linux Server Tutorial", "The Linux Knowledge Base and Tutorial" and "The place where you learn Linux" are service marks of James Mohr. All rights reserved.
The Linux Knowledge Base and Tutorial may contain links to sites on the Internet, which are owned and operated by third parties. The Linux Tutorial is not responsible for the content of any such third-party site. By viewing/utilizing this web site, you have agreed to our disclaimer, terms of use and privacy policy. Use of automated download software ("harvesters") such as wget, httrack, etc. causes the site to quickly exceed its bandwidth limitation and are therefore expressly prohibited. For more details on this, take a look here

PHP-Nuke Copyright © 2004 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.09 Seconds