Move all data from baserow.io --> self-hosted (and vice versa)

I’ve started using Baserow via the hosted app provided by Bram and the team on Baserow.io.

I’d now like, instead, to use the self-hosted version so we have direct database access.

Is there an automated way to do this? … I couldn’t find answers searching for “migration to self-hosted” and similar terms.

Of course, it might also be useful for some folks who are fed up with self-hosted to know how they can migrate their Baserow data to baserow.io.

Thanks for any input! Continued best wishes to this productive team doing important work.

1 Like

Hi @bfranklin, this is certainly possible! A while ago we’ve introduced database export/import capabilities. This is a command line feature a the moment and in the future this will also become available via the web-frontend.

For now, I can help you with the migration by creating an export on the hosted version. You can then use that to import your data into your self hosted instance. The downside is that you need to have some technical skills and be comfortable with the command line to import your data.

Let me know if this is something that you would like to do. Then we’ll move the discussion privately, verify ownership of the data, create the export and provide instructions on how to import.

1 Like

HI, I just joined Baserow. I am now using the free version but plan to upgrade to use the hosted Saas Baserow. I also would like to know how to transfer all the data I put into Saas Baserow to the self hosted Baserow with just one click because I have no technical knowledge in IT. I do see the export and import buttons but it seems like I have to do them one at a time, what if I have over 100 tables I want to export and import to self-hosted Baserow, how could I do this with just 1 click?

Hi @kev_z, at the moment we can manually help you with the migration from baserow.io to a self-hosted environment, but in the next, 1.29 release, we’re going to launch a feature so that you can do it yourself.

That sounds great and reassuring. Thank you.

Hi there, maybe I’m missing it but I cannot find this feature in my account (?) I want to move my database from the SaaS-version to our self hosted baserow. Could someone please help me where I have to look? I checked the knowledge resources but the way described there does not work for me since I cannot identify anything that looks remotely like a “export database button”. Thanks!

Hey @flow, you need to export a workspace as described here: Export a workspace :slightly_smiling_face:

I can furthermore add that the import into another SaaS instance seems to work! It is the import into the self hosted instance which fails

Hey @olgatrykush, many thanks! I was somehow just to blind to see it. I could download the entire workplace without problems today! On the other hand: the import into my self-hosted baserow fails: when I upload the structure with the data it stops at 4% without a specific error. When uploading only the table structures it says something about “bad signatures” (?) I found someone with a similar problem and also asked for help there: Any ideas why the import is not working while the export is? - Technical Help - Baserow

Hi @flow, so you were trying to import your workspace from SaaS to self-hosted, correct?

yes, this is correct! I already de-activated the “Verify import signature” feature in my account. I still need help here urgently :slight_smile:

Hi!

Can you provide logs from your deployment?