Meek Consulting

Creating indexes in mysql on large tables can take a long time. Because it makes a temporary copy of the entire DB file first then creates the indexes. So be sure you have enough free space for the complete DB ( MYI and MYD for MYISAM databases ) plus space for the new version. If [...]

If you have a mysql database table with indexes and you want to get the alter table  commands to “create” the same indexes on another db You can run this sql — replacing the tablename with your table. Just add alter table TABLENAME Then paste the add index commands generated by the SQL below SELECT    [...]