How to export mysql schema from phpmyadmin?

Question

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.

@JNK - not really, it's about the use of phpmyadmin here, more than about the database itself.
i tought stackoverflow was for coding, im not trying to code anything here

Gareth · Answer 1 · 2011-09-15 05:03:59Z

up vote 6 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

Gareth
4,88551534

answered Jul 28 '10 at 1:39

feedback

maschka · Answer 2 · 2010-07-28 01:37:33Z

up vote 0 down vote

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

answered Jul 28 '10 at 1:37

feedback

2 Answers