Error Sending Me Mad ! Please Any Help

[rawilly]

hi everyone

i have only just come across sqlyog and its looks a great tool but when i started using it i backed up my database then when i came to load it back in i keep getting error 1064 the table set up is as follows :-

/*Table structure for table `npc` */

DROP TABLE IF EXISTS `npc`;

CREATE TABLE `npc` (

`id` decimal(11,0) NOT NULL default '0',

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

`name` varchar(200) default NULL,

`serverSideName` int(1) default '0',

`title` varchar(45) default '',

`serverSideTitle` int(1) default '0',

`class` varchar(200) default NULL,

`collision_radius` decimal(5,2) default NULL,

`collision_height` decimal(5,2) default NULL,

`level` decimal(2,0) default NULL,

`sex` varchar(6) default NULL,

`type` varchar(20) default NULL,

`attackrange` int(11) default NULL,

`hp` decimal(8,0) default NULL,

`mp` decimal(5,0) default NULL,

`str` decimal(7,0) default NULL,

`con` decimal(7,0) default NULL,

`dex` decimal(7,0) default NULL,

`int` decimal(7,0) default NULL,

`wit` decimal(7,0) default NULL,

`men` decimal(7,0) default NULL,

`exp` decimal(9,0) default NULL,

`sp` decimal(8,0) default NULL,

`patk` decimal(5,0) default NULL,

`pdef` decimal(5,0) default NULL,

`matk` decimal(5,0) default NULL,

`mdef` decimal(5,0) default NULL,

`atkspd` decimal(3,0) default NULL,

`aggro` decimal(6,0) default NULL,

`matkspd` decimal(4,0) default NULL,

`rhand` decimal(4,0) default NULL,

`lhand` decimal(4,0) default NULL,

`armor` decimal(1,0) default NULL,

`walkspd` decimal(3,0) default NULL,

`runspd` decimal(3,0) default NULL,

`faction_id` varchar(40) default NULL,

`faction_range` decimal(4,0) default NULL,

`isUndead` int(11) default '0',

`absorb_level` decimal(2,0) default '0',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `npc` */

and query starts at line below :-

insert into `npc`(`id`,`idTemplate`,`name`,`serverSideName

i didnt copy paste full data as its very long ive studied the data till im crosseyed and cant find no errors in it just wondered if anyone knows whats causing it because rest of the data loads in ok till this point hope some one can shed light on it as i cant carry anymore work out till i can safely back up database

[peterlaursen]

What are the MySQL server versions involved? Form which version do you exxprot and where do you import.

This ” …ENGINE=MyISAM DEFAULT CHARSET=latin1″ is generated by MySQL 4.1 and higher but is not understood by MySQL 4.0 and lower. That could be the issue! If that is then there are two options:

1) simply remove the above phrase in an editor

2) use our latest beta. It generates a 'backwards compatible backup'.

If that is not the issue, we will need more details. A small test case, preferably. Detailed information of program versions (SQLyog, MySQL servers)

[rawilly]

peterlaursen wrote on Dec 7 2006, 04:43 AM:

What are the MySQL server versions involved? Form which version do you exxprot and where do you import.

This ” …ENGINE=MyISAM DEFAULT CHARSET=latin1″ is generated by MySQL 4.1 and higher but is not understood by MySQL 4.0 and lower. That could be the issue! If that is then there are two options:

1) simply remove the above phrase in an editor

2) use our latest beta. It generates a 'backwards compatible backup'.

If that is not the issue, we will need more details. A small test case, preferably. Detailed information of program versions (SQLyog, MySQL servers)

hi thx for answer my sql is 4.1 just checked i will now try the 2 options and will post results

[rawilly]

rawilly wrote on Dec 7 2006, 10:45 AM:

hi thx for answer my sql is 4.1 just checked i will now try the 2 options and will post results

hi ive just downloaded beta 521 community edition and tried it again but same error also then i tried removing the line you stated but alas same error so at moment i am using my sql 4.1 and sqlyog 5.21 i downloaded the beta 521 from the binaries edition or should it be the one in source community edition many thanks for your help so far

[peterlaursen]

pooohhhh …. That was a long sentence without a aingle punctuation 😀

Please provide a small test case: a dump of a single table with a few rows of data only. We need getting oor hands on some data. TRey are better than words!

And pleasse confirm: both sorce and target servers are 4.1.x ??

[rawilly]

😀 😀 😀 found error it was in another file i had put an extra , many thanks for taking interest its a great tool 😀 😀 😀

[Author]

Posts