How to export mysql schema from phpmyadmin?

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.

Solution 1:

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

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