Announcement

Collapse
No announcement yet.

Database structure ?

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

  • Database structure ?

    My developer needs to see my database structure, without any information in it - how/where do I do that please?
    http://www.eUKhost.com

  • #2
    Re: Database structure ?

    Hi Chris,

    If you are running cPanel you can see your database structure (tables, columns, rows, etc.) from phpMyAdmin. You will find this in under the Databases section after you have logged into cPanel.

    Comment


    • #3
      Re: Database structure ?

      Thanks for the quick response Ben, how do I email that, just the structure only, without any information in it to the developer please?
      http://www.eUKhost.com

      Comment


      • #4
        Re: Database structure ?

        Anyone ?
        http://www.eUKhost.com

        Comment


        • #5
          Re: Database structure ?

          Originally posted by _Chris_ View Post
          Thanks for the quick response Ben, how do I email that, just the structure only, without any information in it to the developer please?
          Hi Chris,

          If I understand your question correctly, you want to list the structure of a particular table? If this is what you want to do, you can do this within phpMyAdmin.

          From phpMyAdmin, go to the particular database you need to export the structure of (make sure you select the database itself from the left pane, and not a particular table). From the top, select the "Export" menu item, and from the next page select the "Custom" Export Method. You'll see the following different options:
          • Table(s): All tables will be selected for export by default. You can select or deselect tables from here if needed. To deselect tables from the list, hold down the Ctrl key. If you don't see these options, you are exporting an individual table and are in the wrong section of phpMyAdmin.
          • Output: This can be left as-is
          • Format: You might want to change this to a format like PDF, Microsoft Word or OpenDocument Text. If you change the format you may notice the "Format-specific options" change (e.g. changing from "SQL" to "Microsoft Word").
          • Format-specific options: Under the 'Dump table' options, change "structure and data" to "structure" only.

          Hope this helps.

          Screenshots below:

          Select the database:



          Go to Export page:



          Choose Export options:

          Comment


          • #6
            Re: Database structure ?

            Sorry, missed the email. Thank you, this worked perfectly.
            http://www.eUKhost.com

            Comment


            • #7
              Re: Database structure ?

              Originally posted by _Chris_ View Post
              Sorry, missed the email. Thank you, this worked perfectly.
              Glad I could help .

              Comment

              Working...
              X