zcatを使ってgzファイルのdumpファイルをリストアする

# zcat dump.sql.gz | mysql -u root -rootpw db-name

[MySQL5.7]WordPressのDB作成

$ grep ‘temporary password’ /var/log/mysqld.log $ mysql_secure_installation change root pass all Y create DB a […]

ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘xxxxx’;

show variables like “chara%”; +————————–+—————————-+ | Variable_name | Valu […]

show variables like “chara%”;

dump $ mysqldump -u root -p -h xxxxxxxxxxxx –skip-lock-tables –single-transaction -v -P xxxxx DB-name table- […]