Thread:Project:Support desk/Duplicated key in MySQL when re-introducing key after running mwdumper

Hi all,

I have imported the latest XML dump with mwdumper.jar. After a few times of uncompleted import, i follow the suggestions of the mailing-list that I removed all the key and indexes for the page, text and revision table. Well, it runs like a rocket after that.

However, i found a problem when i wish to re-introduce those index to the database after the dump finished. For primary key, there is no issues. But i failed to restore some unique key, such as:

CREATE INDEX name_title ON page (page_title) USING BTREE;

It will return duplicated key 'page_title" error.

If i choose to make the key with NON UNIQUE option, it will success but i cannot further add index for the 'page_title' column anymore. As the default setup of the page table contains two indexes for 'page_title', I just wanna know how to resemble the original DB setup. The same thing happens to the revision table.

Can anyone give me some hints in how to recreate those keys? Thank you.