Restoring the MYSQL Database structure from Wappler json file

,
#1

Hi there,

I lost a project from one of my hosting that had the MYSQL database fully up and working and then it decided to go down and I’ve been unable to recover the database. Nightmare! Moved suppliers now.

However I have noticed in the Wappler folder there is a json file within the database file. When I open it in notepad all my database structures are there!!! There is no data but thats not a problem.

How do I get this file to be uploaded into phpmyadmin into the mysql database?

Thank you!

#2

Hi.
The JSON schema you see is mostly for use within Wappler.
You will have to write some program to convert that into SQL.
You can try options like https://blog.sqlizer.io/posts/convert-json-to-sql/, or build your own.