convert MySQL data from Windows to Linux

MaaSTaaR · 01-17-2006, 07:01 PM

Hello ...

i want convert MySQL databases , it's on windows and i found it in C:/Apache/mysql/data

my question is where i can found like C:/Apache/mysql/data folder in linux ?

nephish · 01-18-2006, 12:43 PM

well, there really is no C:/ in linux. there is the root folder /
and then there are other folders under that.
on debain (what i use at work) the folder that the database tables are stored in is located in /var/lib/mysql
as to how to convert them, it may be easier to export them to an sql.txt or backup.txt or something.sql, include all the insert commands and create commands .
then import them into your linux sql database.

hw-tph · 01-18-2006, 06:49 PM

nephish is right. You can dump an entire database using mysqldump. This command will dump the entire structure and contents of the "databasename" database on the local machine to a file called backup.sql (the -p option will prompt you for your password):

Code:

mysqldump -u mylogin -p databasename > backup.sql

You can also dump the data from a remote server (if you have permission to access it from your host):

Code:

mysqldump -u mylogin -p --quick -h database.server.com databasename > backup.sql

To get the backed up database onto the new machine, first create the database:

Code:

mysqladmin -p create databasename

And then do the magic to bring the structure and data back:

Code:

mysql -u mylogin -p databasename < backup.sql

Hope that helps.

Håkan