Hi, first off, thanks for the awesome module!

I'm having an issue now trying to duplicate my site to test future updates, and I've noticed that the webform/mysql tables are not coming through my mysql dumps either through phpmyadmin or through demo site reset module... has anyone else experienced this? Any pointers?
Thanks again,

Comments

cafuego’s picture

cafuego commented

The webform_mysql_view tables aren't tables as such, they're views. Check that the user accessing the views has the correct mysql permission. Specifically, the SHOW VIEW privilege.

wing112707’s picture

wing112707 commented

hello cafuego how to backup webform_mysql_view tables and how to set permission to user in SHOW VIEW privilege? Please help us.

cafuego’s picture

cafuego commented
Status: Active » Closed (works as designed)

You need to run the query:

GRANT 'SHOW VIEW' ON database.* TO `user`@`host`;

as privileged mysql user via the commandline, or set the Show_view_priv column to Y for the given user and the given database in the `mysql.db' table and then flush MySQL privileges via your favourite administrative frontend.