What is the command to import database of a website in SSH?

How do I import a database over SSH?

Here are the steps:1Step 1 - Preparation. Upload the database (file in .sql format ) to public_html (you can do it via FTP or with File Manager) ... 2Step 2 - Connecting. Connect to your hosting account via SSH. ... 3Step 3 - Import. To import the database, use this command: mysql -u database_username -p database_name < file.sql.How do I import a database over SSH? | Hostinger Help Center

How do I import a database into my website?

To import your database, you need to take the following steps:1Download a desktop MySQL administrator like MySQL Workbench.2Export your database to a . ... 3Log in to your web hosting control panel.4Create a Database.5Create a Database user and set a password for this.Importing MySql Database to online web hosting site? - Stack Overflow

How can I import a database using command line?

Show activity on this post.1Open the MySQL command line.2Type the path of your mysql bin directory and press Enter.3Paste your SQL file inside the bin folder of mysql server.4Create a database in MySQL.5Use that particular database where you want to import the SQL file.6Type source databasefilename.sql and Enter.How do I import an SQL file using the command line in MySQL?

How do you import a database?

How to import a MySQL database1Log in to cPanel. ... 2In the DATABASES section of the cPanel home screen, click phpMyAdmin: ... 3In the left pane of the phpMyAdmin page, click the database that you want to import the data into.4Click the Import tab.5Under File to Import, click Browse, and then select the dbexport. ... 6Click Go.How to import and export a MySQL database - A2 Hosting