Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
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:… – Rahul Jun 3 '13 at 9:56
up vote 20 down vote accepted

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

share|improve this answer

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

share|improve this answer

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

share|improve this answer

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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