Announcement

Collapse
No announcement yet.

list fields from project or app

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • list fields from project or app

    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 !!! :-(

    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.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #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

      Comment


      • #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.
        Albert Drent
        aducom software netherlands
        scriptcase partner, reseller, support and (turn-key) development
        www.scriptcase.eu / www.scriptcase.nl

        Comment


        • #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

          Comment

          Working...
          X