Re: Backup DB Data function

Hi Mike,

it only happens when I try to backup data from the public server.

Sequence.

Logged at my provider cPanel
1. in the "MySQL Databases | Access hosts" page, added my own IP address
2. created a new user/pw with ALL privileges
3. added the user to all the db I want to backup/edit

Opened MySQL Administrator
4. succesfully accessed the database
5. click on Backup: I can see all the tables assigned to the new user 
(3.) in the schemata tab
6. followed your instruction and I get the problem.

I do not think I will be able to access as root as the provider will 
surely deny this for security reasons.

Hope it helps for the debug.
If you need any further help please do not hesitate to ask.

Note: locally I am able to backup with no problem at all.

Thank you,
Ugo


Mike Lischke wrote:
>> then I get a dialog with the following message:
>> "An Error occured while executing the backup.
>> Error while analyzing an SQL statement."
>>     
>
> Sounds like a bug I fixed 6 days ago
> (http://bugs.mysql.com/bug.php?id=24808). Do you do the backup connected as
> a user who does not have access to the mysql schema? Try doing the backup as
> root. The next release of the GUI tools is planned for yet this week, which
> then contains a fix for this problem.
>
> Mike
> --
> Mike Lischke, Software Engineer GUI
> MySQL AB, www.mysql.com
>
>
>