Best way to recreate databases

I created my initial databases mainly with phpmyadmin and I’m wanting to convert them all into wappler created if I deleted all my database and then in wappler recreated then with the same names etc would I need to rebind all my queries in server actions etc still or will they must start using the new database structure

It shouldn’t matter what you created your database in. For example all my databases are created and maintained in Navicat yet I still have full access to them in the Wappler DB manager as well.

What are you trying to do exactly? Are you moving servers?

Well I created a table in phpmyadmin but then creating a table in wappler and referencing the phpmyadmin one throws a error also phpmyadmin ones don’t transfer to my live server

I’m just hoping that aslong as I recreate it all in Wappler with the same names for the tables and columns that the query will use the new ones. There will be a few area where I change enums to archer and I expect to have to make changes here in my server action but the stuff that remains the same I was hoping would remember the bind

Yes, if everything is named identical it should work just fine. You may have to change your DB connection settings to your new ones though.

But yes, if everything is named exactly the same for tables and columns you should have no problems. Or very little anyways. :wink:

1 Like

That’s great thanks for the info much appreciated just wanted to confirm before deleting and recreating will be much easier to do once everything is in Wappler :slight_smile:

How would I get back to the default database I thought removing the back up would be fine but the tables structure is still there just grey I see they are in a json file is this safe to delete or will it not auto create this?

db.json

Edit never mind the moving of the backup did work it was just the database tab didn’t fully refresh for some reason until I hit backs then advanced :slight_smile: