#mysql #backup #dump #sql

mysql.sh

# dump all databases
mysqldump --user=root --password=pass --all-databases > localhost.sql

# dump specific databases
mysqldump --user=root --password=pass --databases DB_NAME1 DB_NAME2 DB_NAME3 > backup.sql

# restore from file
mysql --verbose --user=root --password=pass DB_NAME < /PATH/TO/DUMPFILE.SQL

# copy database
mysqldump -u root -pPWD DB_NAME1 | mysql -u root -pPWD DB_NAME2

# create database utf
CREATE DATABASE DB_NAME1 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;