http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html 

#mysqldump --opt -u user --password="password"
database | bzip2 -c > database.sql.bz2

 

Hassan wrote:
> Hello everyone,
> I've a reader for sometime now, the best db list ever got into.
>
> Well, I'd like to mysqldump a certain database, but with skipping one table, is it possible?
[snip]

from "mysqldump --help"

--ignore-table=name
Do not dump the specified table. To specify more than one
table to ignore, use the directive multiple times, once
for each table. Each table must be specified with both
database and table names, e.g. --ignore-table=database.table

forgotten, but found using "mysqldump --help | grep table" and some
quick scanning - docs are your friend :)

 

 

There are three general ways to invoke mysqldump:

shell> mysqldump [options] db_name [tables]
shell> mysqldump [options] --databases db_name1 [db_name2 db_name3...]
shell> mysqldump [options] --all-databases

If you do not name any tables following db_name or if you use the --databases or --all-databases option, entire databases are dumped.

mysqldump does not dump the INFORMATION_SCHEMA database. If you name that database explicitly on the command line, mysqldump silently ignores it.

 

---

---