> if we were to migrate the data from the current mysql on windows to > mysql on linux, can we do a hard file copy of the database from the > windows to the linux datafile folder directly instead of backup and > restore
I just heard from MySQL support that you *can* copy the table and data files directly from Windows to Linux! Quoted, from ticket #38608: ---------------------------8<--------------------------- > * are the binary table spaces portable? can they just be copied over? Yes, the tablespace and data files would be binary portable in this case. Here are the requirements for binary portability: "The only requirements for binary portability are that the machine uses two's-complement signed integers and IEEE floating-point format. These requirements are widely used among mainstream machines. Binary compatibility might not be applicable to embedded systems, which sometimes have peculiar processors." http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html Note that both Windows and Linux (Fedora and Ubuntu) use two's-complement signed integers and IEEE floating-point format. Also, when it comes to performing the copy/backup, please use the following procedure: 1. Shut down your MySQL server and make sure that it shuts down without errors. 2. Copy all your data files (ibdata files and .ibd files) into a safe place. 3. Copy all your ib_logfile files to a safe place. 4. Copy your my.cnf configuration file or files to a safe place. 5. Copy all the .frm files for your InnoDB tables to a safe place. This procedure is documented on the following page in the manual, for reference: http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html > * the Linux system may be Fedora or Ubuntu server, but the database version may be slightly different. Might this be a problem? What is the new version you are migrating to? If it is the same version, or newer, but still 5.0.x, then I would say it should be fine. However, I would not necessarily recommend this if you are using 5.1, or if you are reverting to an older version, as further or differing steps may be needed. > Replicating to Linux with subsequent switchover is one option we're considering. This would also be a good solution, however, since you can copy the binary files directly, you may not need to perform this step. I hope this helps, and just let me know if you have any additional questions about the issue. Best regards, Chris -- Chris Calender, M.S. MySQL Senior Support Engineer Sun Microsystems, Inc. http://www.sun.com/mysql/ --------------------------->8---------------------------
signature.asc
Description: This is a digitally signed message part
------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/blackberry
_______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
