Next Previous Up Top Contents Index

4. Syntaxe

4-2 mysqldump

mysqldump  Ver 4.0 Distrib 3.21.24-gamma, for sun-solaris2.6 (sparc)
By Igor Romanenko & Monty & Jani. This software is in public Domain
This software comes with ABSOLUTELY NO WARRANTY

Dumping definition and data mysql database or table
Usage: mysqldump [OPTIONS] database [tables]

  -#, --debug=...       Output debug log. Often this is 'd:t:o,filename'
  -?, --help            Displays this help and exits.
  -c, --compleat-insert Use complete insert statements.
  -F  --flush-logs      Flush logs file in server before starting dump
  -f, --force           Continue even if we get an sql-error.
  -h, --host=...        Connect to host.
  -l, --lock-tables     Lock all tables for read.
  -t, --no-create-info  Don't write table creation info.
  -d, --no-data         No row information.
  -O, --set-variable var=option
                        give a variable an value. --help lists variables
  -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.
  -q, --quick           Don't buffer query, dump directly to stdout.
  -S, --socket=...      Socket file to use for connection.
  -T, --tab=...         Creates tab separated textfile for each table to
                        given path. (creates .sql and .txt files)
  -u, --user=#          User for login if not current user.
  -v, --verbose         Print info about the various stages.
  -V, --version         Output version information and exit.

Memo mySQL - 29 Apr 1998

Next Previous Up Top Contents Index

Generated with Harlequin WebMaker