How to export mysql schema from phpmyadmin?
85,357
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.
Solution 2
With the newer phpmyadmin versions, in the export tab for your database or table click on custom.
Under Format-specific options click dump table -> structure
Solution 3
Select your database or table.
Select the Export tab.
Below Export method, select Custom.
Below Tables, check the appropriate Structure boxes.
Related videos on Youtube
Author by
fazpas
Updated on September 17, 2022Comments
-
fazpas over 1 year
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.
-
Rahul almost 11 yearsI 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/…
-
-
posfan12 over 4 yearsIf I do two separate dumps - one for the data and one for the schema - is there a lot of overlap in terms of what gets outputted? (Logically there shouldn't be, but you can never know for sure.)
-
Zaki Mohammed almost 4 yearsThanks worked for me!