Copy specific rows (from All Users table) from development database to production (live) database without overwriting

sinha.raunak · 2025-03-31T20:03:31.393Z

Hi, I have a bubble webapp which went live a week ago. Like all apps, I have a dev table & a prod (live) table called All Users (which contain the users). After deploying the webapp for the first time, I sent out the webapp link for some users to register. Unfortunately, I might have sent the wrong link (with version-test) to some users - who registered, but their data landed in the dev database.

At this point I have 1 user’s data in prod (live) database and the other 3 user data in dev database.

I want to copy the All Users table (3 rows) to prod (live) database, but I do not want to overwrite the data for the 1 user in live database (live database has 1 row with 1 user’s data). I think I can use “copy & restore” but i fear that it will overwrite (delete the data for 1 user) and overwrite the 3 rows from the dev database.

Maybe I am getting this all wrong, but can someone help with the correct steps to follow to achieve this?

javier6 · 2025-04-01T01:44:53.072Z

I’d download the user table as a CSV on dev and reupload it on Live. Then you’ll have to make those users reset their passwords.

sinha.raunak · 2025-04-01T08:46:55.821Z

tysm though i have a follow up question. If I use the “copy & restore” process to migrate the 3 users in dev database to live database, I understand it overwrites the 1 user i have in live database.
Question - in this case does it copy over the passwords as well (for the 3 users in dev database)?

I’m asking as I’d rather request the 1 user in live database to sign-in again as against asking the 3 users (in dev database) to change passwords. Sorry just want to fully understand my options here.

thanks