# Failed to import database dump - DK0066 **URL:** \ **Category:** Application Support\ **Created:** [July 18, 2024, 6:39am UTC](https://community.kinsta.com/t/failed-to-import-database-dump-dk0066/3725 "2024-07-18T06:39:20Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![grnatog](https://avatars.discourse-cdn.com/v4/letter/g/f6c823/32.png) [@grnatog](https://community.kinsta.com/u/grnatog)\ **Post date:** [July 18, 2024, 6:39am UTC](https://community.kinsta.com/t/failed-to-import-database-dump-dk0066/3725/1 "2024-07-18T06:39:20Z")
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](https://us1.discourse-cdn.com/flex020/uploads/kinsta/original/2X/7/773ca4bc691669c57741459b2e8875c9a996d6db.png) 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](https://us1.discourse-cdn.com/flex020/uploads/kinsta/original/2X/1/12e05e2f54b8f51d8245b7c22e957f39260e2160.png) Here are main.logs. What might be going wrong? ````auto [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. (/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. (/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** ```` ---
**Author:** ![grnatog](https://avatars.discourse-cdn.com/v4/letter/g/f6c823/32.png) [@grnatog](https://community.kinsta.com/u/grnatog)\ **Post date:** [July 18, 2024, 7:06am UTC](https://community.kinsta.com/t/failed-to-import-database-dump-dk0066/3725/2 "2024-07-18T07:06:51Z")
I was able to solve this by just deleting my local site and then re-downloading from my prod website. ---
**Author:** ![merineth](https://sea2.discourse-cdn.com/flex020/user_avatar/community.kinsta.com/merineth/32/3022_2.png) [@merineth](https://community.kinsta.com/u/merineth)\ **Post date:** [July 18, 2024, 8:05am UTC](https://community.kinsta.com/t/failed-to-import-database-dump-dk0066/3725/3 "2024-07-18T08:05:57Z")
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! ---
**Author:** ![Allan\_Crabtree](https://sea2.discourse-cdn.com/flex020/user_avatar/community.kinsta.com/allan_crabtree/32/3100_2.png) [@Allan\_Crabtree](https://community.kinsta.com/u/Allan_Crabtree)\ **Post date:** [July 22, 2024, 4:19pm UTC](https://community.kinsta.com/t/failed-to-import-database-dump-dk0066/3725/4 "2024-07-22T16:19:53Z")
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: > [@DK0066: IMPORT\_DB\_DUMP: Error (1): (ERROR at line 1: Unknown command '\\-'](https://community.kinsta.com/t/dk0066-import-db-dump-error-1-error-at-line-1-unknown-command/3491/37): > > I have a solution that actually works but you need to be very quick. Step 4 is where the magic happens. Add the site as normal in DevKinsta and wait for it throw the error DK0066. Open the backup.sql file in a fast text editor like Sublime. Some IDE’s might be a bit too slow. Delete the first line /\*!999999- enable the sandbox mode \*/ and Save. NOW is the tricky bit, which nobody seems to have mentioned. Read all of this step first before starting. You need to click ‘Retry’ in DevKinsta which … ---
**Author:** ![jackirish](https://sea2.discourse-cdn.com/flex020/user_avatar/community.kinsta.com/jackirish/32/1361_2.png) [@jackirish](https://community.kinsta.com/u/jackirish)\ **Post date:** [July 22, 2024, 9:14pm UTC](https://community.kinsta.com/t/failed-to-import-database-dump-dk0066/3725/5 "2024-07-22T21:14:39Z")
Hi @Allan_Crabtree ! Thank you for providing this workaround - it’s greatly appreciated. ---
**Author:** ![system](https://us1.discourse-cdn.com/flex020/uploads/kinsta/original/2X/8/80f8c4e56fecc02327a0964e6bf63a716483529f.png) [@system](https://community.kinsta.com/u/system)\ **Post date:** [July 25, 2024, 9:15am UTC](https://community.kinsta.com/t/failed-to-import-database-dump-dk0066/3725/6 "2024-07-25T09:15:34Z")
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.