Sqlyog 4.2 Rc2 Crash: Copy Database To Different..

[pcdinh]

MySQL 5.0.15 Final. Port: 3307

Windows XP SP1

Database name: mytest

5 tables, type: Innodb with several data rows

On the left panel, right click on the name of the database, click on the item Copy database to different host/db –> SQLyog crashes immediately.

Windows report attd.

Thanks

Dinh

http://www.goldenkey.edu.vn/en

[pcdinh]

This is a fresh attachment. Use it instead.

Thanks

Dinh

http://www.goldenkey.edu.vn/en

[peterlaursen]

1) We need the create statement for the tables!

The windows report is not worth much!

2) Do you have Views, triggers or Stored Procedures in the database ?

3) What is your SQLyog version ?

4) Do you connect to the MySQL server on prot 3307 or do you use port 3307 for SSH-tunnelling? Is the WinXP machine the client or server machine or both? What sort of connections are open when it happens ?

You really will have to EXPLAIN so that we can reproduce exactly the same situation!

and BTW: I have just copied a HUGE database with InnoDB tables using both connections on port 3307 and SSH port forwarding on port 3307.

[Ritesh]

As Peter described, we will need more details about your setup. Are you connecting to a remote server?

Can you mail me a screenshot of your connection window?

BTW, what does show tables from `yourdb` return?

[pcdinh]

Ritesh wrote on Oct 30 2005, 05:53 AM:

As Peter described, we will need more details about your setup. Are you connecting to a remote server?

Can you mail me a screenshot of your connection window?

BTW, what does show tables from `yourdb` return?

[post=”7732″]<{POST_SNAPBACK}>[/post]

I just installed MySQL 5.0.15 Final on my Windows XP box yesterday and create a database schema to play with InnoDB. Here is my complete SQL script:

Code:

/* Database schema for http://www.goldenkey.edu.vn
  Create 2 table book_orders and customers
  This two table act as the initial tables for the shopping cart
  application in http://www.goldenkey.edu.vn
*/
create table courses (id int not null auto_increment,
                     course_name varchar(40) not null,
                     startdate date not null,
                     enddate date not null,
                     primary key (id)) type=InnoDB default charset=utf8;

create table customers (id int not null auto_increment,
                       name varchar(40) not null,                        
                       address varchar(40) not null,
                       primary key (id))type=InnoDB default charset=utf8;

create table enrolments (
                      id int not null auto_increment,
                      class_type varchar(50),
                      valid_from date not null,
                      valid_until date not null,
                      customer_id int not null,
                      foreign key (customer_id) references customers(id),
                      primary key (id)) type=InnoDB default charset=utf8;

create table course_customer (course_id int not null,
                             foreign key (course_id) references courses(id),
                             customer_id int not null,
                             foreign key (customer_id) references customers(id)
                            ) type=InnoDB default charset=utf8;

create table book_orders (id int not null auto_increment,
                    items varchar(30) not null,
                    saledate date not null,
                    customer_id int not null,
                    foreign key (customer_id) references customers(id),
                    primary key (id)) type=InnoDB default charset=utf8;

/* Add the values for customers table */
insert into customers (id  , name        , address)
           values    (null, 'Minh Hoang', 'Ha Noi');

insert into customers (id  , name        , address)
           values    (null, 'Ngoc Ha'   , 'Ha Noi');  

insert into customers (id  , name        , address)
           values    (null, 'Minh Lam'  , 'Ha Noi');  

insert into customers (id  , name        , address)
           values    (null, 'Truong Anh', 'Ha Noi');

insert into customers (id  , name      , address)
           values    (null, 'Khanh An', 'Hai Phong');

insert into customers (id  , name         , address)
           values    (null, 'Khanh Huyen', 'Thai Binh');  

insert into customers (id  , name       , address)
           values    (null, 'Mai Trang', 'Sai Gon');    
select * from customers            

/* Add the values for courses table */
insert into courses (id,   course_name     , startdate   , enddate)
           values  (null, 'English for IT', '2005-10-18', '2005-12-29')

insert into courses (id,   course_name     , startdate   , enddate)
           values  (null, 'English for IT', '2005-08-18', '2005-10-29')

