Re: mysqldump but exclude one table. .

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



C:\>mysqldump --version
mysqldump  Ver 9.09 Distrib 4.0.16, for Win95/Win98 (i32)

C:\>mysqldump --help | grep table
STDIN   6       Dumping definition and data mysql database or table
STDIN   7       Usage: mysqldump [OPTIONS] database [tables]
STDIN   22        --add-drop-table    Add a 'drop table' before each 
create.
STDIN   31                            In this case no tables are given. 
All name arguments are
STDIN   41        -K, --disable-keys  '/*!40000 ALTER TABLE tb_name 
DISABLE KEYS */; and
STDIN   42                            '/*!40000 ALTER TABLE tb_name ENABLE 
KEYS */; will be put
STDIN   54        -x, --first-slave   Locks all tables across all 
databases.
STDIN   61        -l, --lock-tables   Lock all tables for read.
STDIN   65        --no-autocommit     Wrap tables with autocommit/commit 
statements.
STDIN   67                            Dump all tables in single 
transaction to get consistent
STDIN   68                            snapshot. Mutually exclusive with 
--lock-tables.
STDIN   74                            Don't write table creation info.
STDIN   80        --opt               Same as --add-drop-table --add-locks 
--all --quick
STDIN   81                            --extended-insert --lock-tables 
--disable-keys
STDIN   88        -Q, --quote-names   Quote table and column names with a 
`
STDIN   94        -T, --tab=name      Creates tab separated textfile for 
each table to given
STDIN   98        --tables            Overrides option --databases (-B).
STDIN   112     add-drop-table                    FALSE
STDIN   132     lock-tables                       FALSE


C:\>mysqldump --help | grep ignore

nada.

Ummm. What version are you using, Martin?

David

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux