General Inquiries | Knowledge Base | Submit Trouble Ticket

Knowledge Base - FAQ

Question: How do I restore a database from a dump via the shell?

Here is the basic syntax:

mysql -h <hostname> -u <username> -p <database> < <backupfile.sql>

You can also do:

mysql -h <hostname> -u <username> -p <database>
create database <database>
use <database>
source <backupfile.sql>