我有80个左右的view呢,要是这样,那得执行多少条sql语句啊?杯具了!
[/Quote]
写1个BAT嘛,示例
a1,a2为数据库名
@echo off
FOR %%J IN (a1,a2) DO (for /f %%i in ('J:\MYSQL\BIN\mysql -uroot -p123 -N -e "SELECT A.`TABLE_NAME` FROM `information_schema`.`TABLES` A WHERE A.`TABLE_TYPE`='VIEW' AND A.`TABLE_SCHEMA`='%%J'";') do (@echo off & @echo "正在备份%%i">nul & J:\MYSQL\BIN\mysqldump -uroot -p123 --compact --skip-opt %%J %%i >> R:\TEMP\123.txt))