Bug #25108 Backup a remote db fails
Submitted: 16 Dec 2006 9:45 Modified: 9 Jan 2007 11:51
Reporter: Ugo Grandolini Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.2.8 OS:Windows (windows xp home (italian))
Assigned to: CPU Architecture:Any
Tags: Backup

[16 Dec 2006 9:45] Ugo Grandolini
Trying to backup a db located on a remote host, backup seems to properly work but, while saving a 500.000 records table suddently stops with the following message:

"An Error occured while executing the backup.

The MySQL Server returned this Error:
MySQL Error Nr.0-"

Server is running MySQL 4.1.21-standard on a Linux system

How to repeat:
Logged at my provider cPanel X:
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. clicked on "Backup": I can see all the tables assigned to the new user (3.) in the schemata tab
6. create new backup project
7. dragged one db to the Backup Content tree list (selecting all tables)
8. clicked on the "Execute Backup Now" button
[26 Dec 2006 21:47] Sveta Smirnova
Thank you for the report.

Please try to make backup of your remote database using mysqldump command line utility located on local host. (To be sure problem is MySQL Administrator and not configuration of the server)
[8 Jan 2007 14:34] Ugo Grandolini
Sorry but I am not allowed to connect through mysqldump from my system. I guess the hosting service does not allow due to security issues.
[9 Jan 2007 10:33] Sveta Smirnova
If you can connect to remote MySQL server with one client (MySQL Administrator) you should connect with other (mysqldump).

Read about connection options of mysqldump at http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html Most  important are --port, --host, --user and --password
[9 Jan 2007 11:08] Ugo Grandolini
ok Sveta, I found out the way to connect. This is the problem I get:

mysqldump: Error 2013: Lost connection to MySQL server during query when dumping
 table `g_fnset_fpath` at row: 385961

Is there any way to make the connection persistent through mysqldump and/or mysql gui?

thank you
[9 Jan 2007 11:23] Sveta Smirnova
Ugo, there are many possible causes of this problem. But bug database is only place to hold information of bugs found in MySQL product. Your case likely looks as support request which we not allowed to handle here.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.
[9 Jan 2007 11:51] Ugo Grandolini

I posted on the forum as per your suggestion, however please consider this problem something that MySQL GUI programmers should take into account when coding the next version. If MySQL GUI cannot provide a backup feature letting users to be able to backup any database size (and I am sure there are many more larger than this...) it maybe better to remove the feature or let us know we can only backup small db.