Page 1 of 1
new to linux, mysql help...
Posted: Thu Sep 15, 2005 3:33 am
by pleigh
i was wondering if i can import to linux my database folder from windows...in my linux, i installed xampp to easily configure mysql/php/apache...and in the phpMyAdmin, there are 4 default databases cdcol, mysql,phpmyadmin and test...unfortunately, upon browsing my linux, i can't see where the folder of these 4 databases are located so that i can copy my own database folder and hope that i can import my own database from windows to linux...if importing is not possible, i just would like to know where can i find the location of the database folders that i will be creating...thanks in advance..

Posted: Thu Sep 15, 2005 7:58 am
by feyd
yarrr, 'tis as simple as exportin' from Windows an' importin' ta linuch.
yar.
Posted: Thu Sep 15, 2005 12:32 pm
by pickle
Probably your easiest solution would be to just dump the database. In Linux you can call
Code: Select all
mysqldump -u root -ppassword_here database_name > /location/you/want/for/dump
I'd imagine there's something similar in the Windows installation of MySQL.
To import that dump file into your Linux server, it's as easy as calling:
Code: Select all
mysql -u root -ppassword_again database_name_again < /location/of/dump/file
Posted: Thu Sep 15, 2005 1:59 pm
by ryanlwh
You have phpMyAdmin in your Windows server. You can use that to dump the data to a file (dump them as SQL statements, NOT csv), upload it to a folder in Linux server, and do the importing call pickle provided.