Page 1 of 1

Backup fails - SELECT command denied for table 'func'

Posted: Thu 10 May 2012 16:48
by biotech
Hello there,
Just trying out the application and ran into some snags.
When I try to execute a backup I get an error:

Code: Select all

SELECT command denied to user 'myuser'@'my.isp.ip.etc' for table 'func'
and the rest of the tables get exported fine, restore also works fine but this error won't go away and there is NO table 'func' in my db and have full rights to the db being backed up. What gives?

Also, I could not find a way to schedule a backup other than an old implementation of windows Task Scheduler. In slight disbelief I have to ask, can someone please confirm that the dbForge actually has a GUI for scheduling?

Thanks again.

Re: Backup fails - SELECT command denied for table 'func'

Posted: Fri 11 May 2012 15:54
by Viktor
Rights for SELECT of the "func" table are necessary for retrieval of the UDF list. To avoid the error message, uncheck the UDF box on the "Backup content" of the backup wizard.

Implementation of the GUI for sheduling in dbForge Studio for MySQL has been planned for the future, meanwhile you can use Windows Task Scheduler.

Re: Backup fails - SELECT command denied for table 'func'

Posted: Fri 11 May 2012 18:46
by biotech
Worked, thank you very much.
Any time frame on GUI scheduler? - not that it is oppressing but it would be nice.
Otherwise, loving the application.

Re: Backup fails - SELECT command denied for table 'func'

Posted: Tue 15 May 2012 12:45
by alexa
This feature will be implemented in the next version of the product.

Re: Backup fails - SELECT command denied for table 'func'

Posted: Tue 15 May 2012 16:39
by biotech
Thanks Alexa.
Does this mean purchase current & get the free update later or should I wait?
Thanks.

Re: Backup fails - SELECT command denied for table 'func'

Posted: Wed 16 May 2012 16:11
by Devart
Hello,

On you wish - You can purchase a current version now and you will get a free upgrade to the new version on its release.

Regards,
Devart Support

Re: Backup fails - SELECT command denied for table 'func'

Posted: Wed 16 May 2012 19:26
by biotech
Free = new version will be released within a year? :)
Thank you.