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.

One thought on “Import and export big db in linux”

  1. It’s really a cool and useful piece of information. I’m satisfied that you simply
    shared this useful info with us. Please keep us informed like this.

    Thanks for sharing.

    Here is my site Virginia

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.