Backup
mysqldump -u root dbname > backup.sqlRestore
mysql -u root dbname < backup.sql
# For compressed backups
bzcat backup.sql.bz2 | mysql -u root dbnameCommands
# Create database
CREATE DATABASE dbname;
# Create user
CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON dbname.* TO 'user'@'localhost';