Helpdesk Open Ticket Support History Knowledgebase Getting Started Video Tutorials
Search

Just Host Web Hosting Help

MySQL Database Import via Command Line

Summary

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.

  1. Upload the SQL file to the server.
  2. If the database does not exist please create one with an user. Note the username and password.
  3. Log into the server through SSH
  4. Navigate to the directory where your .sql file is.
  5. Type this this command:
    mysql -p -u username database_name < file.sql

    Note: Just Host 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 Just Host username prefix with the _ (underscore) after it and the database name.

    Knowledgebase Article 186,517 views bookmark
    share
    Share or save this via:
    tags: command database import line mysql phpmyadmin ssh (updated 397 days ago)


    Was this resource helpful?
    Helpful Unhelpful


    Did this resolve your issue?
    Solved Unsolved


    Please add any other comments or suggestions about this content:





    Recommended Help Content

    MySQL Import and Export (.sql file) via SSH
    How to import and export a MySQL Database from the command line. (updated 266 days ago)
    Knowledgebase Article 254,941 views tags: database mysql

    How to import a MySQL Database using phpMyAdmin
    How do I import a backup of my database (.sql file) using phpMyAdmin? (updated 215 days ago)
    Knowledgebase Article 67,077 views tags: database mysql phpmyadmin

    MySQL Import and Export (.sql file) via PhpMyAdmin
    I need to Export or Import a MySQL database (updated 1396 days ago)
    Knowledgebase Article 120,126 views tags: database import mysql php transfer

    Related Help Content

    Managing Your Database Using phpMyAdmin
    A repository of information on how you can manage your database by using the phpMyAdmin interface. (updated 216 days ago)
    Knowledgebase Article 81,423 views tags: commands database mysql phpmyadmin

    MySQL Database Restore
    How to Restore your MySQL Database? (updated 404 days ago)
    Knowledgebase Article 64,689 views tags: admin database mysql php phpmyadmin restore

    Mysql connections with a dynamic (changing) IP Address using ssh/putty ect
    Users having problems connecting to mysql database using SSH and/or putty/other client. (updated 1111 days ago)
    Knowledgebase Article 48,435 views tags: connection ip mysql putty ssh whitelist

    How to copy a database in phpMyAdmin
    A guide to duplicating a MySQL database using phpMyAdmin (updated 216 days ago)
    Knowledgebase Article 2,973 views tags: databases mysql phpmyadmin

    Dropping columns from a database table in phpMyAdmin
    A tutorial on how to perminately delete columns from your mySQL database using phpMyAdmin (updated 215 days ago)
    Knowledgebase Article 2,213 views tags: Plesk cpanel databases mysql phpmyadmin

    How to add tables to a database in phpMyAdmin
    Guidance on adding tables to your mySQL database in phpMyAdmin (updated 216 days ago)
    Knowledgebase Article 1,868 views tags: mysql phpmyadmin

    Searching through a MySQL database in phpMyAdmin
    Step by step directions on how you can search your database using phpMyAdmin (updated 216 days ago)
    Knowledgebase Article 2,457 views tags: Plesk cpanel databases mysql phpmyadmin

    MySQL Repair / Optimize Tables in phpMyAdmin
    How to repair and optimize your database using phpMyAdmin: (updated 408 days ago)
    Knowledgebase Article 67,583 views tags: database mysql optimizing repairing slow speed