MYSqL helpp

[isuru_it]

මටපොඩි උදවුවක් ඕන මගේ සර්වර් එකේ තියෙයන්නෙ Mysql 5.5.10 ඒත් මේ Sql file එක upload කරන්න ගියයාම php admin එකෙනන්
මේ මැසේජ් එක එනවා.. මම SQL File eka Attach කරල තියයන්නෙ

MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 16

 

[isuru_it]

උදවු කරපල්ලා

 

[isuru_it]

bbummmp

 

[shiwankaswe]

machan ube local ake DB type aka INODB aththe
uba aka wenas karala dapan

uba server akata danna yanakota phpmyadmin akata wada sqlyog use karapan, akenma backup aka local ake aran execute karapan akenma server ake(script aka execute karapan)
http://www.webyog.com/en/

 

[isuru_it]

machan ube local ake DB type aka INODB aththe
uba aka wenas karala dapan

uba server akata danna yanakota phpmyadmin akata wada sqlyog use karapan, akenma backup aka local ake aran execute karapan akenma server ake(script aka execute karapan)
http://www.webyog.com/en/

mama use karanne Localhost newei.. server ekaka..
MYISAM eka wenas kalata hari yanne naa

 

[jds2012]

 

[Ayeshlive]

Machan umba use karana text editor ekakin (Notepad, emacs, etc) file eka edit karala
'TYPE=MyISAM' kiyana eka 'ENGINE=MyISAM' widihata replace karapan (match exact phase, case sensitive).
TYPE use kale issara - Engine thama aluth definition eka.
Hariyatama sure na machan. (mama SQL file eka baluweth na )

 

[amila325]

Change TYPE to ENGINE it's not table type but the engine type

 

[sahanlak]

Replace TYPE=MyISAM; with ENGINE=MyISAM;

 

[sahanlak]

too late

 

[HallowMan]

Machan umba use karana text editor ekakin (Notepad, emacs, etc) file eka edit karala
'TYPE=MyISAM' kiyana eka 'ENGINE=MyISAM' widihata replace karapan (match exact phase, case sensitive).
TYPE use kale issara - Engine thama aluth definition eka.
Hariyatama sure na machan. (mama SQL file eka baluweth na )

Yes try doing this. I think you are are running MySQL 5.1 which uses a different syntax.