cPanel to DA migrations fails with MySQL errors

[arundnair]

Recently, we started encountering MySQL restore errors during migrations from cPanel to DirectAdmin.

```
Database: restoring "lksjhu_web3" database: exit status 1
ERROR at line 1: Unknown command '\-'.
restoring "lksjhu_web2" database: exit status 1
ERROR at line 1: Unknown command '\-'.
restoring "lksjhu_web" database: exit status 1
```

We’re running MariaDB 10.6.20 on DirectAdmin and 10.6.19 on cPanel. Restoring after manually converting backups to DirectAdmin-compatible format also failed. It appears to be related to the compatibility changes mentioned here: https://mariadb.org/mariadb-dump-file-compatibility-change/ (starting from 10.6.18), though these backups are from later versions.

During the restore, the account, domain, and database are created in DirectAdmin, but the dump restoration fails with the error above.

Is anyone else experiencing this issue? Are there any available workarounds? We have hundreds of cPanel accounts to migrate, so manually removing the top two lines of each dump file is not feasible.

 

[adam12]

The last time I ran into this, upgrading from 10.5 to 10.6 corrected the issue. I'm surprised the same didn't work for you.

 

[Ohm J]

I belive, if you create support ticket, DA Team will create workaround for you and you can restore the rest customer.