Failed to import database dump - DK0066

DevKinsta Application Support
1

Hello, I am attempting to pull down a fresh copy of my prod website to my local version via DevKinsta, however, I am getting this error: “Failed to import database dump - DK0066”. I am using the latest version of DevKinsta on MacOS.

image
image1078×572 35.1 KB

Also, when I attempt to go to my local database, I get this error: "Warning: Trying to access array offset on null in /var/www/html/adminer.php on line 1452

Invalid database."

image
image756×83 6.63 KB

Here are main.logs. What might be going wrong?

[2024-07-17 00:00:04.448] [info]  [containerExec] Command 'chown -R www-data:www-data /www/kinsta/public/[my_website_name_anonymized]' on devkinsta_fpm finished with exit code 0
[2024-07-17 00:00:04.465] [info]  [importBackupToDb] Import db
[2024-07-17 00:00:04.465] [info]  [dockerUtil/getContainer] Get 'devkinsta_fpm' Docker container
[2024-07-17 00:00:04.681] [info]  [ProgressIndicator] { isFailed: false, isOpen: true }
[2024-07-17 00:00:04.714] [info]  [containerExec] Command 'mysql -h devkinsta_db -u root -p****** [my_website_name_anonymized] < "/www/kinsta/public/[my_website_name_anonymized]/backup.sql"' on devkinsta_fpm finished with exit code 1
[2024-07-17 00:00:04.718] [error] Error - DK0066: IMPORT_DB_DUMP: Error (1): >ERROR 1049 (42000): Unknown database '[my_website_name_anonymized]'
    at /Applications/DevKinsta.app/Contents/Resources/app.asar/main.prod.js:2:757027
    at tryCatch (/Applications/DevKinsta.app/Contents/Resources/app.asar/main.prod.js:8:1829201)
    at Generator.<anonymous> (/Applications/DevKinsta.app/Contents/Resources/app.asar/main.prod.js:8:1830850)
    at Generator.next (/Applications/DevKinsta.app/Contents/Resources/app.asar/main.prod.js:8:1829750)
    at asyncGeneratorStep (/Applications/DevKinsta.app/Contents/Resources/app.asar/main.prod.js:8:1821046)
    at _next (/Applications/DevKinsta.app/Contents/Resources/app.asar/main.prod.js:8:1821345)
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
[2024-07-17 00:00:04.747] [error] [ipcMainStep] Error in operation SITE_PULL, step importDb: Error - DK0066: IMPORT_DB_DUMP: Error (1): >ERROR 1049 (42000): Unknown database '[my_website_name_anonymized]'
    at /Applications/DevKinsta.app/Contents/Resources/app.asar/main.prod.js:2:757027
    at tryCatch (/Applications/DevKinsta.app/Contents/Resources/app.asar/main.prod.js:8:1829201)
    at Generator.<anonymous> (/Applications/DevKinsta.app/Contents/Resources/app.asar/main.prod.js:8:1830850)
    at Generator.next (/Applications/DevKinsta.app/Contents/Resources/app.asar/main.prod.js:8:1829750)
    at asyncGeneratorStep (/Applications/DevKinsta.app/Contents/Resources/app.asar/main.prod.js:8:1821046)
    at _next (/Applications/DevKinsta.app/Contents/Resources/app.asar/main.prod.js:8:1821345)
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
[2024-07-17 00:00:04.796] [info]  [ProgressIndicator] { isFailed: false, isOpen: true }
[2024-07-17 00:00:04.838] [info]  [ProgressIndicator] { isFailed: true, isOpen: true }```**strong text**
2

I was able to solve this by just deleting my local site and then re-downloading from my prod website.

3

Hi @grnatog, we are glad to know that you have manage to resolve the issue.
If ever you encounter other issues, please feel free to reach out.

Have a great day!

4

For others who are also having the same issue, but it was not solved by deleting/re-downloading the site - I posted a very strange alternative solution here:

5

Hi @Allan_Crabtree ! Thank you for providing this workaround - it’s greatly appreciated.

6

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.