文件转换-.mwb到.sql文件 [英] file conversion- .mwb to .sql file

问题描述

我有一个.mwb格式的数据库.我想在日食中使用它，所以我需要将其转换为.sql格式.如果有人知道如何使用任何工具来做到这一点.我认为我的sql工作台可以做到这一点，但是不知道如何做到这一点.

I have a database in .mwb format. I want to use it in eclipse so i need to convert it into .sql format. If anyone know how to do that by using any tool. I think My sql workbench can do that, but don't know how to do that.

推荐答案

在菜单中，单击数据库"，然后单击正向工程"(快捷键CTRL + G).

In the menu click "Database" and then "Forward engineering" (shortcut CTRL+G).

更新:

您的.mwb文件是专有格式，它还包含Workbench中图形表示的信息.生成的.sql文件是一个脚本，您的MySQL服务器需要解释该脚本.要创建通过命令行设计的数据库，请在您选择的控制台中编写如下代码:

Your .mwb file is a proprietary format, which also holds information of the graphical representation in Workbench. Your generated .sql file is a script, which your MySQL server needs to interpret. To create the database you designed via command line write something like this in the console of your choice:

mysql -u yourUser -p yourDatabase < yourFile.sql

使用脚本创建"yourDatabase"时可以忽略它.

You can omit "yourDatabase" when you create it with your script.

这篇关于文件转换-.mwb到.sql文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！