Is it possible to dump and import views using mysqldump?

When I use mysqldump and reimport the dump, the views become empty tables.

Is it possible either

a) dump and then import the views without turning them into empty tables?

or, if a is impossible,

b) exclude wildcard representations from mysqldump, e.g.

mysqldump mydb  --ignore-table=*views > mydb.sql

to exclude all views if all views have names ending in the string "views"? (this part was previously set, but remains unanswered: Ignore the "views" in the mysql db backup using mysqldump )

+3
source share
1 answer

--compact --add-drop-table, .

:

--compact

. --skip-add-drop-table, --skip-add-locks, --skip-comments, --skip-disable-keys, and --skip-set-charset.
:

MySQL 5.1.21 SQL, . , . --compact -add-drop-table .

+1

All Articles