Categories
Abuse and Security
4
Advanced Users
11
Cloud Hosting Basic Questions
4
CloudFlare
6
cPanel
13
Domain Names
11
Email
12
FFmpeg
1
Free Website Transfer
2
Free Website Transfer
1
FTP Basics
2
ID Protection / Domain Privacy
3
MySQL Basics
4
Name Servers (DNS)
1
PHP
1
Pre Sales Questions
12
Reseller Hosting
7
Sales & Billing
13
Shared Hosting
9
Softaculous
1
SSH
3
SSL Certificates
3
Troubleshooting
8
VPS and Dedicated Servers
4
Website Transfer Service
1
WordPress
1
Categories
How to Import A MySQL Database through SSH? Print
- 0
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:
mysql>
Please replace this information with the MySQL login data shown in your
Control Panel.
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
Loading...
Loading...