How to Import MySQL Database using SSH Command line? смотреть онлайн

Today in this video you will learn how to import Database via command line.
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
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 pasted in the link provided below to import MySQL database from an SQL file.
https://pastebin.com/59UnYGCX
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.


Watch the video carefully and perform the steps accurately to import databases in MySQL.


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
Official Website- https://redserverhost.com

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