Cross Platform Database Restore

[silliwb]

Does anyone know of a method or what the process is for restoring a Sugar OpenSource 4.5.0b database from a Linux install to the same version on a Windows install?

Thanks,
Brian

[Markku]

Please see this thread, hope it helps

http://www.sugarcrm.com/forums/showthread.php?t=15468

[silliwb]

Not really, I'm hoping to stick with MySQL as the database. Any ideas on just moving the MySQL from one environment to the other?

[kpit]

use mysqldump command to dump the whole database to a sql script. Run the sql script on the new machine.

[Markku]

Sorry, I misunderstood your question, thought you meant swiching from MySQL to MS SQL.

If you use MySQL is it very simple as umeco stated, just create database dump in your Linux environment and restore it in Windows.