Most of the host keeps 2 MB or 5 MB file upload limit by phpmyadmin which makes it very difficult to import any kind of mysql dump (.sql) files, So you have to use shell prompt to import and export mysql dump files. Here are the commands to import and export mysql dumps.

To Export Mysql dump files

mysqldump -u db_user -p db_name > dump.sql

To IMPORT dump file into database -

mysql -u db_user -p db_name < dump.sql

db_user is the username for the database (don’t confuse with user name of unix, mysql user is different) and db_name is the name of the database. You will also need to enter the password for mysql user. Do make sure the database already exist and the user has proper permission to edit database.

Related posts:

1. How to get Import Export license in India In my last post I had talked about how paypal...
2. Get MySQL ODBC Driver MySQL provides standards based ODBC drivers for all programmers to...
3. How to open Big sql dump files If you are having huge sql dump files or probably...
4. Reset Wordpress Password using PhpMyAdmin and Mysql Today somehow MWolk Blog which runs on wordpress stopped accepting...
5. Windows password file Windows password file (shortcut is PWL) is a file which...