Import MySQL database via SSH

Posted on by

In order to perform the import MySQL database using the console created previously to be the database:

Upload database (plik *.sql) for example hosting account. using FTP

using the command cd sciezka/ go to the folder where the file * .sql

The command mysql serving m.in. inportu databases to execute:

1
mysql  --user użytkownik_bazy -p nazwa_bazy < importowany_plik.sql

where:

  • użytkownik_bazy – user name when creating a database
  • db_name – database name
  • importowany_plik.sql – the name of the imported file

Then enter the password to access the database for the user.

wait a, until the database is uploaded. If nothing appears message, means, that the database has been uploaded correctly.

 

How useful this post was?

Click on the star, to evaluate it!

Average grade / 5. number of votes:

So far, no votes! Be the first to rate this post.

Related entries:

Installing Node.js in Ubuntu 20.04
Installing and securing MongoDB in Debian 11
Installing vsftpd on a Debian system 11
Conversion Magento admin password from the database
gconf-service gconf-service-backend gconf2-common libappindicator1 libc++1 libc++1-9 libc++abi1-9 libdbusmenu-gtk4 libgail-common libgail18 libgconf-2-4 libgtk2.0-0 libgtk2.0-bin libgtk2.0-commonAll-in-one voice and text chat for gamers All-in-one voice and text chat for gamers that's free 20.04