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 )
--compact --add-drop-table, .
--compact --add-drop-table
:
--compact
. --skip-add-drop-table, --skip-add-locks, --skip-comments, --skip-disable-keys, and --skip-set-charset.:
--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 .