Once I decided to import sql dump:
mysql -u root database < database.sql.gz
And I noticed the following error:
ERROR: ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII '\0' is expected. Query: ''.
The error occurs because the dump is compressed and must first be unpacked:
And then import:
mysql -u root database < database.sql
See my other articles in the category MySQL