Knowledge Base : Hard Hat Hosting

Main / Browse Categories / MySQL / How can I import a MySQL database?

How can I import a MySQL database?

From the SSH command line:

mysql -h localhost DATABASE < YOURFILE.sql

Replace DATABASE with the name of your database and YOURFILE with the actual name of your file.

NOTE: Accounts created before July 7th, 2003 will want to use:

/usr/local/mysql/bin/mysql -h localhost DATABASE < YOURFILE.sql

User Comments

How can I import a MySQL database?

There are no user comments for this topic.

Attachments

No attachments.

Why Choose Our Hosting?

Unmatched Customer Support!
Virtual Private Server technology provides a rich, dedicated-like environment for every account.
We are known for our superb quality, performance and flexible hosting environment. We manage the server, software, and network you do the rest.