blocks|key|1776709|text|尝试phpMyAdmin的导出功能。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1776710|我认为也有可能将数据库文件从一台服务器复制到另一台服务器，但我目前没有可用的服务器，所以我无法测试它。|1776711|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/PhpMyAdmin^0|2|A|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

Try the export function of <a href="http://en.wikipedia.org/wiki/PhpMyAdmin" rel="nofollow">phpMyAdmin</a>.

I think there is also a possibility to copy the database files from one server to another, but I do not have a server available at the moment so I can't test it.

blocks|key|1776720|text|在MySQL工作台的顶部菜单中，单击数据库，然后单击forward+engineer。在将显示给您的选项菜单中，确保设置了"generate+insert+statements+for+tables“。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1776721|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In the top menu of MySQL Workbench click on database and then on forward engineer. In the options menu with which you will be presented, make sure to have "generate insert statements for tables" set.

blocks|key|1776737|text|在MySQL工作台6中，随着“服务器管理”选项卡的消失，命令已经被重新定位。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1776738|现在，当您打开标准服务器连接时，您会在"Management“部分下找到"Data+Export”选项。|1776739|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

In MySQL Workbench 6, commands have been repositioned as the "Server Administration" tab is gone. 

You now find the option "Data Export" under the "Management" section when you open a standard server connection.

blocks|key|1990592|text|MySQL+workbech中有数据导出选项|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1990593|​|1990594|📷|atomic|offset|length|1990595|1990596|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/9cbcbf73a35313932a2f0acbad80ed1a.png|imageAlt^0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@$G|V|H|W|1|X]]|A|$]]|$1|I|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q|R|-4]]]]

there is data export option in MySQL workbech

<img src="https://i.stack.imgur.com/wKeGe.png" alt="enter image description here">

blocks|key|1990613|text|令人惊讶的是，stored中的data+Export不只是数据，事实上，只需单击几下，它就可以为整个数据库(包括视图、存储过程和函数)生成MySql脚本。如果您只想要脚本而不想要数据，只需选择"Skip+table+data“选项。它可以生成单独的文件，也可以生成一个独立的文件。以下是有关该功能的更多详细信息：http://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-data-export.html|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1990614|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-data-export.html^0|4C|2O|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Surprisingly the Data Export in the MySql Workbench is not just for data, in fact it is ideal for generating SQL scripts for the whole database (including views, stored procedures and functions) with just a few clicks. If you want just the scripts and no data simply select the "Skip table data" option. It can generate separate files or a self contained file. Here are more details about the feature: <a href="http://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-data-export.html" rel="nofollow">http://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-data-export.html</a>

blocks|key|1776863|text|在mysql工作台中插入数据，然后按照说明执行，它将为所有表数据生成server>>>>>>export语句，每个表都将为其包含的所有数据生成.sql文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1776864|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

in mysql workbench server>>>>>>export Data
then follow instructions it will generate insert statements for all tables data each table will has .sql file for all its contained data

I want to take the whole database. Where do I find the database file?

And is there a way to write the whole database with all data to a text file (like the one in SQL Server)?

How to generate the whole database script in MySQL Workbench?

SQL Server

数据库

服务器

MySQL

我想要整个数据库。在哪里可以找到数据库文件？有没有一种方法可以把整个数据库的所有数据都写到一个文本文件中(就像SQL Server中的那样)？

问如何在MySQL工作台中生成整个数据库脚本？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在MySQL工作台中生成整个数据库脚本？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在MySQL工作台中生成整个数据库脚本？
EN