you need not stop management server to take a dump. Which version of cloudstack is it? Can you also share the output of show create table 'cloud_test.account_netstats_view'? Are you seeing this error while taking the dump or applying it?
This is the command I use to save a db dump and works perfectly fine even when the management server is running. $mysqldump -uusername --databases cloud cloudbridge cloud_usage | bzip2 > /tmp/db_dumps/ACS.sql.bz2 ~Rajani On Wed, Sep 10, 2014 at 9:37 AM, Hollman Enciso R. <hollman.enc...@gmail.com > wrote: > any idea ? > > i'm just create a crontab with normal mysqldump of the database cloud but i > always obtain these error. > > maybe I have to stop the management or something to backing up the database > ? > > On Fri, Sep 5, 2014 at 11:25 AM, Hollman Enciso R. < > hollman.enc...@gmail.com > > wrote: > > > Hello, i'm trying to generate a backup of cloud database but it's > > generating this error. > > > > Any idea why or how can I made a Backup of cloud database? > > > > > > ERROR 1356 (HY000) at line 8807: View 'cloud_test.account_netstats_view' > > references invalid table(s) or column(s) or function(s) or > definer/invoker > > of view lack rights to use them > > > > thanks > > > > -- > > Hollman Eduardo Enciso R. > > http://algolibre.com > > @hollman > > > > > > -- > Hollman Eduardo Enciso R. > http://algolibre.com > @hollman >
