How to Import Mysql Database with SSH?
For “sql” files that are too large to be transferred over phpmyadmi…
How to Import Mysql Database with SSH?
Fri, 21, Feb, 2020 14:06

How to Import Mysql Database with SSH?

For “sql” files that are too large to be transferred over phpmyadmin; different solutions can be produced. Among this type, it can be transferred over SSH.

How is MySQL Import (Installation) Processed?
It can back up the MySQL database from the server with the extension ".sql" in the previous case and its name works as "backup.sql".
Then, it is important; It can be downloaded from the website or the internet.
Provide an SSH connection to your server.
“Backup.sql” options are installed under a web server; With the command "www.siteadresi.com/yedek.sql", you can shoot.
Switch to the directory using the ".Sql" option and enter the command "mysql -u database_user_name -p database_name <backup.sql".
In the field asking for the password, type the database password.
It is for transactions, if you have not received any errors; The database is under import (upload).
MYSQL Install and Backup Restore Alternatives with SSH Command
Downloading the SQL file is downloaded via SSH or located on our server; It can be imported into a new or active database by alternative commands.

You must log in as SSH root, then the process with the directory where we have our sql file or the corresponding directory in the last command.
The command “Mysql -u database_username -p database_name <sqldilename.sql” is confirmed and the database user password is entered.
After entering the password, the installation is completed.