Backup fails - SELECT command denied for table 'func'

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
biotech
Posts: 4
Joined: Thu 10 May 2012 16:37

Backup fails - SELECT command denied for table 'func'

Post by biotech » Thu 10 May 2012 16:48

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.

Viktor
Devart Team
Posts: 68
Joined: Thu 06 May 2010 08:12

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

Post by Viktor » Fri 11 May 2012 15:54

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.

biotech
Posts: 4
Joined: Thu 10 May 2012 16:37

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

Post by biotech » Fri 11 May 2012 18:46

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.

alexa

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

Post by alexa » Tue 15 May 2012 12:45

This feature will be implemented in the next version of the product.

biotech
Posts: 4
Joined: Thu 10 May 2012 16:37

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

Post by biotech » Tue 15 May 2012 16:39

Thanks Alexa.
Does this mean purchase current & get the free update later or should I wait?
Thanks.

Devart
Site Admin
Posts: 3974
Joined: Tue 26 Oct 2004 13:51

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

Post by Devart » Wed 16 May 2012 16:11

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

biotech
Posts: 4
Joined: Thu 10 May 2012 16:37

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

Post by biotech » Wed 16 May 2012 19:26

Free = new version will be released within a year? :)
Thank you.

Post Reply