MySQL Dump examples

Here will post several MySQL dump examples wich can be useful in different cases:

Dump a concrete database:

mysqldump -u user -p my-database

Dump a concrete database and compress it (using bzip2):

mysqldump -u user -p my-database | bzip2 > my-database-dump-date.bz2

Dump a concrete table:

mysqldump -t -u user -p my-database mytable  > my-table-dump-date.sql

Dump a concrete table with some query:

mysqldump -t -u user -p my-database my-table --where="mt-date<='2015-04-03'" > my-table-till_20150403_dump.sql

Dump without locking tables
mysqldump -u user -p --skip-lock-tables --single-transaction my-database