DataBase Syncronization Errors

[mikemercadante]

I have two databases which I'm trying to syncronize on two different computers. In my first approach I tried generating an SQL file and copying that over to the target machine. It complained about errors in the syntax, I also tried the syncronize command with similar results. The SQL was generated by SQLYog. Attached is a sample of the error logs which I received.

a small sample of the SQL

/*

SQLyog v4.0 BETA 4

Host – localhost : Database – centersense

**************************************************************

Server version 4.1.5-gamma-nt-log

*/

create database if not exists `centersense`;

use `centersense`;

/*

Table structure for crm_actual_values_summary

*/

drop table if exists `crm_actual_values_summary`;

CREATE TABLE `crm_actual_values_summary` (

`intervalId` int(11) NOT NULL auto_increment,

`categId` int(11) NOT NULL default '0',

`totalValue` decimal(6,2) NOT NULL default '0.00',

`minId` int(11) NOT NULL default '0',

`minValue` decimal(6,2) NOT NULL default '0.00',

`maxId` int(11) NOT NULL default '0',

`maxValue` decimal(6,2) NOT NULL default '0.00',

`avgId` int(11) NOT NULL default '0',

`avgValue` decimal(6,2) NOT NULL default '0.00',

`lastSetId` int(11) NOT NULL default '0',

`userId` int(11) NOT NULL default '0',

`toUserId` int(11) NOT NULL default '0',

`actual_date_time` datetime NOT NULL default '0000-00-00 00:00:00',

`created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

`lastModif` datetime NOT NULL default '0000-00-00 00:00:00',

PRIMARY KEY (`intervalId`),

KEY `categId` (`categId`),

KEY `userId` (`userId`),

KEY `touserId` (`toUserId`),

KEY `actual_date_time` (`actual_date_time`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Summary table for acutal values trend processing';

[Ritesh]

Are you sure you are using SQLyog's Database Sync Tool (SJA)? SJA does not generate SQL script. Looking at the sample it seems you are using SQLyog's Export As Batch Script… option.

Assuming that you are using Export As Batch Script… option, the error can occur if the target server is running an old version of MySQL. Can you tell me the MySQL version running in your target server?

[Author]

Posts