How To Import Databases using SSH (MySQL or MariaDB)

Follow the following steps to Import Databases using SSH

  1. Log in to SSH.
  2. From the command line, you can import the SQL file with the following command:

MySQL -u database_username -p database_name < /path_to_database/database_file.sql

Change database_username with the username of the database
Change database_name with the name of the database
Change /path_to_database/database_file.sql with the database file to be imported

  • SSH, database, SQL
  • 5 Users Found This Useful
Was this answer helpful?

Related Articles

Backup restoration

Since backups are saved at various nodes to avoid data loss, we manage the backup and...

How To allow SQL Express traffic in windows firewall

Please follow the below steps to allow SQL express communication in the firewall. Open SQL...

How to change SQL authentication in SQL Express

Please follow the below steps Login to SQL Express using SQL management studio. Right-click...

Set Up Sending of Email in Plesk

To Set Up Sending of Email in Plesk, You need to follow the below Points   1. Go to Tools...

How to check Port status of VPS

It may possible that the firewall has blocked a few ports and it is not accessible.  To check...

Powered by WHMCompleteSolution