The mysqldump command dumps databases/tables to standart output. You can use pipe redirect to save it to file: mysqldump [options] >dump.sql When you dump a database there are some options of mysqladmin you need to understand: