Hi Maciej, Thanks a lot for this info, so the best may to move tables from one db to another db on a different machine is to use mysqldump, right?
regards anandkl On 3/28/07, Maciej Dobrzanski <[EMAIL PROTECTED]> wrote:
In news:[EMAIL PROTECTED], "Ananda Kumar" <[EMAIL PROTECTED]> wrote: > 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. You cannot do this with copying .ibd files alone, but in most cases you can move to a different server all the InnoDB information (.idb files, shared tablespace(s), log files, database parameters regarding InnoDB log files and tablespaces (count, sizes, filenames)), with appropriate .frm files. This would of course require the new server not to contain any earlier InnoDB data or it will be lost. I don't know if there are any guides covering this particular operation. Perhaps some InnoDB backup&resotre guides will be helpful as this is virtually what you want to do. Maciek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
