mysqldump

Examples:

mysqldump –add-drop-table -h mysqlhostserver -u mysqlusername -p databasename (tablename tablename tablename)

mysqldump –tab=/path/to/some/dir –opt db_name