MyBlogPlanner

Archive for the ‘phpmyadmin’ Category

Import and export big db in linux

Monday, September 14th, 2009

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.