[Mediawiki-l] Problems using mwdumper.jar

[Ulisse Savi]

Thank you very much.

query SQL: 
TRUNCATE `page` ;

TRUNCATE `revision` ;

TRUNCATE `text` ;

Is it sufficient ? Or i have to delete the entire 3 tables ?
I need to launch other queries ?
------------
I will restart the procedure, after the deletion of the 3 tables you meant.
At the moment this is the structure in the database :
:
archive
categorylinks
externallinks
hitcounter 
image
imagelinks
interwiki
ipblocks 
job
logging
math
objectcache
oldimage
page   (DELETED)
pagelinks
querycache
recentchanges
revision   (DELETED)
searchindex
site_stats
templatelinks
text   (DELETED)
trackbacks
transcache
user
user_groups
user_newtalk
validate
watchlist




----- Original Message ----- 
From: "Brion Vibber" <brion at pobox.com>
To: "Wikimedia developers" <wikitech-l at wikimedia.org>
Sent: Monday, July 03, 2006 7:27 AM
Subject: Re: [Wikitech-l] Problems using mwdumper.jar

Ulisse Savi wrote:
> 1,000 pages (19.529/sec), 1,000 revs (19.529/sec)
> ERROR 1062 (23000) at line 46: Duplicate entry '1' for key 1

You need to import into an empty database, or it will fail like this.

Before you start, try clearing the tables that mwdumper works in:

DELETE FROM page;
DELETE FROM revision;
DELETE FROM text;

-- brion vibber (brion @ pobox.com)


> _______________________________________________
> Wikitech-l mailing list
> Wikitech-l at wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/wikitech-l