mysqldump_wrokbench数据导出高级选项未满，并且所有mysqldump选项均受支持 [英] mysqldump_wrokbench data export advanced options not full and all mysqldump option support
问题描述
没有全面的支持，也不灵活(WORKBENCH)，仍然没有解决方案....
It's no full support and not flexible(WORKBENCH), still no solution....
我想为数据库中的每个表创建转储脚本. 我正在使用的工作台5.2.47 CE版本... 我检查了 我的数据库和所有表 还有诸如转储存储例程，转储事件之类的选项
I want to create dump scripts of each table in my database.... workbench 5.2.47 CE version i am using... I checked My database and all tables And options like dump stored routines, dump events
在我检查的高级选项中.......
in advanced options i checked.......
add-locks,
complete-insert,
replace,
hex-blob,
disable-keys,
order-by-primary,
create-options,
allow-keywords,
quote-names
问题.
-
如何保存配置设置或我所做的所有上述设置.第二次保存时我只想添加我的设置文件.并创建转储
How I save the configuration setting or all above setting I did..and second time I want to add just my setting file if I save.. And create a dump
如果不存在则创建数据库mydatabase/*！40100默认字符集latin1 */;
使用mydatabase;
CREATE DATABASE IF NOT EXISTS mydatabase /*!40100 DEFAULT CHARACTER SET latin1 */;
USE mydatabase;
.............我想跳过或排除表单转储脚本，但是工作台中没有选项，因为在mysql命令中有--no-create-db, -n并用于删除USE mydatabase删除选项为--databases
..................This one I want to skip or exclude form dump scripts but there are no options in workbench as in mysql command is there --no-create-db, -n and for remove USE mydatabase remove option as --databases
我需要的所有mysqldump选项都不可用.....
All mysqldump options are not available which I need.............
上述问题的任何解决方案或工作台中的任何自定义创建选项... 谢谢.
Any solution for above questions or any custom create options in workbench... Thanks..
推荐答案
我刚刚遇到了类似的问题，并发现了以下添加选项的方法. 我的环境是:
I have just met similar problems and found the following way to add options. My environment is:
- Windows 8/64位
- MySQL Workbench 6.08 (您可以根据您的系统(例如Linux)调整步骤)
- Windows 8/64bit
- MySQL Workbench 6.08 (you may adjust the step according to your system such as Linux)
首先，关闭MySQL Workbench
First, close MySQL Workbench
在文件夹中: C:\ Program Files(x86)\ MySQL \ MySQL Workbench CE 6.0.8 \ modules 有很多python文件，有一个名为
In the folder: C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.8\modules there are many python files, there is a file called
- wb_admin_export_options.py ，这是Python源代码，其中包含 另一个同名文件
- wb_admin_export_options.pyc ，它是已编译的Python文件.
- wb_admin_export_options.py which is Python source code and there is another file with same name
- wb_admin_export_options.pyc which is a compiled Python file.
编辑步骤
将2重命名为wb_admin_export_options.pyc-org以避免该程序
阅读旧的选项列表，如果有任何
，请复制1.
问题
rename 2 into wb_admin_export_options.pyc-org to avoid the program
read the old option list and make a copy of 1 in case there is any
problem
如果出于UAC原因在Window中，则以管理员模式运行代码编辑器. 打开wb_admin_export_options.py
run your code editor in Administrator mode if in Window for UAC reason. Open wb_admin_export_options.py
注意:您将看到mysqldump的选项列表，该列表显示在 工作台->管理[选项卡]->高级选项... [右上角的按钮]
Note: You will see the option list for mysqldump which is appear in Workbench->Administration[Tab]->Advanced Options...[button on the top right]
有关编辑文件的注意事项
在列表中添加与源代码类似的所需选项，例如: 右括号附近的true为false表示默认值(默认为选中或取消选中)
Add the option you need in the list similar to the source code, eg: The true of false near the closing bracket means default value (check or uncheck by default)
"create-options":[在CREATE TABLE语句中包括所有特定于MySQL的表选项."，"TRUE"]，
"create-options":["Include all MySQL-specific table options in CREATE TABLE statements.","TRUE"],
再次打开MySQL Workbench，它将读取更新的选项列表，并让您选择.
Open the MySQL Workbench again and it will read the updated option list and let you choose from.
希望获得帮助.
这篇关于mysqldump_wrokbench数据导出高级选项未满，并且所有mysqldump选项均受支持的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
