2.10.7. Database import via console

To import the database through the console, do the following:

1. Through filemanager or any FTPclient upload to the hosting a file with a database dump in the format sql.
2. Connect to hosting via SSH.
3. Run the command:

   mysql -h host -u login --password='password' name < way/to/file/dump.sql

   In a team:

   • Instead host, login password and name use appropriate data to connect to the databasewhere the import is performed. The password must be enclosed in quotation marks. Note You can omit the key --password and enter the password directly during the connection.
   • Instead path/to/file/dump.sql specify the path to the dump file (or just its name if it is in the current directory).
4. Enter database user passwordif you did not specify it in the connection command. Attention! For security reasons, in Linux systems, when entering a password or pasting it from the clipboard, characters are not displayed on the screen.
5. Wait for the command to complete.