Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
mongoip=$(kubectl -n zadig get po -owide|grep mongo|awk '{print $6}')
mongorestore -h $mongoip --port 27017 -u root -p zadig -d zadig --drop 文件存储路径authenticationDatabase admin ./zadig
##-d后面的数据库名可以自己指定

恢复 MySQL 数据

Code Block
登陆到新的mysql
mysqlip=$(kubectl -n zadig get po -owide|grep mysql|awk '{print $6}')
mysql -h $mysqlip -P 3306 -u root -pzadig
mysql> drop database user;
mysql> create database user;
mysql> drop database dex;
mysql> create database dex;
mysql> exit;
mysql -h $mysqlip -P 3306 -uroot user -p <user.sql
mysql -h $mysqlip -P 3306 -uroot dex -p <dex.sql