How to Import A MySQL Database through SSH?

To import a MySQL dump, first upload the dump file to your web space via FTP.
Once the file is in your web space, please login to your shell account via SSH and
run this command:

mysql -u db_username -p db_name < /home/username/public_html/dumpfile.sql

Enter password:

Please replace this information with the MySQL login data shown in your
Control Panel.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Creating a database

The four steps to creating a database via cPanel: From the main cPanel menu - 'MySQL...

What is MySQL?

The MySQL database server is the world's most popular open source database.MySQL is designed to...

What is the database HOST?

If the script or software you use requires the database hostname you should use:  localhost