I have a huge db that hangs the server if I try to export it, is there a way I can export it without all the data? Only the tables structure.

  • I come across this post as I was looking to export table structure only through phpmyadmin however I wanted to use the export as documentation so I was looking to export it in PDF with foreign key and inter table relation preserved: blog.cuelogic.co.in/… – Rahul Jun 3 '13 at 9:56

In the Export tab for your database, there's a checkbox on the lower right that says Data.

Uncheck it and you should only have the bare structure in your export file.

alt text


With the newer phpmyadmin versions, in the export tab for your database or table click on custom. enter image description here

Under Format-specific options click dump table -> structure enter image description here

  • If I do two separate dumps - one for the data and one for the schema - is there a lot of overlap in terms of what gets outputted? (Logically there shouldn't be, but you can never know for sure.) – posfan12 Nov 4 '19 at 1:03

Select your database or table.

Select the Export tab.

Below Export method, select Custom.

Below Tables, check the appropriate Structure boxes.

Here's a screenshot: enter image description here


There is a checkbox called "Data". Untick it and phpMyAdmin should only return the table structure.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.