Here is my short blog post lets share with my friends who are learning linux and want to import or export data to phpmyadmin using linux. So here is the code for that.

Data Export in linux

mysqldump -u dbusername -h dbhost -pdbpassword dbname > dbname.sql

Data Import in linux

mysql -u dbusername -h dbhost -pdbpassword dbname < dbname.sql

This will solve your problem when you are not able to upload or download db from user inetrface of phpmyadmin.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.