mysql mysqldump备份与还原（导入与导出）

最新推荐文章于 2024-04-21 22:51:21 发布

cgv3

最新推荐文章于 2024-04-21 22:51:21 发布

阅读量964

点赞数 1

分类专栏： sql 文章标签： mysql备份还原 mysql导入导出 mysqldump导入导出 mysqldump备份还原 mysql备份还原脚本

本文链接：https://blog.csdn.net/csdn_avatar_2019/article/details/130614117

版权

sql 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

1、备份/导出

使用mysqldump命令行

# mysqldump -u{username} -p{password} {dbname} > ./{backup_filename}.sql
mysqldump -uroot -p123456 db1 > ./backup_db1.sql

备份/导出脚本简单示例

#!/bin/bash

#定义数据库常量
MYSQL_BIN_PATH=/usr/local/mysql-8.0/bin
IP=127.0.0.1
USER=root
PWD=123456
PORT=3306

clear

echo "[Backup Start]"
echo ""

echo "backup db1 start..."
$MYSQL_BIN_PATH/mysqldump -u$USER -p$PWD db1 > ./backup_db1.sql
echo "backup db1 finish."
echo "backup db2 start ..."
$MYSQL_BIN_PATH/mysqldump -u$USER -p$PWD db2 > ./backup_db1.sql
echo "backup db2 finish."

echo ""
echo "[Backup End]"

2、还原/导入

使用mysqldump命令行

#mysql -u{username} -p{password} -P{port} --default-character-set=utf8 {dbname} < ./{backup_filename}.sql
mysql -uroot -p123456 -P3306 --default-character-set=utf8 db1 < ./backup_db1.sql

还原/导入脚本简单示例

#!/bin/bash

#定义数据库常量
MYSQL_BIN_PATH=/usr/local/mysql-8.0/bin
IP=127.0.0.1
USER=root
PWD=123456
PORT=3306

clear

echo "[Restore Start]"
echo ""

echo "restore db1 start..."
#将上一步导出的.sql文件导入数据库
$MYSQL_BIN_PATH/mysql -u$USER -p$PWD -P$PORT --default-character-set=utf8 db1 < ./backup_db1.sql
echo "restore db1 finish."
echo "restore db2 start ..."
$MYSQL_BIN_PATH/mysql -u$USER -p$PWD -P$PORT --default-character-set=utf8 db2 < ./backup_db2.sql
echo "restore db2 finish."

echo ""
echo "[Restore End]"