Jordan Savant # Software Engineer

Dump all databases for backup:

mysqldump -u root -p[password] --opt > [/tmp/alldatabases.sql]

Dump one database for backup:

mysqldump -u [username] -p[password] --databases [databasename] > [/tmp/databasename.sql]

Dump a table from a database:

mysqldump -c -u [username] -p[password] [databasename] [tablename] > [/tmp/databasename.tablename.sql]