查看所有视图表
[root@localhost ~]# mysql -uroot -p dbname -e "show full tables where table_type='view'"
Enter password:
编辑视图导出脚本
#vi backupViews.sh
#!/bin/bash
#
/usr/bin/mysql --skip-column-names --batch -e \
"select table_name from information_schema.views \
where table_schema = database()" $* |
xargs --max-args 1 /usr/bin/mysqldump $*
执行视图导出脚本
[root@localhost ~]# ./backupViews.sh -uusername -ppassword dbname > views.sql
Warning: Using a password on the command line interface can be insecure.
......
Warning: Using a password on the command line interface can be insecure.
[root@localhost ~]#