MySQL – How to Export Just the Structure of a Database

exportMySQLphpmyadminUbuntu

I use Ubuntu 14.10 and PhpMyAdmin.

I have a 'big' MySQL database, the size is 900MB. I need just the structure of this database, to use it on my local machine. How can I export the structure only?

Best Answer

Since you specifically asked about phpMyAdmin and the previous answers, while correct, are both about doing this on the command line:

Navigate to the database you wish to export. Across the top row of tabs click "Export"

phpMyAdmin export tab

Next, click the Custom radio button

Custom export type radio button

Halfway down the "Format-specific options" area, select "structure" (the default is "structure and data") Structure/Data/Structure and Data export types

Check the other options and press Go to download your .sql file with no data, only the table structure.

Related Solutions

Mysql – How to export thesql database based on a where condition

Using SQL from the mysql command-line:

SELECT * from YOURTABLE
WHERE status=0 and id>20
INTO OUTFILE 'yourtable.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

or using mysqldump with the --where= option:

mysqldump -u youruser -p yourdbname yourtablename --where="status=0 and id>20">yourtable.sql

Using phpMyAdmin you can execute the query in the GUI & click "export" under the resultset.

Mysql – How to restrict MySQL user to not import and export database

I believe phpMyAdmin uses plain SELECTs and INSERTs to import and export the database.

I don't think you will be able to prevent import/export. I don't remember PhpMyAdmin having options to disable those features.

Best Answer

Related Solutions

Mysql – How to export thesql database based on a where condition

Mysql – How to restrict MySQL user to not import and export database

Related Question