export database structure

Question

How can ai export database through PhpMyAdmin

but I need to export it as file that I run in PHP , such as here.

the reason I need it this way is because I can create stuff faster this way.

Solution 1

The method varies depending on the version of PHPMyAdmin you're using.

Older Version

Select the database you want to export and click on the 'Export' tab.

Click 'select all' above the table list, and uncheck the 'Data' field on the right hand side of the page.

Make sure the output format is set to SQL, and uncheck the 'Save as File' field if you just want to copy and paste the output.

Click 'Go'.

Newer, AJAX Version

Select the database you want to export and click on the 'Export' tab.

Select the 'Custom' option, click 'Select All' above the list of tables that appears.

Select the 'Save as File' option if you want to save the output, otherwise leave it as-is to copy and paste it.

Under 'Format specific options', select the 'Structure' option.

Click 'Go'.

Solution 2

Uncheck the data column once you've selected Custom - display all possible options :

Solution 3

Click the database you want to export and then go to the 'export' tab. Choose how the export should work with all of the checkboxes and then make sure the 'save as file' box is checked. Also select the file format and compression settings you would like.

Comments

[homerun]

i have done this but i couldn't find the right format as i need , it's export all the sql engine as default , but that's doesn't work for me.

[Michael Dillon]

What part isn't working for you? Is it over-writing tables that already exist? Is it not importing?