参考 https://blog.csdn.net/amberom/article/details/80605788
@echo off
set "dbIp=127.0.0.1"
set "dbPort=3306"
set "dbUser=xxx"
set "dbPasswd=xxx"
set "binDir=C:\Program Files\MySQL\MySQL Workbench 8.0 CE"
cd %binDir%
set "rootDir=C:\Backup\rds"
set "tFile=%rootDir%\tmp_db.txt"
set "dt=%date:~,4%%date:~5,2%%date:~8,2%_%time:~,2%%time:~3,2%%time:~6,2%"
set "tDir=%rootDir%\myyshop-supplier-mysql-01-%dt%"
echo "%tDir%"
md %tDir%
mysql -h %dbIp% -P %dbPort% -u %dbUser% -p%dbPasswd% -s -e "SELECT schema_name FROM information_schema.SCHEMATA WHERE schema_name NOT IN ('information_schema', 'innodb', 'mysql', 'performance_schema', 'tmp', 'sys')" > %tFile%
for /f "delims=" %%a in ( %tFile%) do (
echo %%a
mysqldump -h %dbIp% -P %dbPort% -u %dbUser% -p%dbPasswd% --skip-lock-tables --skip-triggers --column-statistics=0 --set-gtid-purged=OFF %%a > %tDir%\%%a.sql
)
@echo on
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26250550/viewspace-2773123/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- MySQL DDL Waiting for table metadata lock 解决
- MySQL latch争用深入分析
- 查询结果集很小，但 Created_tmp_disk_tables 不断增加
- MySQL 8.0 窗口函数-笔记
- PyMySQL 获取数据 'utf-8' codec can't decode byte 0xed in position 2: 错误
- MySQL 存储过程进行切换表
- python openpyxl笔记
- Mysql5.7 的错误日志中最常见的note日志
- Percona-Toolkit 之 pt-archiver
- 【Python】用原生的urllib2+httplib请求Https
