@jarno I checked your site and noticed that the MariaDB version is 10.11.8. After further investigation, I found an article confirming that this specific version has certain issues MariaDB Dump File Compatibility Change - MariaDB.org. I couldn’t replicate the issue previously since my sites were already running on 10.11.9. I will report this back to our development team. However, please note that development for DevKinsta is currently paused, so I cannot provide an estimated time for when our team can look into this.
In the meantime, you can contact our Support team via chat to request an upgrade from MariaDB version 10.11.8 to 10.11.9 as a workaround. New sites created at Kinsta already use MariaDB version 10.11.9. I recommend performing the upgrade on a staging environment first to test it. Once everything is working properly, you can then request to upgrade MariaDB on your live site as well.
I don’t have the exact info on why that is, it was decided by company management but we are still doing maintenance and security updates for DevKinsta.
I’m seeing this issue for the first time today too. Is development on DevKinsta still paused?
Using Allan_Crabtree’s method of quickly editing backup.sql, before it’s finished downloading the database dump, I was able to get past the initial error but it then fails with error:
[2025-02-17 16:28:47.413] [error] Error - DK0066: IMPORT_DB_DUMP: Error (1): +ERROR at line 3721: Unknown command ‘\0’.
at /opt/DevKinsta/resources/app.asar/main.prod.js:2:757027
at tryCatch (/opt/DevKinsta/resources/app.asar/main.prod.js:8:1829201)
at Generator. (/opt/DevKinsta/resources/app.asar/main.prod.js:8:1830850)
at Generator.next (/opt/DevKinsta/resources/app.asar/main.prod.js:8:1829750)
at asyncGeneratorStep (/opt/DevKinsta/resources/app.asar/main.prod.js:8:1821046)
at _next (/opt/DevKinsta/resources/app.asar/main.prod.js:8:1821345)
at processTicksAndRejections (node:internal/process/task_queues:95:5)
I’m on Ubuntu running version 2.13.2 of DevKinsta, which it tells me is up to date.
Furthermore, I think there’s been a misunderstanding. Jack gave you an advice to include the flag in your command when using mysql or wp db import commands in the command line.
Based on your response, you were testing the solution of editing the backup.sql before clicking ‘Retry’.
I would first advise trying to download the latest version of DevKinsta and seeing if the issue persists then and sharing the main.log if it does.