사용자:풀빵/dump

Importing a dump

Software Versions

• mysql-5.0.45-win32.zip
• xml2sql-0.5-win32.zip - goes well with.xml.bz2 or .xml.7z.
• bzip2-100-x86-win32.exe

SQLs

Tinyblob-type fields should not have a default value.

CREATE TABLE page (
 page_id int(8) unsigned NOT NULL auto_increment,
 page_namespace int NOT NULL,
 page_title varchar(255) binary NOT NULL,
 page_restrictions tinyblob NOT NULL,
 page_counter bigint(20) unsigned NOT NULL default '0',
 page_is_redirect tinyint(1) unsigned NOT NULL default '0',
 page_is_new tinyint(1) unsigned NOT NULL default '0',
 page_random real unsigned NOT NULL,
 page_touched char(14) binary NOT NULL default '',
 page_latest int(8) unsigned NOT NULL,
 page_len int(8) unsigned NOT NULL,
 PRIMARY KEY page_id (page_id)
) TYPE=MyISAM DEFAULT CHARACTER SET=utf8;

CREATE TABLE text (
 old_id int(8) unsigned NOT NULL auto_increment,
 old_text mediumtext NOT NULL default '',
 old_flags tinyblob NOT NULL,
 PRIMARY KEY old_id (old_id)
) TYPE=MyISAM DEFAULT CHARACTER SET=utf8;

CREATE TABLE revision (
 rev_id int(8) unsigned NOT NULL auto_increment,
 rev_page int(8) unsigned NOT NULL,
 rev_text_id int(8) unsigned NOT NULL,
 rev_comment tinyblob NOT NULL,
 rev_user int(5) unsigned NOT NULL default '0',
 rev_user_text varchar(255) binary NOT NULL default '',
 rev_timestamp char(14) binary NOT NULL default '',
 rev_minor_edit tinyint(1) unsigned NOT NULL default '0',
 rev_deleted tinyint(1) unsigned NOT NULL default '0',
 PRIMARY KEY rev_page_id (rev_page, rev_id),
 KEY rev_page (rev_page),
 KEY rev_text_id (rev_text_id)
) TYPE=MyISAM;

CREATE TABLE articles (
 id int(8) unsigned NOT NULL,
 title varchar(255) NOT NULL,
 text  mediumtext NOT NULL,
 redirect tinyint(1) unsigned NOT NULL,
 last_update char(14) binary NOT NULL,
 PRIMARY KEY id (id),
 FULLTEXT ft_title_text (title,text)
) TYPE=MyISAM DEFAULT CHARACTER SET=utf8;

mysqlimport

mysqlimport -u root -p --default-character-set=utf8 kowiki [filepath]

directories

c:\u i:\kowiki-dump

Internal ID

The internal ID is 15984.