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(a)pobox.com>
To: "Wikimedia developers" <wikitech-l(a)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(a)wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/wikitech-l