Databases

databases

mysqldump -u USERNAME -pPASSWORD DBNAME > DBNAME.sql

mysqldump -uUSERNAME -p DBNAME | gzip > DBNAME-$(date +"%Y-%m-%d-%H-%M-%S").sql.gz
mysqldump --all-databases -uroot -p | gzip > mysql-alldbs-$(date +"%Y-%m-%d-%H-%M-%S").sql.gz

mongodump -dDBNAME -o DIRNAME

mongorestore --drop -d DBNAME DIRNAME/

mysql-create

CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE USER 'username'@'%' ;
SET PASSWORD FOR 'username'@'%' = PASSWORD('password');
GRANT USAGE ON *.* TO 'username'@'%'
GRANT ALL PRIVILEGES ON `dbname`.* TO 'username'@'%';

CREATE USER 'username'@'localhost';
SET PASSWORD FOR 'username'@'localhost' = PASSWORD('password');
GRANT USAGE ON *.* TO 'username'@'localhost';
GRANT ALL PRIVILEGES ON `dbname`.* TO 'username'@'localhost';

FLUSH PRIVILEGES;