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.