Structure Synchronization Tool – V4.07

[peterlaursen]

I'll do some research on that.

In the meantime please answer:

1) MySQL server versions ?

2) SQLyog version ?

3) Conection types (direct/HTTP/SSH) ?

[peterlaursen]

I can't reproduce it. This is an example from struct-sync across MySQL-versions 4.0 and 5.0 using HTTP-tunneling with 4.0

Code:

/* Drop in Second database */
drop table `jazcyk_test`.`Important information`;

/* Drop in Second database */
drop table `jazcyk_test`.`mp3_filer_copy`;

/* Alter table in Second database */
alter table `jazcyk_test`.`roles`,
change `RoleID` `RoleID` int(11) NULL  auto_increment,
change `CostumeDescription` `CostumeDescription` varchar(50) NULL ;

/* Create table in Second database */
create table `jazcyk_test`.`whertogo` (
`Id` int(10) unsigned NULL   ,
`goname` varchar(60) NULL   ,
`towncity` varchar(50) NULL   ,
`type` varchar(50) NULL   ,
PRIMARY KEY (`Id`) ,
KEY `citieswhertogo` (`towncity`) ,
KEY `townix` (`towncity`)
)Type=InnoDB;

[jdrago]

Hi.

MySQL Version = Ver 14.7 Distrib 4.1.8, for pc-linux (i686)

SQLyog Version = 4.07

Using direct connections.

Table types are all MyISAM.

Something else to note – we are syncing up over 200 tables' structure from one DB to another.

[peterlaursen]

We need more info to get further!

But honestly I don't know where to start.

Probably some sample data are required. If you don't want to attach them here, I am sure that you can mail them confidently to Ritesh in the morning.

Could it be a user privilege problem? If you don't already try ROOT (or the user with most priviliges available) on both servers!

Quote:

This feature was the entire reason why we bought SQLyog Enterprise. When can we expect a fix for this feature?

My humble opinion: don't be so sure that SQLyog needs a fix here. It could be your configuration that needs a fix! <_<

[peterlaursen]

Quote:

MySQL Version = Ver 14.7 Distrib 4.1.8, for pc-linux (i686)

SQLyog Version = 4.07

Using direct connections.

What is “MySQL Version = Ver 14.7 …” ?

I know what MySQL 4.1.8 is. That MySQL was “built-in” the Linux-distribution I guess ??

I understand that you purchased SQLyog recently, so I can't know how much you have been using it for other purposes. But are there any other problems experienced with the porgram ? If you click on a table in Object Browser and select the OBJECTS-tab will the table definition then display correctly ?

Are you trying to sync all 200 tables “in one round”. If yes, will it solve problems to have a smaller number of tables ?

[peterlaursen]

could be a crazy idea ….

but what happens if you copy to a file and not to clipboard ?

[jdrago]

I'm sorry about jumping to conclusions about assuming the software is buggy.

When I select “Sync (File)” the same thing happens – only the first table has actual alter statements.

[jdrago]

I will create a simple test and see if I can duplicate it on a smaller scale – BRB

[peterlaursen]

just for completenes.

Here you have a case with two tables and several changes within each

Code:

/* Alter table in Second database */
alter table `test4`.`roles`,
change `RoleID` `RoleID` int(11) NULL  auto_increment,
change `RoleDescription` `RoleDescription` varchar(50) NULL  ,
change `CostumeDescription` `CostumeDescription` varchar(50) NULL  ,
change `CompanyID` `CompanyID` int(11) NULL  ,
change `ProjectID` `ProjectID` int(11) NULL  ,
change `SectionID` `SectionID` int(11) NULL;

/* Alter table in Second database */
alter table `test4`.`whertogo`,
change `Id` `Id` int(10) unsigned NULL  ,
change `goname` `goname` varchar(60) NULL  ,
change `towncity` `towncity` varchar(50) NULL  ,
change `type` `type` varchar(50) NULL;

[Ritesh]

@jdrago

Just attach or mail me the sturcture dump of both the databases. To test structure sync, I dont require your data.

[jdrago]

Unfortunately I cannot share the structure of the database.

However, I did create a test database with over 200 tables, and have had no problems making the Structure Sync tool work on that database.

I've tried creating new tables, deleting them, adding/changing/removing columns — everything, and I can't duplicate the problem I was having on the actual database. Even the database I was having problems with works now. 😮

If I can figure out why it wasn't working before, I will post here right away.

Thanks for all your help!

[GreenAlien]

jdrago wrote on Aug 3 2005, 03:49 PM:

Unfortunately I cannot share the structure of the database.

However, I did create a test database with over 200 tables, and have had no problems making the Structure Sync tool work on that database.

I've tried creating new tables, deleting them, adding/changing/removing columns — everything, and I can't duplicate the problem I was having on the actual database.  Even the database I was having problems with works now. 😮

If I can figure out why it wasn't working before, I will post here right away.

Thanks for all your help!

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

Well I've just experienced this issue too, and my database (early stages) only has four tables and a handful of fields in each.

I'm using v4.1 Enterprise (Trial).

I started a thread before I spotted this one, here it is:

http://www.webyog.com/forums/index.php?showtopic=1627

Rgds, Ant

ps: @Ritesh I'm happy to email you my database (before and after) so long as you dont share it with anyone else. Let me know if you want it.

[Author]

Posts