MySQL Bugs: #25108: Backup a remote db fails

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:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.2.8	OS:	Windows (windows xp home (italian))
Assigned to:		CPU Architecture:	Any
Tags:	Backup

Description:
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

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)

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.

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

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

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.

Sveta,

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.
=/