How to Import MySQL Database using SSH Command line? [STEP BY STEP]☑️

This documentation will help you learn How to import MySQL Database using Command line. Watch the video tutorial on how to import MySQL database using SSH Command line.

If you don’t want to watch the video tutorial, skip and proceed with the text version mentioned below.

Follow the steps described below to import a Database via command line:

Step::1 Login to cPanel and go to MySQL Database in DATABASES section

How to Import MySQL Database using SSH Command line

Step::2 Create a Database

Step::3 Add New User by specifying Username, Password and then click on Create User tab

Step::4 Next Add User to Database By specifying Username and associated Database, then click Add

Step::5 Manage All User Privileges and click on Make Changes tab

Step::6 Now Login to Filezilla using credentials

Step::7 Drag and drop .sql file from local to remote (outside public_html)

Step::8 Now go back to cPanel and locate the .sql file at the same path i.e outside public_html

Step::9 Next login to SSH at user level and execute the command provided below to import MySQL database from an SQL file.

mysql -uUSERNAME -p DB_NAME < import_file.sql

Step::10 It will ask you for the password. Enter the password and it will start importing data from the SQL file you have mentioned in the command.

So, this is how you can import databases in MySQL.

That’s all you are done!!!

We hope this video helped you learn How to Import MySQL Database using SSH Command line

For more information, kindly follow us on social media like Twitter and Facebook and for video tutorials, subscribe to our YouTube channel –https://youtube.com/redserverhost.com

Facebook Page- https://facebook.com/redserverhost

Twitter Page- https://twitter.com/redserverhost.com

If you have any query, feel free to let us know via the comments section below.

Thanks for Reading!!!

Tags: cheap linux hosting, buy linux hosting, cheap reseller hosting, buy reseller hosting, best reseller hosting, cheap web hosting, cheapest web hosting, cheapest reseller hosting, cheap reseller host, cheap linux host, cheapest linux hosting, best linux hosting, best web hosting