Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

I have many table data that I've copied from Windows MySQL environment and now trying to open them in my Ubuntu but fails. So I copied all table files from Windows (e.g test table, D:/LAMP/mysql-data/test/) and pasted completely same files to Ubuntu (/var/lib/mysql/test/) but even I see the tables on phpmyadmin but cannot open them with phpmyadmin or another mysql tool.

Any idea?

share|improve this question
The /var/lib/mysql directory is protected by the mysql root user account. It's very probable that the files you have moved in have the wrong permissions and mysql will refuse to open them. Try exporting .sql files from the Windows side and importing them through phpMyAdmin. –  douggro Jul 28 '13 at 2:59
Sorry but windows is gone :) but also tried this /home/qeremy/mysql after changing mysql data dir, does not work –  Qeremy Jul 28 '13 at 15:08
I would check the MySQL documentation at dev.mysql.com/doc/refman/5.5/en/index.html and see what your options are for recovering the data from those files. –  douggro Jul 28 '13 at 17:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.