How to export mysql schema from phpmyadmin?

--------------------------------------------------
Rise to the top 3% as a developer or hire one of them at Toptal: https://topt.al/25cXVn
--------------------------------------------------

Music by Eric Matyas
https://www.soundimage.org
Track title: Over Ancient Waters Looping

--

Chapters
00:00 How To Export Mysql Schema From Phpmyadmin?
00:17 Answer 1 Score 0
00:28 Accepted Answer Score 34
00:43 Answer 3 Score 24
00:49 Answer 4 Score 24
01:03 Thank you

--

Full question
https://superuser.com/questions/168595/h...

--

Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...

--

Tags
#mysql #database #export #phpmyadmin

#avk47

ACCEPTED ANSWER

Score 34

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

ANSWER 2

Score 24

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

ANSWER 3

Score 24

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:

ANSWER 4

Score 0

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