Aryeh Gregor wrote:
On Mon, Mar 8, 2010 at 10:20 AM, Platonides wrote:
Maybe some file-transfering magic can be done to add the index in the other dbs by copying it from rosemary?
No, file-copying doesn't work with InnoDB. You can only copy the full contents of all databases on the server, not even a single database at a time -- let alone a single table. Even with MyISAM, it would only work if you carefully synchronized replication between the tables, which would be more trouble than it's worth.
You may need per-table tablespaces, but i think it worked.