How to save views in MariaDB/MySQL?

Asked Dec 18 '15 at 23:47

Active Dec 18 '15 at 23:53

Viewed 140 times

I need to port my MariaDB to another computer. I regularly use mysqldump to save the structure and tables, so it's not a big deal. But mysqldump does not save the views - or rather the SQL statements behind the views.

How can I save and reload the SQL views?

asked Dec 18 '15 at 23:47

Jasio

Possible duplicate of [Backing Up Views with Mysql Dump](http://stackoverflow.com/questions/1658204/backing-up-views-with-mysql-dump) – Shadow Dec 19 '15 at 02:06
Use `--opt` option while making the dump – Hackerman Dec 21 '15 at 12:40

How to save views in MariaDB/MySQL?

0 Answers0