0

I want to pass my all database from windows to ubuntu on my computer. I think passing all releated data files will be enough so I need to find the files in my windows. Do you know what isthe directory path for these files? Also is it enough to carry the files to pass my database as I desire?

Thanks :)

3
Contributors
2
Replies
3
Views
5 Years
Discussion Span
Last Post by smantscheff
0

MySQL>Data>dbname

at least that's where it is in my installation of usbwebserver on my windows laptops.

copy the folder with the database name and paste in new location. Test this first of course.
There are three files per table in the database: .frm = table definition; .MYD = table data; .MYI = table index/indices

OR do a databse dump (or a total export if you have something like phpMyAdmin or HeidiSQL) This produces plain text files which are a set of sql queries which will rebuild the entire database when run.

Edited by drjohn

0

The location of the database files depends on the datadir configuration variable in my.ini (or my.cnf, depending on the installation). This configuration file usually resides in the root directory of your mysql installation.
But, as drjohn suggests, better export the whole database. mysqldump is a command line utility which comes with MySQL and exports all data. Import the dump by feeding it to the command line client mysql.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.