Import MySQL database via SSH
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.
