Re: mysqldump but exclude one table. .

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