I need 3 large MySQL tables moved to another server. The table sizes are 20MB, 25MB & 360MB.
60% of the 360MB table is attributed to Index length. Is it possible to move just the data and NOT the index? If so it could be re-indexed if needed once in the new database.
I have remote access to the current and new MySQL databases as well as phpMyAdmin. However, I don’t have shell access to either.
I need someone who knows how to work around the memory/runtime server limits.