mysqldump

Examples of exporting mysql databases and/or tables

Export full databasename to bzip2 compressed sql file:

mysqldump -u admin -a -c -h localhost --password="password" --ignore-table=mysql.event  --compress --add-drop-table --add-drop-database --skip-comments --single-transaction --databases databasename | bzip2 -z9 > database.sql.bz2

Export tablename from databasename to sql file:

mysqldump -u admin -a -c -h localhost --password="password"  --compress --add-drop-table  --skip-comments --single-transaction databasename tablename > tablename.sql