Talk:Data dumps

From Meta, a Wikimedia project coordination wiki
This is an archived version of this page, as edited by 68.127.155.43 (talk) at 05:00, 24 October 2005 (→‎1.5 table format). It may differ significantly from the current version.

Latest comment: 18 years ago by Tgr in topic 1.4 old problems

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

-- You can get the db schema from the Mediawiki 1.5 install. You don't need to install anything, just create a new database and import the tables.sql file under the maintenance directory. There might be an easier way, but that's my solution.

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