insert into courses (id,   course_name, startdate   , enddate)
           values  (null, 'Let's go', '2005-10-18', '2005-12-29')

insert into courses (id,   course_name, startdate   , enddate)
           values  (null, 'Let's go', '2005-11-18', '2005-12-25')

insert into courses (id,   course_name             , startdate   , enddate)
           values  (null, 'International Business', '2005-11-18', '2005-12-25')

select * from courses

/* Add the values for book_orders table */
insert into book_orders (id  , items     , saledate   , customer_id)
           values      (null,'Let's go','2005-10-12', 3          );
insert into book_orders (id  , items     , saledate   , customer_id)
           values      (null,'Let's go','2005-10-12', 3          );
insert into book_orders (id  , items       , saledate   , customer_id)
           values      (null,'Let's go 2','2005-10-14', 4          );
insert into book_orders (id  , items         , saledate   , customer_id)
           values      (null,'Talk business','2005-10-16', 1          );
insert into book_orders (id  , items                 , saledate   , customer_id)
           values      (null,'International Express','2005-10-16', 4          );
insert into book_orders (id  , items                  , saledate   , customer_id)
           values      (null,'International Business','2005-10-16', 5          );

select * from book_orders
/* Add the values for course_customer table */
insert into course_customer (course_id, customer_id)  
           values          (1        , 2          )
insert into course_customer (course_id, customer_id)  
           values          (2        , 2          )
insert into course_customer (course_id, customer_id)  
           values          (3        , 1          )  
insert into course_customer (course_id, customer_id)  
           values          (4        , 3          )  

select * from course_customer;

I used Sqlyog 4.2 RC2 to execute the query. I used port 3307 for MySQL Server on my local host because I would like to use port 3306 for MySQL 4.0 which was not installed yet.

Other tools installed with MySQL 5.0.15: MySQL Query and MySQL Administrator (lastest version)

Best regards,

pcdinh

[Ritesh]

So you are connecting to your local server using “Direct Connection” method?

Are you trying to copy the database to a remote server?

[Ritesh]

BTW, what happens when you try to use “Copy database…” with your 4.0 server?

I just tried with 5.0.13 and it works great. Looks like an issue with 5.0.15.

[peterlaursen]

hmmm…

Quite a lot of syntax errors in that … missing ;'s

It would be easier it you used SQLyog for the export.

How did you manage to put this together ?

And what are the select statements good for ?

I can't reproduce the error.

My humble opinion is that you should try to deactivate(deinstall all that yahoo software that you have. I never had some software form Yahoo that did not give me problems!

I am pretty serious with that. It is a problem with your system I believe (nobody else reported it) and not a SQLyog problem.

[peterlaursen]

I have no problems with MySQL 5.0.15.

[Ritesh]

BTW, are you using any kind of firewall, multiple monitor management software etc.?

We had an issue earlier with Multimon found at Relatime Soft

[pcdinh]

Ritesh wrote on Oct 30 2005, 02:23 PM:

BTW, are you using any kind of firewall, multiple monitor management software etc.?

We had an issue earlier with Multimon found at Relatime Soft

[post=”7740″]<{POST_SNAPBACK}>[/post]

I have Yahoo IM with Voice, Apache 5.0.55, PHP 5.1RC3, MySQL 5.0.15, JDK 1.5.0_05, Eclipse 3.1.1 on my computer. No firewall or no virus protection software and monitor software.

All my above query is edited with Query tab on Sqlyog 4.2 Rc2 and I have it excuted without any error. After the tables were created, I tried using the wizard “Copy database…” by right-clicking on that database, clicking on the item “Copy database…” and Windows said it crashed and requested me to send a report.

I just formated and fdisked my hard disk yesterday. My hard disk has expanded some bad sectors. Do you think that it it the cause that leads to Sqlyog crashs. If it is the case, please ignore my bug report. 😆

Thank for your consideration.

Dinh

http://www.goldenkey.edu.vn/en

[peterlaursen]

Quote:

After the tables were created, I tried using the wizard “Copy database…” by right-clicking on that database, clicking on the item “Copy database…” and Windows said it crashed and requested me to send a report.

I think we understood that now! My point is that this is not a GENERAL problem with SQLyog. It could be a defect systems file on your system OR a rare issue with SQLyog that only has effect in very special situations (conflicts with drivers and certain running dll's etc. When we get to details not two systems are identical on this planet!). It is hard to tell. Maybe Ritesh has some idea?

Quote:

I just formated and fdisked my hard disk yesterday. My hard disk has expanded some bad sectors. Do you think that it it the cause that leads to Sqlyog crashs.

I don't believe it. I think it is software related. But you COULD try to uninstall SQLyog and reinstall. It is 99.9999999 % that it won't be written to the same sectors then. But if it is some read failure from the harddisk it could be MySQL or the database files that has somme error.

Did you run a chkdsk with the /r parameter (both checkboxes checked in the WinXP user interface for “control of disk”)). The very best is to boot on 'recovery console and run “checkdisk /r”. This is the one that checks for most, since no system files are locked when booting on recovery console.

A question: Can you open that database from SQLyog? and can you export (as a .sql-file for instance) or read the data from ODBC/JDBC .. etc. ???

[pcdinh]

peterlaursen wrote on Oct 31 2005, 04:00 AM:

A question: Can you open that database from SQLyog?  and can you export (as a .sql-file for instance) or read the data from ODBC/JDBC .. etc.  ???

I can open that database. After it crashed, I opened SQLyog again, connections to that database worked fine. All the select and delete statements worked fine. But I decided to delete all the tables in the database and use the query tab to create fresh tables. But the crash came again and again.

However, my hard disk has died. So I can not test it again until I buy a new one. But i will try to test it again on the PC in my company. Sorry for any convenience that may cause.

Dinh

[Ritesh]

Waiting for your comments.

[Author]

Posts