Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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: blog.cuelogic.co.in/… –  Rahul Jun 3 '13 at 9:56
add comment

3 Answers

up vote 15 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
add comment

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
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

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.