I have to move a given database of 100gb from server a to server b and later this year to server c with a copy for testing to server d.
So all servers are Unix (mostly Debian) with MySQL. The databases are MyISAM.
My biggest table, which holds 99% off all data, is 47gb of data (MID) with additional 50gb of indexes (MIY).
My idea is to:
1) Tar the database files
2) copy to new server
3) un-tar it
4) copy it to new mysql folder
Can I delete the index-file and recreate the indexes on the new server to reduce the copy and tar-time by 50%?