Hello.
Like MyISAM data files, InnoDB data and log files are binary-compatible on all platforms if the floating-point number format on the machines is the same. You can move your database by copying all the relevant files. If the floating-point formats on the machines are different but you have not used FLOAT or DOUBLE data types in your tables, then the procedure is the same: Just copy the relevant files. If the formats are different and your tables contain floating-point data, you have to use mysqldump to dump your tables on one machine and then import the dump files on the other machine. Don't forget to put the same values for the ft_min_word_len and ft_max_word_len variables on your another server (and I think you should at least restart your server after moving InnoDB). For more information see: http://dev.mysql.com/doc/mysql/en/Moving.html http://dev.mysql.com/doc/mysql/en/MyISAM_storage_engine.html "Homam S.A." <[EMAIL PROTECTED]> wrote: > Is it possible to copy the database files (both MyISAM > and InnoDB) that contain tables, indices, and > full-text indices from one MySQL server to another > running/active MySQL server and start using them right > away? > > I appreciate your help! > > Homam > > > > > __________________________________ > Do you Yahoo!? > Take Yahoo! Mail with you! Get it on your mobile phone. > http://mobile.yahoo.com/maildemo > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
