HostMonster Web Hosting Help
MySQL Database Import via Command Line
Using SSH can be a superior way to manage the files and databases on your account. Using a simple command you can import a MySQL database into an existing database on your account.
Note: SSH access is required for this process. Click Here for information about getting SSH access
Using SSH to import your MySQL database
The file must be in .sql format. It can not be compressed in a .zip or .tar.gz file.
- Upload the SQL file to the server.
- If the database does not exist please create one with an user. Note the username and password.
- Log into the server through SSH
- Navigate to the directory where your .sql file is.
- Type this this command:
mysql -p -u username database_name < file.sql
Note: HostMonster recomends using the database user with the database users password not the cPanel main user and password. The -p will cause mysql to prompt for your account's password. Do not put passwords in command line in plain text, but let the system prompt for a password. This is for your own security.
Make sure your database name has your HostMonster username prefix with the _ (underscore) after it and the database name.Knowledgebase Article 271,472 views bookmarksharetags: command database import line mysql phpmyadmin ssh (updated 638 days ago)Share or save this via:
Recommended Help ContentThis article will instruct you how to export a database from the command line (SSH). (updated 228 days ago)
How do I import a backup of my database (.sql file) using phpMyAdmin? (updated 456 days ago)
I need to Export or Import a MySQL database (updated 228 days ago)
Related Help ContentA repository of information on how you can manage your database by using the phpMyAdmin interface. (updated 458 days ago)
How to Restore your MySQL Database? (updated 646 days ago)
Users having problems connecting to mysql database using SSH and/or putty/other client. (updated 1352 days ago)
A guide to duplicating a MySQL database using phpMyAdmin (updated 457 days ago)
A tutorial on how to perminately delete columns from your mySQL database using phpMyAdmin (updated 456 days ago)
Guidance on adding tables to your mySQL database in phpMyAdmin (updated 457 days ago)
Step by step directions on how you can search your database using phpMyAdmin (updated 457 days ago)