Creating schema from a mysql dump?

Seems like you can or can’t. I currently can’t figure out a way.

I have a schema I’ve spent a LOT of time working on as I did the initial application design. It’s how my brain works. Every time I’d think up a feature or use case, in addition to making notes for UX/UI etc, I would immediately make the schema change necessary.

This app is never going to grow to 100’s of thousands of concurrent users. Best case if I knock it out of the park will be thousands of concurrent users and I’m pretty comfortable the entire thing will run on Bubble indefinitely.

But I REALLY don’t want to manually work through the Bubble UI to recreate this data structure. If fact, I’m so averse to doing it that if I can’t figure out a way, I’ll likely give up on Bubble and find something else.

send the structure here and link with edit access to the app, i can go through and add datatypes slowly (im bored :rofl: )

also activate the free trial, and try exporting the app as JSON and use GPT to add in all the datatypes in the same structure as the existing ones (add a few datatypes each with the field type you want manually as examples), then import it back in

Automation via ChatGPTyler.

3 Likes

I spend my idle moments thinking how to automate migration of Bubble to other databases, however there is weirdly the other use case! Mad.

2 Likes

Yeah. I don’t know how often this would be used but it’s the situation I’m in.
The MySQL connector allows queries to the database but the entire build tool knows nothing of the structure.
So EVERY single query would have to be hand written.
Which is making me rethink this.
Tyler isn’t entirely wrong, it’s just hours of effort and not days and truthfully I don’t have to do it all at once.
I only need to create the datatypes as I move along.

It does mean I wouldn’t be able to take advantage of some effective database functions. Specifically triggers.
They are a far easier way of making sure that specific things happen in every possible use case regardless of client.

But that’s not the end of the world.

Do this

And here I was just getting ready to share a link to a sql dump. Lol

Try GPT first then if it doesn’t work then send it + the editor link :rofl: