Manage cookies that are used for advertising, such as ad personalization, remarketing, and ad effectiveness analysis.
2.11.4. Import database using console
This method is suitable for importing dumps of any size.
To import the database, do the following:
- Using the file manager or any FTP client, upload the database dump file in SQL format to the hosting.
- Connect to the hosting via SSH.
- Import dump:
mysql -h DB_HOST -u DB_LOGIN -p DB_NAME < PATH/TO/DUMP.SQLIn the command, use your own data:
PATH/TO/DUMP.SQL— path to the SQL file (or its name if the file is in the current directory).
- Enter database user password (for security reasons, characters are not displayed on the screen when entering the password).
- Wait for the command to complete.
(1)
mysql -h хост -u логін назва < шлях/до/файлу/дамп.sql
а потім ввести пароль