Alıntı:




BigDump: Staggered MySQL Dump Importer v0.26b

Processing file: db11628[1].sql



Starting from line: 1



Error at the line 38: ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=1 ;



Query: CREATE TABLE IF NOT EXISTS `jos_banner` (

`bid` int(11) NOT NULL auto_increment,

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

`type` varchar(10) collate utf8_turkish_ci NOT NULL default 'banner',

`name` varchar(50) collate utf8_turkish_ci NOT NULL default '',

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

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

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

`imageurl` varchar(100) collate utf8_turkish_ci NOT NULL default '',

`clickurl` varchar(200) collate utf8_turkish_ci NOT NULL default '',

`date` datetime default NULL,

`showBanner` tinyint(1) NOT NULL default '0',

`checked_out` tinyint(1) NOT NULL default '0',

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

`editor` varchar(50) collate utf8_turkish_ci default NULL,

`custombannercode` text collate utf8_turkish_ci,

PRIMARY KEY (`bid`),

KEY `viewbanner` (`showBanner`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=1 ;





MySQL: 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 'collate utf8_turkish_ci NOT NULL default 'banner', `name` var



Stopped on error





Joomla yedek sql ı boş dbye import etmek istiyorum

phpmyadminden yüklerken bu şekilde hata vermişti bi de bigdumpla deneyim dedim yine aynı hatayı verdi. Db de nasıl bir değişiklik yapmam gerekiyor?