New Mysql 5.0 – Error 1044 Then Error 1064

[peterlaursen]

Confirmed!

Exactly as you desxribe it with MySQL 5.0.18 and SQLyog 5.02

With MySQL 5.0.18 and SQLyog 4.1 it exports perfectly as

Code:

/*
SQLyog Enterprise – MySQL GUI v4.1
Host – 5.0.18-nt-max : Database – report-data
*****************************************
Server version : 5.0.18-nt-max
*/
create database if not exists `report-data`;
USE `report-data`;

/*Table structure for table `t1` */
drop table if exists `t1`;
CREATE TABLE `t1` (
 `id` bigint(20) NOT NULL auto_increment,
 `t` varchar(50) default NULL,
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `t1` */
insert into `t1` values (1,'a'),(2,'b'),(3,'c');

hmmm .. they start at work in Bangalore in 2-3 hours. They must be able to tell! I don't know if it could be because it uses the 'Information_Schema' table.

[peterlaursen]

BTW: the 'copy database to other host' works perfect here with SQLyog 5.02 and MySQL 5.0.18.

You may use that instead. Just right-click a database ….

[Ritesh]

@cable: Can you mail me your email address?

[peterlaursen]

Also the data sync runs (sync'ing DB's 'report-data' and 'test')

Code:

Copyright (c) Webyog Softworks Pvt. Ltd.. All Rights Reserved.

Sync started at Tue Jan 24 10:08:13 2006

Table                      SrcRows  TgtRows  Inserted  Updated  Deleted
=========================  =======  =======  ========  =======  =======
`t1`                             8        6         4        1  No change  
`t1`                            10        8         2        0  No change  

Total time taken – 1 sec(s)

So you have two options (until the issue is fixed):

1) Use 'copy database to other host' for the first copy

2) Or simply run the first sync against an empty database

[peterlaursen]

BTW: the Backup 'powertool' also works OK.

[cable]

peterlaursen wrote on Jan 24 2006, 06:47 AM:

BTW: the Backup 'powertool' also works OK.

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

Thanks for all of your replies! I did end up using that work around last night – I had an old export of my 4.1 database, so imported that locally and then ran the power tools data and structure sync and it worked great.

Again thanks much – it is refreshing to get accurate and friendly support!

-Cable

P.S. Is there any way to be notified when the bug is fixed though?

[peterlaursen]

I think that both Ritesh and I shal try to remember that 'wired' (= weird ?? – sorry 'bout my English spelling …. ) person 😆

SQLyog 5.1 beta 1 should be out by the end of this week (friday or saturday) if not some unforseen issue occurs. This looks like an issue that should be fixed with next release. Check in by the end of the week, if we should forget you!

[Author]

Posts