Translations:Manual:MWDumper/59/en

Don't forget to recreate the indexes afterwards. Note that it will take a long time to recreate all the removed data.
 * 1) Remove indexes:
 * 2) * You can use the procedure from http://www.javaquery.com/2014/03/mysql-queries-to-show-all-database.html to remove indexes. Execute multiple times and check with "show index from page", etc. if the indexes are removed. See also the drop index statements below.
 * 3) Remove primary keys: In MySQL execute:
 * 4) * alter table revision drop primary key;
 * 5) * alter table text drop primary key;
 * 6) * alter table page drop primary key;
 * 7) Remove auto increment fields: In MySQL execute:
 * 8) * alter table revision change rev_id rev_id int(10) unsigned not null;
 * 9) * alter table text change old_id old_id int(10) unsigned not null;
 * 10) * alter table page change page_id page_id int(10) unsigned not null;