備份

mysqldump -u用戶名 -p密碼? -hIP? -Pport --set-gtid-purged=OFF --default-character-set=GBK --single-transaction --hex-blob --triggers --routines --events -B database > /data/mysql/backup/20201127/dev.sql

恢復(fù)前的操作

查看當(dāng)前所有的database

mysql>show databases;

刪除已存在的數(shù)據(jù)庫

mysql>drop database test;

創(chuàng)建數(shù)據(jù)庫

mysql>CREATE DATABASE test DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;

創(chuàng)建用戶和密碼

mysql>create user 'nusp'@'%' identified by 'nusp';

賦予權(quán)限

mysql>grant all privileges on test.* to nusp@”%” identified by ’nusp′;

mysql>flush privileges;

恢復(fù)

mysql? -u用戶名? -p密碼? -D數(shù)據(jù)庫名 < /data/mysql/backup/20201127/dev.sql