MYSqL helpp

isuru_it

Member
Sep 2, 2011
700
97
0
Gone From Elakiri
මටපොඩි උදවුවක් ඕන මගේ සර්වර් එකේ තියෙයන්නෙ 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
 

Attachments

  • mfhs-1.3.zip
    12.5 KB · Views: 163

jds2012

Well-known member
  • Mar 27, 2011
    7,945
    1,249
    113
    Everywhere...
    73581196.jpg
     

    Ayeshlive

    Well-known member
  • Jul 1, 2011
    10,570
    943
    113
    *̶͑̾̾​̅ͫ͏̙̤g͛͆̾ͫ̑͆&
    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 ;) )
     

    HallowMan

    Well-known member
  • Jan 10, 2010
    5,788
    1,005
    113
    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.