MySQL Bugs: #40764: MySQL Administrator crashes trying to create backup project for large # tables

Bug #40764	MySQL Administrator crashes trying to create backup project for large # tables
Submitted:	16 Nov 2008 19:56	Modified:	5 Feb 2013 3:24
Reporter:	Chuck Klein	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	1.2.14	OS:	Windows (Vista 64bit)
Assigned to:		CPU Architecture:	Any
Tags:	SUPESC

Description:
I am trying to create a backup project for one of my databases that has over 4,000 tables. The Administrator stops responding and Vista exits the program when trying to add the database to the project. This was sen on 64 bit vista, but was not seen on XP32bit.

How to repeat:
Launch Administrator
Create a new backup project
Select a database with a large number of tables and add it to the project
Vista says the program has stopped responding and kills it

Thank you for the bug report. What is the server version do you've tried to make the backup project, average of numbers of columns ands data size does difference?.
Thanks in advance.

Thank you for the bug report. Verified on XP 32-bit trying to backup the test database with 4500 tables created with the below C client application:

#include <my_global.h>
#include <m_string.h>
#include "mysql.h"

#define DB_HOST			"localhost"
#define DB_USER			"root"
#define DB_PASSW		""
#define DB_NAME			"test"
#define DB_PORT			3500
#define DB_UNIX_SOCKET	"/tmp/mysql.sock" //NULL

void main( void )
{
  MYSQL mysql;
  int x, y;
	char my_sub[255],my_query[255];
 
  mysql_init(&mysql);
  
   
  if (!mysql_real_connect(&mysql,DB_HOST,DB_USER,DB_PASSW,DB_NAME,
						   DB_PORT,DB_UNIX_SOCKET,0))
  {
    printf("Error: %s\n",mysql_error(&mysql));
    return;
  }
  else
	printf("Connected to the server: %s\n",mysql_get_server_info(&mysql));

   for (x = 0; x <= 4500; x++)
    {
	  int10_to_str((int) x,strmov(my_sub,"Create Table if not exists tb"), 10);

	  strxnmov(my_query,sizeof(my_query)-1,my_sub," (id int not null auto_increment primary key, name varchar(200))engine=MyISAM",NullS);
	 	     
	 if (mysql_query( &mysql, my_query) )
	 {
        printf("Error (query): %s\n", mysql_error( &mysql ));
        mysql_close( &mysql );
        return;
	 }
    }
  mysql_close(&mysql);
}

My server version is 5.0.67-community-nt. 

Note the problem was NOT seen on 32bit XP. It WAS seen on 64 bit Vista.

Performance problem, enumerating 4500 tables takes too long

Closing bug for obsolete product