I created a new index on one field of my database. I have another copy of the same database on another server, but the server is too slow to create the same index. Can i copy it from the other MySQL server?
The way you would copy the index is using the create index command. You could try using federated tables or just query the remote database, if the data result sets aren't too large.