sql - How to migrate mysql database from Ubintu to Windows? -

sql - How to migrate mysql database from Ubintu to Windows? -

i have database need migrate ubuntu windows system. created sql files info gets corrupted. there different approach or solution problem?

yes, works quirks. mysql uses same fileformats across platforms need share info directory. 1 problem info directory need have mysql owner , grouping in ubuntu. , windows case-insensitive , linux case-sensitive maintain names uniform: either whole name lowercase or uppercase not mix them.

in my.ini (in windows it's located somewhere c:\program files\mysql\mysql server 5.1. it's main configuration file mysql) file, should have line:

datadir="c:/programdata/mysql/mysql server 5.1/data/" example

change in both windows , linux ubuntu point 1 single physical folder (on partition file scheme windows recognize). work. file formats identical.

whether boot ubuntu, or windows 7, won't matter, 2 different builds of mysql looking info in same place. 1 time info modified in windows environment, boot ubuntu , info there, modified.

mysql sql database mysqldump rdbms