mysql-workbench

MySQL Workbench 5.2. Load INSERTs from a file

How can I load INSERTs from a file in MySQL Workbench 5.2? I have tutorial for 5.0, but for 5.2 it is not working ...

Error in MySQL Workbench Forward Engineered Stored Procedures

I am using MySQL Workbench (5.1.18 OSS rev 4456) to forward engineer a SQL CREATE script. For every stored procedure, the automatic process outputs something like: DELIMITER // USE DB_Name// DB_Name// DROP procedure IF EXISTS `DB_Name`.`SP_Name` // USE DB_Name// DB_Name// CREATE PROCEDURE `DB_Name`.`SP_Name` (id INT) BEGIN SELECT *...

I need sample of MySQL Workbench of EER diagram?

Any one have sample EER diagram of MySQL Workbench? ...

anyone get mysql workbench 5.2 to work with mamp?

i cannot get mysql workbench 5.2 to work. i have mamp and mamp pro installed and running and no matter what type of connection i try it just wont connect. what can i do? i have a mac with snow leopard ...

How to generate SQL Script from MySQL Workbench using Command Line?

Hello! I'm currently using FinalBuilder to create a one-click building n’ generate install, but I faced with MySQL Workbench lack of capacity to generate SQL script from a command line. ...

How to create a new Server Instance on MySQL Workbench 5.2.25 CE

Hi, I've just setup MySQL Workbench 5.2.25 CE on a PC with windows XP service pack 3 When trying to create a new server instance on the localhost, Workbench ask me for a root password regarding the service. I've have not been asked during the setup process to enter a password for root... leaving the password blank (or even inputting a ...

Forward Engineering to SQL Server from MySQL workbench?

Is possible to forward engineer to SQL Server from MySQL workbench? ...

Update scripts with workbench?

Currently I export the old database, search and replace the database names and do:] File -> Export -> SQL Alter script But first is there a way to avoid the database names? As my live database is likely to have a different name then in workbench. Second I encounter many times that the script tries to add foreign keys, but these will t...

Mysql Workbench Reverser Engineering.... Foreign key problem!

Does anyone know how to import foreign keys on the reverse engineering tool on mysql-workbench ? The table is already InnoDB and everything ...

mysql service stops while trying to alter a table

I have mysql 5.1 installed using this: mysql-essential-5.1.49-win32.msi. And also have Workbench installed using this mysql-workbench-gpl-5.2.26-win32.msi On Windows 7 Now my problem that anytime i try to create a new table or alter an exist table, the mysql service stops and workbench gives an error that it can't connect. But before ...

How to alter a table to add a self join relation?

I have a table called "Users" it contain some fields such as Id, ParentId, Name. What I want is to alter this table to add new self join relation so that ParentId link to Id, but ParentId is nullable. I want to write this alter sql statment in mysql without dropping the table. ...

Database Design: Working with SQL Server; Server Management Studio Sucks...MySQL WorkBench Rocks...Alternatives?

Currently I have laid out most of my design in MySQL Workbench. It appears I will be deploying my DB in SQL Server however. So far my experience with Microsoft SQL Server Management Studio 2008 R2 has sucked due to one flaw. When you save your DB Diagram, it creates the tables in the database. I have attempted design in SSMS which sucke...

Connecting Postgres database from MySQL Workbench

Is there any way to connect to Postgres database using MySQL Workbench? I was hoping it could be easy enough, but didn't find any plugin available. ...

MySQL Workbench: After renaming primary key, how to update FKs and relationships...

I am using MySQL WorkBench and came across a problem... I have existing tables in the EER diagram with various relationships setup. I'd like to rename the primary key, which is straightforward... but when I do, the relationships are not updated, and the FK references in other tables show the old name and datatype. I thought at first i...

What do column flags mean in MySQL Workbench?

In MySQL Workbench table editor there are 7 column flags available: PK, NN, UQ, BIN, UN, ZF, AI. PK obviously stands for Primary Key. What about others? ...

How can I add regular expressions to MySQL datafields?

I have the following table: Table Account{ [...] email varchar(100), [...] } and a corresponding regular expression: /^[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$/i How can I use the MySQL model, to link the regular expression to the the data-field "email", so that the regex is accessible to read out through php as well as ...

Close all mysql connections from workbench

Hello I keep on getting the max_user_connections error on mysql What I want to do is close every connection through something like workbench.. Anyone know how, on mysql workbench? Thanks ...

MySql Workbench 5.2 SQL Editor dropdown won't populate

I just recently installed mysql 64bit on my Snow Leopard Mac. In MySql Workbench I created several schemas but when I went into the SQL Query window the dropdown is not being populated. I tried googling for an answer but I was not able to find a solution. I have attached a link to a screenshot. image: http://bit.ly/cYpilT ...

What's the best way to design an Entity / Relationship Model?

For example if I have 20 tables, I have to design it by section? i.e CLIENT (id, name...) -- orders -- ODERS_DETAIL(id, products...) . . . lives --- ADDRESS(...) Or I can use The MySQL Workbench EER Model (To me, it looks like the Pysical Model)? Or like this: Data Modeling Levels ...

Build Automation & MySQL Workbench Scripting: Forward Engineer SQL CREATE SCRIPT

I'm currently looking into automating a software build process that includes a database schema defined in MySQL Workbench. Using Workbench's scripting capabilities, I'd like to open a Workbench document and export its schema as an SQL CREATE script. What I'd like to know is if there is a function that exports the entire schema in one s...