Dump database to file mysqldump -u <username> -p <database> > <dump_filename> Create database from dump file. mysql> create database <db_name>; use <db_name>; source <absolute_path_to_dump_file>; ```