I use a shareware tool called dbScripter (www.dkgas.com), which is very cheap to license. It lets you generate scripts that will create table structures, indexes and table-loads. It comes with syntax profiles for SQL Server, Oracle and Access, and you can also create your own profiles. I created one for MySQL and can move data quite easily. I just generate the scripts in Windows against whichever back end, then run them in Linux. It's quite simple. I have licensed it for so long that I forget whether the free download is crippled in any way. It might just have a time limit.
If that's all you have to do, I would suggest dbScripter. But is it really all you have to do? Somehow I suspect that this is only the beginning. Do you then have to connect existing Windows apps to the Linux back end? Arthur ----- Original Message ----- From: "Sonia" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 18, 2002 5:00 AM Subject: Migration from windows to linux > Hello list, > > I`m a newbie to mysql and linux and have at the moment a necessity > concerning to both that I`m not able to handle due to my lack of > knowledge in these fields. The fact is that I need to migrate a mysql > database and its tables from windows to linux and haven`t found anything > in the web that could give me a hint so could someone tell me something > about how to migrate a database from one platform to another? I really > would appreciate the help! > > Looking forward at least one answer ;-) , thanks a lot in advance. > > Sonia. > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php