Backup
mysqldump -u root dbname > backup.sqlRestore
mysql -u root dbname < backup.sqlCommands
# Create database
CREATE DATABASE dbname;
# Create user
CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON dbname.* TO 'user'@'localhost';