one command mysqldump and restore code example Example: mysqldump restore mysql -u [user] -p [database_name] < [filename].sql