Database structure ?

[_Chris_]

My developer needs to see my database structure, without any information in it - how/where do I do that please?

[Ben Stones]

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.

[_Chris_]

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?

[_Chris_]

Re: Database structure ?

Anyone ?

[Ben Stones]

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?

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:

[_Chris_]

Re: Database structure ?

Sorry, missed the email. Thank you, this worked perfectly.

[Ben Stones]

Re: Database structure ?

Sorry, missed the email. Thank you, this worked perfectly.

Glad I could help .