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