How do I fix «ERROR at line 1: Unknown command '\-'» on importing a MySQL dump back to a database?

dmitrii_fediuk · August 4, 2024, 12:38am

2024-08-04--03-38-39

MariaDB import issue: Error at line 1: Unknown command '\-'

opened 04:55PM - 07 Jun 24 UTC

closed 09:20PM - 21 Jun 24 UTC

**Describe the bug** The bug occurs when running a Drush command to execute a S…QL query from a compressed SQL file. The process fails with an error indicating an "Unknown command '-'" at line 1 of the SQL file. This suggests that the SQL file may contain a malformed command or unexpected characters, likely due to improper file handling or corruption during the compression/decompression process. Consequently, the MySQL client encounters an invalid command at the start of the file, leading to the failure of the SQL query execution. ```bash The command "/var/www/vendor/bin/drush sql:query --yes --strict=0 --file=/tmp/main_20240607_164715.sql.gz --file-delete" failed. Exit Code: 1(General error) Working directory: Output: ================ Error Output: ================ In SqlCommands.php line 183: Query failed. Rerun with --debug to see any error message. ERROR at line 1: Unknown command '\-'. ``` **To Reproduce** `drush sql-sync @client.dev @client.local --yes` **Workaround** This article describes the issue really well https://gorannikolovski.com/blog/mariadb-import-issue-error-at-line-1-unknown-command ### System Configuration | Q | A | --------------- | --- | Drush version? | 12.5.2.0 | Drupal version? | 10.2.5 | PHP version | 8.2.18 | OS? | Linux

dmitrii_fediuk · August 4, 2024, 1:02am

Method 1 (faster to execute)

grep -v '!999999\\- enable the sandbox mode' dump.sql > temp && mv temp dump.sql

Method 2 (shorter to write)

sed -i '/!999999\\- enable the sandbox mode/d' dump.sql