new to linux, mysql help...
Moderator: General Moderators
new to linux, mysql help...
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.. 
Probably your easiest solution would be to just dump the database. In Linux you can call
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
mysqldump -u root -ppassword_here database_name > /location/you/want/for/dumpTo 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/fileReal programmers don't comment their code. If it was hard to write, it should be hard to understand.