Restore

To backup a single database: mysqldump --user=root --password=password mydb > mydb.sql Yes it is no typo, there is no space between the -p and the password! You may like to add this to the my.cfg file in etc to avoid [mysqldump] events ignore-table=mysql.events If you didn’t use the …