I have a project setup with basic db tables for users, roles, and seo. Is it possible to copy that database or apply the changes stored in Wappler to a blank database in a different project?
I just want to be able to not have to manually make the basic tables I will use in multiple projects.
You can just export a database dump/backup using a database tool like mysql workbench (depending on your database type) and then import it in your other database.
Not sure if you’re able to help with this since it’s not directly Wappler, but I’m getting
Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation
when trying to import into a different db.
The structure is really basic right now but I just wanted to test how it works.
I have a Digital Ocean database cluster where I am trying to transfer from “template” to “test” in MySQL Workbench.
I export just the structure from “template”
and I think it all works right
but when I go to import it
I get errors
not sure how to fix it and I didn’t want to mess around and maybe mess up anything.
Also, do I want to copy the wappler_migrations to a different db or no?
