forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Space Missing In Sync File › Re: Space Missing In Sync File
It is better that you create a 'ticket' .. we can then better coordinate!
http://www.webyog.com/support/ttx.cgi
But I can test with the same versions! Will do!
Do you use tunnelling to the remote host ?
Write-up:
Issue confirmed:
4.0.26 remote and 4.1.19 local, no tunnelling!
/* Alter table in Second database */
alter table `jazcyk_test`.`categorias`
drop column `id`,
drop key `PRIMARY`,
/* Alter table in Second database */
alter table `jazcyk_test`.`dolar`
change `id` `id` tinyint(4) NOT NULL DEFAULT '0' first,
change `dhora` `dhora` timestamp NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP after `dolar`,
drop key `PRIMARY`,
/* Alter table in First database */
alter table `ferret`.`categorias`
add column `id` int(10) unsigned NOT NULL auto_increment after `descr`,
add PRIMARY KEY (`id`),
/* Alter table in First database */
alter table `ferret`.`dolar`
change `id` `id` tinyint(4) unsigned NOT NULL auto_increment first,
change `dhora` `dhora` timestamp(14) NULL after `dolar`,
add PRIMARY KEY (`id`),
@ritesh+@sarat: data (ferrets-remote.sql) available at surftown.dk (MySQL 4.0.26)