PDA

Zobacz pełną wersję : Problez z importem bazy danych pomocy!



elvis_stig
02-08-2008, 10:26
Witam
Mam problem z importem bazy danych. Podczas próby importu pliku przez phpadmina wyskakuje komunikat Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string_mb.lib.php on line 47

Pomyślałem ,że może jest to związane z serwerem. Na drugim serwerze wyskakuje komunikat


zapytanie SQL:
-- --------------------------------------------------------
--
-- Struktura tabeli dla `jos_banner`
--
CREATE TABLE IF NOT EXISTS `jos_banner` ( `bid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`cid` int( 11 ) NOT NULL default '0',
`type` varchar( 10 ) NOT NULL default 'banner',
`name` varchar( 50 ) 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 ) NOT NULL default '',
`clickurl` varchar( 200 ) 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 ) default NULL ,
`custombannercode` text,
PRIMARY KEY ( `bid` ) ,
KEY `viewbanner` ( `showBanner` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8-- --------------------------------------------------------
--
-- Struktura tabeli dla `jos_bannerclient`
--
CREATE TABLE IF NOT EXISTS `jos_bannerclient` ( `cid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 60 ) NOT NULL default '',
`contact` varchar( 60 ) NOT NULL default '',
`email` varchar( 60 ) NOT NULL default '',
`extrainfo` text NOT NULL ,
`checked_out` tinyint( 1 ) NOT NULL default '0',
`checked_out_time` time default NULL ,
`editor` varchar( 50 ) default NULL ,
PRIMARY KEY ( `cid` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8-- --------------------------------------------------------
--
-- Struktura tabeli dla `jos_bannerfinish`
--
CREATE TABLE IF NOT EXISTS `jos_bannerfinish` ( `bid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`cid` int( 11 ) NOT NULL default '0',
`type` varchar( 10 ) NOT NULL default '',
`name` varchar( 50 ) NOT NULL default '',
`impressions` int( 11 ) NOT NULL default '0',
`clicks` int( 11 ) NOT NULL default '0',
`imageurl` varchar( 50 ) NOT NULL default '',
`datestart` datetime default NULL ,
`dateend` datetime default NULL ,
PRIMARY KEY ( `bid` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8-- --------------------------------------------------------
--
-- Struktura tabeli dla `jos_categories`
--
CREATE TABLE IF NOT EXISTS `jos_categories` ( `id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`parent_id` int( 11 ) NOT NULL default '0',
`title` varchar( 50 ) NOT NULL default '',
`name` varchar( 255 ) NOT NULL default '',
`image` varchar( 100 ) NOT NULL default '',
`section` varchar( 50 ) NOT NULL default '',
`image_position` varchar( 10 ) NOT NULL default '',
`description` text NOT NULL ,
`published` tinyint( 1 ) NOT NULL default '0',
`checked_out` int( 11 ) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar( 50 ) default NULL ,
`ordering` int( 11 ) NOT NULL default '0',
`access` tinyint( 3 ) unsigned NOT NULL default '0',
`count` int( 11 ) NOT NULL default '0',
`params` text NOT NULL ,
PRIMARY KEY ( `id` ) ,
KEY `cat_idx` ( `section` , `published` , `access` ) ,
KEY `idx_section` ( `section` ) ,
KEY `idx_access` ( `access` ) ,
KEY `idx_checkout` ( `checked_out` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8-- --------------------------------------------------------
--
-- Struktura tabeli dla `jos_components`
--
CREATE TABLE IF NOT EXISTS `jos_components` ( `id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 50 ) NOT NULL default '',
`link` varchar( 255 ) NOT NULL default '',
`menuid` int( 11 ) unsigned NOT NULL default '0',
`parent` int( 11 ) unsigned NOT NULL default '0',
`admin_menu_link` varchar( 255 ) NOT NULL default '',
`admin_menu_alt` varchar( 255 ) NOT NULL default '',
`option` varchar( 50 ) NOT NULL default '',
`ordering` int( 11 ) NOT NULL default '0',
`admin_menu_img` varchar( 255 ) NOT NULL default '',
`iscore` tinyint( 4 ) NOT NULL default '0',
`params` text NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8-- --------------------------------------------------------
--
-- Struktura tabeli dla `jos_contact_details`
--
CREATE TABLE IF NOT EXISTS `jos_contact_details` ( `id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 100 ) NOT NULL default '',
`con_position` varchar( 50 ) default NULL ,
`address` text,
`suburb` varchar( 50 ) default NULL ,
`state` varchar( 20 ) default NULL ,
`country` varchar( 50 ) default NULL ,
`postcode` varchar( 10 ) default NULL ,
`telephone` varchar( 25 ) default NULL ,
`fax` varchar( 25 ) default NULL ,
`misc` mediumtext,
`image` varchar( 100 ) default NULL ,
`imagepos` varchar( 20 ) default NULL ,
`email_to` varchar( 100 ) default NULL ,
`default_con` tinyint( 1 ) unsigned NOT NULL default '0',
`published` tinyint( 1 ) unsigned NOT NULL default '0',
`checked_out` int( 11 ) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int( 11 ) NOT NULL default '0',
`params` text NOT NULL ,
`user_id` int( 11 ) NOT NULL default '0',
`catid` int( 11 ) NOT NULL default '0',
`access` tinyint( 3 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8-- --------------------------------------------------------
--
-- Struktura tabeli dla `jos_content`
--
CREATE TABLE IF NOT EXISTS `jos_content` ( `id` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
`title` varchar( 100 ) NOT NULL default '',
`title_alias` varchar( 100 ) NOT NULL default '',
`introtext` mediumtext NOT NULL ,
`fulltext` mediumtext NOT NULL ,
`state` tinyint( 3 ) NOT NULL default '0',
`sectionid` int( 11 ) unsigned NOT NULL default '0',
`mask` int( 11 ) unsigned NOT NULL default '0',
`catid` int( 11 ) unsigned NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int( 11 ) unsigned NOT NULL default '0',
`created_by_alias` varchar( 100 ) NOT NULL default '',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int( 11 ) unsigned NOT NULL default '0',
`checked_out` int( 11 ) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`images` text NOT NULL ,
`urls` text NOT NULL ,
`attribs` text NOT NULL ,
`version` int( 11 ) unsigned NOT NULL default '1',
`parentid` int( 11 ) unsigned NOT NULL default '0',
`ordering` int( 11 ) NOT NULL default '0',
`metakey` text NOT NULL ,
`metadesc` text NOT NULL ,
`access` int( 11 ) unsigned NOT NULL default '0',
`hits` int( 11 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `id` ) ,
KEY `idx_section` ( `sectionid` ) ,
KEY `idx_access` ( `access` ) ,
KEY `idx_checkout` ( `checked_out` ) ,
KEY `idx_state` ( `state` ) ,
KEY `idx_catid` ( `catid` ) ,
KEY `idx_mask` ( `mask` )
) ENGINE = MYISAM MYISAM DEFAULT CHARSET = utf8-- --------------------------------------------------------
--
-- Struktura tabeli dla `jos_content_frontpage`
--
CREATE TABLE IF NOT EXISTS `jos_content_frontpage` ( `content_id` int( 11 ) NOT NULL default '0',
`ordering` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `content_id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin2;


MySQL zwrócił komunikat: http://sql.boo.pl/themes/original_small/img/b_help.png (http://dev.mysql.com/doc/refman/4.1/en/error-messages-server.html)
#1064 - Something is wrong in your syntax obok 'CREATE TABLE IF NOT EXISTS `jos_bannerclient` (
`cid` int(11)' w linii 23


//

Nie mam pojęcia, gdzie jest błąd. Proszę o pomoc. Z góry dziękuję.

vego007
02-08-2008, 10:59
Próbujesz poprzez zapytanie SQL? Jeśli tak to użyj opcji import

zwiastun
02-08-2008, 11:43
1. Za długi czas wykonania - podziel plik na części
2. Powodem może być te fragmenciki: utf8-- ---------------------------
Pooddzielaj to enterami
3. Skąd jest ten zrzut - masz niejednolite kodowanie (por. DEFAULT CHARSET = utf8 i w tabeli jos_content_frontpage - latin2