dump database via ssh telnet

[nagasea]

usually I used this command to dump all the database tables into 1 file (.sql)

mysqldump --opt -uUSERNAME -p databasename > /path/to/dump.sql

the problem is the database now is become so bigggg.. (more than 400mb).

my question is, how to dump the database for only 1 or 2 table.

[LordShryku]

use the --tables option.

Also for compression, pipe it to a bzip2 command

mysqldump --opt --tables [table1] [table2] -u [user] -p[password] [database] | bzip2 -c > database.sql.bz2