# Problem getting dev data into live database

**URL:** <https://forum.bubble.io/t/problem-getting-dev-data-into-live-database/73689>\
**Category:** Database\
**Created:** [December 9, 2019, 11:55am UTC](https://forum.bubble.io/t/problem-getting-dev-data-into-live-database/73689 "2019-12-09T11:55:04Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Siddhartha](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/siddhartha/32/40316_2.png) [@Siddhartha](https://forum.bubble.io/u/Siddhartha)\
**Post date:** [December 9, 2019, 11:55am UTC](https://forum.bubble.io/t/problem-getting-dev-data-into-live-database/73689/1 "2019-12-09T11:55:04Z")

</div>

After deploying my site I wanted to copy the test data that was in the dev database into the live database.

Maybe there is an easier way to do this, but as I don’t know what that is, I figured I’d just export the dev data and import into the live database.

Everything went well until it got to a list field and I got a message about choosing a delimiter. I tried everything that was on offer, but still kept getting this error:

> **[Image 2019-12-09 at 12.02.00 pm.png](https://share.getcloudapp.com/o0uQj8rX)**
>
> Shared with CloudApp

As the data is coming out of Bubble and back into Bubble I don’t get how it would be in the wrong format.

So, couple of questions:

1. Is there an easier way to just switch dev data into live data?

2. Why am I getting that error and how do I get around it?

Thanks for your help with this.

---

<div class="post-metadata">

**Author:** ![petter](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/petter/32/98626_2.png) [@petter](https://forum.bubble.io/u/petter)\
**Post date:** [December 9, 2019, 12:02pm UTC](https://forum.bubble.io/t/problem-getting-dev-data-into-live-database/73689/2 "2019-12-09T12:02:31Z")

</div>

Hi @Siddhartha,

Yes, there’s a much easier way to do this 🙂

Go into the Data Tab, and App Data. Then find the red link that says _Copy and restore database_. There, you’ll find ways to sync the database both ways.

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/d/e/debad3de07f34f4957e9b9c568287a060837201b.png)

---

<div class="post-metadata">

**Author:** ![Siddhartha](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/siddhartha/32/40316_2.png) [@Siddhartha](https://forum.bubble.io/u/Siddhartha)\
**Post date:** [December 9, 2019, 1:20pm UTC](https://forum.bubble.io/t/problem-getting-dev-data-into-live-database/73689/3 "2019-12-09T13:20:15Z")

</div>

LOL! Am I now glad I asked that first question 🙂

That was sooooooo much easier.

Massive thanks for saving me so much time and messing around.

---

<div class="post-metadata">

**Author:** ![JohnMark](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/johnmark/32/42431_2.png) [@JohnMark](https://forum.bubble.io/u/JohnMark)\
**Post date:** [December 9, 2019, 1:34pm UTC](https://forum.bubble.io/t/problem-getting-dev-data-into-live-database/73689/4 "2019-12-09T13:34:03Z")

</div>

> [@Siddhartha](#):
>
> As the data is coming out of Bubble and back into Bubble I don’t get how it would be in the wrong format.

It’s supposed to be the same format. Maybe send a bug report?

---

<div class="post-metadata">

**Author:** ![Siddhartha](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/siddhartha/32/40316_2.png) [@Siddhartha](https://forum.bubble.io/u/Siddhartha)\
**Post date:** [December 9, 2019, 4:41pm UTC](https://forum.bubble.io/t/problem-getting-dev-data-into-live-database/73689/5 "2019-12-09T16:41:59Z")

</div>

I totally agree @JohnMark. That’s what I was expecting.

Luckily @petter came up with a super-easy alternative, which is way simpler and saves me having to export/import 🙂

---

<div class="post-metadata">

**Author:** ![nocodeventure](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/nocodeventure/32/247164_2.png) [@nocodeventure](https://forum.bubble.io/u/nocodeventure)\
**Post date:** [December 9, 2019, 6:17pm UTC](https://forum.bubble.io/t/problem-getting-dev-data-into-live-database/73689/6 "2019-12-09T18:17:03Z")

</div>

Can you mark this topic as solved. Saves me clicking 😃

---

<div class="post-metadata">

**Author:** ![Siddhartha](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/siddhartha/32/40316_2.png) [@Siddhartha](https://forum.bubble.io/u/Siddhartha)\
**Post date:** [December 9, 2019, 6:43pm UTC](https://forum.bubble.io/t/problem-getting-dev-data-into-live-database/73689/7 "2019-12-09T18:43:56Z")

</div>

Sure thing. Sorry about that.

---

<div class="post-metadata">

**Author:** ![nocodeventure](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/nocodeventure/32/247164_2.png) [@nocodeventure](https://forum.bubble.io/u/nocodeventure)\
**Post date:** [December 9, 2019, 6:54pm UTC](https://forum.bubble.io/t/problem-getting-dev-data-into-live-database/73689/8 "2019-12-09T18:54:38Z")

</div>

You are forgiven
