如何在MySQL Workbench中生成整个数据库脚本? [英] How to generate the whole database script in MySQL Workbench?
问题描述
我想获取整个数据库.在哪里可以找到数据库文件?
I want to take the whole database. Where do I find the database file?
有没有一种方法可以将包含所有数据的整个数据库写入文本文件(如SQL Server中的文件)?
And is there a way to write the whole database with all data to a text file (like the one in SQL Server)?
推荐答案
Q#1:我猜想它在您的MySQL服务器上? 问题2:是的,这是可能的.您必须通过服务器管理建立连接.您可以在其中克隆任何表或整个数据库.
Q#1: I would guess that it's somewhere on your MySQL server? Q#2: Yes, this is possible. You have to establish a connection via Server Administration. There you can clone any table or the entire database.
由于提供的链接不再有效,因此这是 SO answer 概述了在Workbench中创建数据库备份的过程.
Since the provided link is no longer active, here's a SO answer outlining the process of creating a DB backup in Workbench.
这篇关于如何在MySQL Workbench中生成整个数据库脚本?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!