# Could not dump database while exporting **URL:** \ **Category:** Uncategorized\ **Created:** [April 25, 2017, 7:51pm UTC](https://community.localwp.com/t/could-not-dump-database-while-exporting/1301 "2017-04-25T19:51:40Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Webtica](https://avatars.discourse-cdn.com/v4/letter/w/bbe5ce/32.png) [@Webtica](https://community.localwp.com/u/Webtica)\ **Post date:** [April 25, 2017, 7:51pm UTC](https://community.localwp.com/t/could-not-dump-database-while-exporting/1301/1 "2017-04-25T19:51:40Z")
Hi Clay and team, I am on the latest Local version 1.4.2 on Mac. I have a site that i want to export with PHP 7.0.3 and Mysql 5.6.34 When i export it gets error could not dump database. When i check in logs it’s only 3 lines : Apr 25, 2017, 9:45 PM GMT+2 - info: [main/exportSite] Running mydumper on database. Apr 25, 2017, 9:45 PM GMT+2 - info: [main/exportSite] mydumper process complete. Apr 25, 2017, 9:45 PM GMT+2 - info: [main/exportSite] Segmentation fault Hope this helps to fix the problem in a next release soon. Thanks Dieter ---
**Author:** ![clay](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/clay/32/8248_2.png) [@clay](https://community.localwp.com/u/clay)\ **Post date:** [April 25, 2017, 8:06pm UTC](https://community.localwp.com/t/could-not-dump-database-while-exporting/1301/2 "2017-04-25T20:06:00Z")
Hi Dieter, Can you right-click on the site then go to “Open Site SSH” and run the following command? ```auto mydumper --verbose 3 -p root -x '^(?!(mysql))' --outputdir /app/sql ``` Sorry for the trouble! ---
**Author:** ![Webtica](https://avatars.discourse-cdn.com/v4/letter/w/bbe5ce/32.png) [@Webtica](https://community.localwp.com/u/Webtica)\ **Post date:** [April 26, 2017, 6:53am UTC](https://community.localwp.com/t/could-not-dump-database-while-exporting/1301/3 "2017-04-26T06:53:24Z")
HI Clay, No problem! Happy to help fix problems and bugs. I tried your command but i get the same thing. I applied the code after i got the error so after I let local export. ``` ** Message: Connected to a MySQL server ** Message: Started dump at: 2017-04-26 06:51:52 ** Message: Thread 1 connected using MySQL connection ID 18 ** Message: Thread 2 connected using MySQL connection ID 19 ** Message: Thread 3 connected using MySQL connection ID 20 ** Message: Thread 4 connected using MySQL connection ID 21 Segmentation fault ``` Thanks Dieter ---
**Author:** ![vpell](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/vpell/32/4392_2.png) [@vpell](https://community.localwp.com/u/vpell)\ **Post date:** [May 21, 2017, 9:22am UTC](https://community.localwp.com/t/could-not-dump-database-while-exporting/1301/4 "2017-05-21T09:22:33Z")
Hi Dieter, did you figured it out? I have the same problem here and dont know how to resolve it. Vincent ---
**Author:** ![Webtica](https://avatars.discourse-cdn.com/v4/letter/w/bbe5ce/32.png) [@Webtica](https://community.localwp.com/u/Webtica)\ **Post date:** [May 21, 2017, 10:03am UTC](https://community.localwp.com/t/could-not-dump-database-while-exporting/1301/5 "2017-05-21T10:03:42Z")
Hi Vincent, Yes i did get to fix it! Are you already on the latest 2.0 version? Dieter ---
**Author:** ![vpell](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/vpell/32/4392_2.png) [@vpell](https://community.localwp.com/u/vpell)\ **Post date:** [May 21, 2017, 4:07pm UTC](https://community.localwp.com/t/could-not-dump-database-while-exporting/1301/6 "2017-05-21T16:07:34Z")
No, but i saw it this morning, i’ll try it. It could also be the answer to another problem i had when creating site from exports and blueprints (Local stuck at “provisionning wp-cli” stage of site creation). Thanks, Vincent ---
**Author:** ![Webtica](https://avatars.discourse-cdn.com/v4/letter/w/bbe5ce/32.png) [@Webtica](https://community.localwp.com/u/Webtica)\ **Post date:** [May 21, 2017, 4:53pm UTC](https://community.localwp.com/t/could-not-dump-database-while-exporting/1301/7 "2017-05-21T16:53:30Z")
Hi Vincent , if you get to run in the same problem again when exporting. open local select the site go to the database section and open adminer. then click on export and let it export all tables once it finishes loading the page just close it and try exporting a site again in local. it should be working then. i didn’t get the problem of exporting in 2.0 as of now so maybe it is fixed. Dieter ---
**Author:** ![vpell](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/vpell/32/4392_2.png) [@vpell](https://community.localwp.com/u/vpell)\ **Post date:** [May 21, 2017, 5:08pm UTC](https://community.localwp.com/t/could-not-dump-database-while-exporting/1301/8 "2017-05-21T17:08:28Z")
Ok, thanks again! Vincent ---
**Author:** ![mattspaeth](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/mattspaeth/32/4808_2.png) [@mattspaeth](https://community.localwp.com/u/mattspaeth)\ **Post date:** [June 14, 2017, 9:39pm UTC](https://community.localwp.com/t/could-not-dump-database-while-exporting/1301/9 "2017-06-14T21:39:44Z")
I’m having this same problem on 2.0.4. Here’s the log. It appears there is a permissions issue causing this. [local-by-flywheel.log](https://us1.discourse-cdn.com/flex019/uploads/lwpforums/original/1X/bcbea9eea7b0d5041a51130cf6004e04d74b3957.log) (65.4 KB) ---
**Author:** ![jakesch](https://avatars.discourse-cdn.com/v4/letter/j/82dd89/32.png) [@jakesch](https://community.localwp.com/u/jakesch)\ **Post date:** [June 17, 2017, 3:19pm UTC](https://community.localwp.com/t/could-not-dump-database-while-exporting/1301/10 "2017-06-17T15:19:41Z")
Worked well for me! Thanks! ---
**Author:** ![pnoeric](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/pnoeric/32/5222_2.png) [@pnoeric](https://community.localwp.com/u/pnoeric)\ **Post date:** [November 13, 2017, 10:18am UTC](https://community.localwp.com/t/could-not-dump-database-while-exporting/1301/11 "2017-11-13T10:18:45Z")
I had the same problem, weird DB errors when exporting. I tried the SSH command that Clay suggested above, and it did not fix the problem. Then I tried the trick suggested by Webtica in the message from May 21 (using Adminer). That did the trick! Thank you! ---
**Author:** ![Webtica](https://avatars.discourse-cdn.com/v4/letter/w/bbe5ce/32.png) [@Webtica](https://community.localwp.com/u/Webtica)\ **Post date:** [November 13, 2017, 1:00pm UTC](https://community.localwp.com/t/could-not-dump-database-while-exporting/1301/12 "2017-11-13T13:00:47Z")
normally you shouldn’t have these problems anymore on the latest 2.1.1 version 🙂 ---
**Author:** ![pnoeric](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/pnoeric/32/5222_2.png) [@pnoeric](https://community.localwp.com/u/pnoeric)\ **Post date:** [November 13, 2017, 1:26pm UTC](https://community.localwp.com/t/could-not-dump-database-while-exporting/1301/13 "2017-11-13T13:26:52Z")
Hmmm I am on 2.1.1 (and normally exporting is flawless for me)-- odd. Hopefully just a glitch in the matrix! ---
**Author:** ![Webtica](https://avatars.discourse-cdn.com/v4/letter/w/bbe5ce/32.png) [@Webtica](https://community.localwp.com/u/Webtica)\ **Post date:** [November 13, 2017, 1:40pm UTC](https://community.localwp.com/t/could-not-dump-database-while-exporting/1301/14 "2017-11-13T13:40:02Z")
strange! I am on 2.1.1 aswel on mac and windows and i can export without problems.