Import MySQL database from dump file

22.Dec.2010

Sometimes, dump of a database is too large to be imported using PMA. In these cases it is good practice to upload database to a server and import it using CLI. To import database with CLI, use following snippet:

cat database_name.sql | mysql -uusername -puser_password database_name

If you would like to know how to use SSH to backup database, take a look at mysqldump usage.