导出数据库结构 [英] export database structure

问题描述

如何通过PhpMyAdmin导出数据库

How can ai export database through PhpMyAdmin

但是我需要将其导出为我在PHP中运行的文件，例如此处.

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.

推荐答案

该方法因您使用的PHPMyAdmin版本而异.

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

选择要导出的数据库，然后单击导出"标签.

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.

确保输出格式设置为SQL，如果您只想复制和粘贴输出，请取消选中另存为文件"字段.

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.

点击开始".

选择要导出的数据库，然后单击导出"标签.

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.

点击开始".

这篇关于导出数据库结构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！