Hi Friends, I have set innodb_file_per_table option in my.cnf file for one database. Now there is huge load on this servers. Is it possible for me to move all these files to a new db on a new machine. If you can you please let know how it can be done or guide to any url, it would be of great help.
regards anandkl