mysql backups

mysql_backups

A database:
backup: # mysqldump -u user -p  [database_name] > dumpfilename.sql
restore:# mysql -u user -p [database_name] < dumpfilename.sql

Several databases:
 mysqldump -u root -p --databases bugs sugarcrm > bugs_sugarcrm.sql
 
All the databases:
mysqldump -u root -p --all-databases > /tmp/all-database.sql

A single table:
mysqldump -u user -p sugarcrm accounts_contacts   > /tmp/sugarcrm_accounts_contacts.sql