Talk:Data dumps: Difference between revisions

From Meta, a Wikimedia project coordination wiki
Latest comment: 18 years ago by Tgr in topic 1.4 old problems
Content deleted Content added
1.5 table format
1.4 old problems
Line 5: Line 5:


Are the 1.5 tables (page, revision etc.) defined somwhere? The SQL output of mwdumper doesnt contain a CREATE TABLE command like the old SQL dumps did. --[[User:Tgr|Tgr]] 15:22, 16 October 2005 (UTC)
Are the 1.5 tables (page, revision etc.) defined somwhere? The SQL output of mwdumper doesnt contain a CREATE TABLE command like the old SQL dumps did. --[[User:Tgr|Tgr]] 15:22, 16 October 2005 (UTC)

== 1.4 old problems ==

When trying to read the ''old'' table of the 1.4 database format into MySQL, i got the following error:
ERROR 1062 (23000) at line 28: Duplicate entry '1' for key 1
(I tried with the [http://download.wikimedia.org/wikipedia/hu/20051003_pages_full.xml.bz2 20051003] and [http://download.wikimedia.org/wikipedia/hu/20051012_pages_current.xml.bz2 20051012] dumps of HuWiki, using mwdumper to convert them to SQL, and the CREATE TABLE commands from the [http://download.wikimedia.org/wikipedia/hu/20050623_old_table.sql.gz old dump] to create the ''old'' table; I got the same error message both times.)

Any ideas? --[[User:Tgr|Tgr]] 15:32, 16 October 2005 (UTC)

Revision as of 15:32, 16 October 2005

Status

At the moment it looks like the en dump is stalled again. I am d/ling 200509024 full, in the hope that it's complete, but have no way of telling. The new sysem looks good, just a bit of human status info while it beds in would be useful. Rich Farmbrough 19:42, 6 October 2005 (UTC)Reply

1.5 table format

Are the 1.5 tables (page, revision etc.) defined somwhere? The SQL output of mwdumper doesnt contain a CREATE TABLE command like the old SQL dumps did. --Tgr 15:22, 16 October 2005 (UTC)Reply

1.4 old problems

When trying to read the old table of the 1.4 database format into MySQL, i got the following error:

ERROR 1062 (23000) at line 28: Duplicate entry '1' for key 1

(I tried with the 20051003 and 20051012 dumps of HuWiki, using mwdumper to convert them to SQL, and the CREATE TABLE commands from the old dump to create the old table; I got the same error message both times.)

Any ideas? --Tgr 15:32, 16 October 2005 (UTC)Reply