list fields from project or app

Scriptcase 7 Discussion
#1

Hello everyone.
I had just finished entering all the tables and fields in a mysql db locally, create the data dictionary, create all new applications form when the lamp room (use AMPPS) was shut down (crash!) And now I do not recognize most any table in this database.
I’ve tried using the tools available, but I can not retrieve the property.
I need to list ALL of the fields used in a project in some way (pdf, print, txt …) in order to reconstruct all the tables.
The last option I have left is … a pen to copy fields from the data dictionary !!! :frowning:

Greetings to all
Enrico

#2

If your mysql database has crashed then you can try to recover using the recovery tools of mysql. Sometimes a repair works sometimes you have bad luck. If that doesn’t help you will not be able to recover your tables automatically from the dictionary. You have to recreate your tables.

#3

thanks for the reply Albert.
The ‘repair’ mysql command line can not make it to repair the db.
I understand that you can not restore the data dictionary, but my question was whether it is possible to list all the fields in all the forms so that I can rewrite the db beginning.
I had not yet made ​​the backup the db.
hello
thanks
enrico

#4

If you have setup your data dictionary you can go there and open the tables one by one. With cut and paste you can retrieve a lot of the field names. If you don’t have that you need to go to applications you have created (if any…) then you can go to the sql section and extract the fieldnames from there. Otherwise I dunno I’m affraid.

#5

thanks albert.
In fact, I have written all the fields from the data dictionary and I re-created the first db …
Santa patience!
hello
Enrico