$(echo "use mydbname ; show tables like 'mytblprefix%'" | mysql --skip-column-names) > mybackup.sql

MySqlDump lets you backup or dump your database(s)
$ mysqldump --host mydbhost --user=myuser --password --all-databases > mybackup.sql
$ mysqldump -h mydbip -u myuser -p --add-drop-table mydatabase > mydbbackup.sql
--complete-insert --skip-lock-tables --skip-extended-insert \
mydatabase mytable > mybackup.sql
mysqldump --user=myuser --password \
--complete-insert --compatible=ansi --skip-extended-insert --skip-quote-names \
mydatabase mytable -w "mycolumn in ('IC','GG','GJ','IM')" > mybackup.sql

Backup multiple tables (with wildcards !)

--skip-extended-insert --skip-quote-names --complete-insert --compatible=ansi \
mydbname
$(echo "use mydb ; show tables like 'mytblprefix%'" | mysql --skip-column-names) > mybackup.sql
$ mysqldump -h myhost -u myuser -p \
--skip-add-locks --skip-quote-names --no-data \
mydbname > mydb.sql
Also see
MySqlRestore

Backup a single table (with where clause)

mysqldump \
-c --skip-extended-insert --skip-quote-names \
mydb mytable -w "mycolumn in ('IC','GG','GJ','IM')" > mytable.sql

mysqldump lets you backup or dump your database
Password:
Password:
$ mysqldump --user=myuser --password \
--complete-insert --skip-lock-tables --skip-extended-insert mydb mytable > mytablebackup.sql
Password:

Backup database into a single file

structure only
$ mysqldump -h myhost -u myuser -p mydbname \
--skip-add-locks --skip-quote-names --no-data > mydb.sql
Password:
structure with data
$ mysqldump -h myhost -u myuser -p mydbname \
--skip-add-locks --skip-quote-names --compatible=ansi --skip-extended-insert > mydb.sql
Password:
Password:
Password:
Password:
Password:

$ mysqldump -h myhost -u myuser -p mydbname --no-data --skip-quote-names > mydbnamestruct.sql
$ mysqldump -h myhost -u myuser -p mydbname --skip-add-locks --compatible=ansi --skip-extended-insert fsseinf_wikkawiki > fsse.sql

$ mysqldump --host mydbip --user=myuser --password --all-databases > mydbbackup.sql
$ mysqldump -h mydbip -u myuser -p --add-drop-table mydb > mydbbackup.sql

Backup a single table

$ mysqldump --complete-insert --skip-lock-tables --skip-extended-insert --user=myuser --password mydb mytable > mytablebackup.sql

Backup table into XML

Backup table to XML
$ mysqldump -h myhost -u myuser -p --skip-lock-tables --compact --xml mydb mytable

$ mysqldump -h myhost -u myuser -p --no-data --skip-lock-tables --compact --tab=mydir mydb

$ mysqldump -u myuser -p --add-drop-table mydb > mydbbackup.sql
$ mysqldump --user=myuser --password --all-databases > mydbbackup.sql

Backup structure into a single file

$ mysqldump -h myhost -u myuser -p mydbname --no-data --skip-quote-names mydb > mydbnamestruct.sql

Backup structure into multiple files

Backup structure of all tables to separate .sql files ready for adding to subversion
$ mysqldump -h myhost -u myuser -p --no-data --skip-lock-tables --compact -T mydir mydb
$ mysql -u username -p mydb < mydbbackup.sql
$ mysql --user=username --password mydb < mydbbackup.sql

$ mysqldump -u mysqluser -p --add-drop-table mydbname > mydbbackup.sql

$ mysqldump --user=mysqluser --password --all-databases  > mydbbackup.sql

$ mysqldump -u mysqluser -p mydbname --no-data --skip-quote-names mydbname > mydbnamestruct.sql

$ mysql -u username -p mydbname < mydbbackup.sql
or
$ mysql --user=username --password mydbname < mydbbackup.sql