MySQL Workbench : MySQL's Open Source GUI for Assisted DB Administration

learn more… | top users | synonyms

1
vote
0answers
122 views

MySQL Workbench and Optional Many's

I have used workbench before to make databases code wise and I just started looking into its EERD functions. I created a small database for a test project and found some odd things about how MySQL ...
2
votes
1answer
717 views

creating table syntax error 1064

I'm using workbench to create a table. This script is giving me a problem. It is saying that there is a syntax error new '). DROP TABLE IF EXISTS `waitronmain`.`managers` ; CREATE TABLE IF NOT ...
1
vote
1answer
284 views

ERROR: Error 1005: Can't create table 'progetto.museo' (errno: 121)

I've found on the web that: You will get this message if you're trying to add a constraint with a name that's already used somewhere else and If the table you're trying to create includes a ...
3
votes
2answers
2k views

How to search for a specific column name in all the tables in MySQL Workbench?

In MySQL Workbench, is it possible to search for a specific column name in all the tables? (Writing the string to look for in the field at the top right does nothing). Thank you.
2
votes
2answers
4k views

how to add trigger in mysql workbench, without UDF, using EER design

I have designed a simple database using EER in workbench. However, i want to have a minimum value for the attribute salary (compared with min_value attribute from artist table). Here is the schema: ...
0
votes
1answer
64 views

What would be the first things you do to find out about an MYSQL environment you are taking over?

I am new to DBA role, and wanted to know if there was any commands (or free software) that come with Mysql 5.5 (master/slave/slave) replication to quickly get familiar with the database, and also ...
1
vote
2answers
920 views

How do I use MySQL Workbench to edit an existing, in-production database?

This is basically a repost of this question, which didn't give a satisfactory answer. I'm finishing up the design of a database using an EER diagram. I now want to forward engineer and import the ...
0
votes
1answer
139 views

MySQL Workbench sync keeps requesting the same changes

I am using MySQL Workbench, and when I try to "synchronize" it with my remote database, it keeps detecting some changes to make. Specifically, the most recurrent ones are: Dropping foreign keys and ...
2
votes
2answers
5k views

Connecting to AWS RDS DBInstance with MySQL workbench

I am trying to evaluate AWS RDS to use as possible DB for our application. I have created a DBInstance(micro) and added IP security group. I am able to connect to the DBInstance from Xampp shell ...
0
votes
1answer
354 views

MySQL Workbench table organisation

Well, I'm interested is there a way to (someway)automatically organize database tables when you make EER Model from existing database. In my schema I have 30(and something) tables and 50(and ...
3
votes
1answer
66 views

Way to add referencing and referenced entities of a specific entity in E-R Diagram MYSQL

Is there any way to add entities that are referencing a specific entity in an E-R Diagram. I have a database containing 400 tables. I want to see a view containing a specific entity and its ...
1
vote
2answers
259 views

SQL queries break our game! (Back-end server is at capacity)

We have a Facebook game that stores all persistent data in a MySQL database that is running on a large Amazon RDS instance. One of our tables is 2GB in size. If I run any queries on that table that ...
1
vote
1answer
200 views

Should this be an identifying relationship or not?

Well I've attached the image to explain what I need to know: I thought it was supposed to be an identifying relationship, but now I kinda thought maybe it wasn't? The thing is the user won't ...
1
vote
1answer
3k views

MySQL Workbench is not finding MySQL service?

I set up a local MySQL server, currently with no databases. I'm trying to create a new server instance profile in MySQL Workbench to manage the server, and during the Create New Server Instance ...
1
vote
2answers
4k views

MySQL Workbench, how to refresh EER diagram?

I'm using MySQL Workbench to design my MySQL database and model how entities would look like and how they would relate to each other. Now, sometimes I use Doctrine ORM. When using Doctrine ORM, I ...
0
votes
1answer
1k views

Print table documentation with comments?

I have a MySQL database, and I have used MySQL Workbench to insert text into the "comment" fields of many of the columns and tables; the plan was to have the documentation stored in the database. ...
4
votes
2answers
9k views

How to view contents of table in mysql-workbench

Hi everyone am fairly new to mysql, I made a java program that stores data in mysql database. I am using this tool called mysql-workbench that can create databases, tables and much more. What I wanted ...
1
vote
1answer
102 views

MySQL Database Temporarily Compromised?

Two days ago, I had connected to my ClearDB test server with MySQL workbench. I had left this workbench open and when I had checked it today, there were two new schemas named "test_justin" and ...
3
votes
1answer
634 views

MySQL Workbench model/source synchronize issue

I've been looking all over for any description of an issue like this and I haven't found anything so far. I am trying to update my MySQL database using MySQL Workbench (5.2.40 CE). I am using the ...
2
votes
2answers
3k views

MySQL Workbench copies Schema, but not data, from SQL Server 2008

I need to copy/migrate a database from MSSQL (SQL Server 2008) into MySQL. I am using the MySQL Workbench kit, and work through the process of the Migration. Each respective DB user has full access, ...
2
votes
3answers
2k views

Memory problems with MySQLWorkbench

I'm currently using MySQLWorkbench 5.2.40 on my PC (8GB rRM, Corei7). I have a table with almost 1.5 million records, which I need to visually look over. Surprisingly, the total size does not exceed ...
1
vote
1answer
262 views

Primary key type change not reflected in foreign keys with MySQL Workbench

I have a problem with MySQL Workbench and primary/foreign keys. I have some tables with PKs involved in relationship with other tables. If I modify the type of the PK, the type of the FK doesn't ...
2
votes
2answers
636 views

MySQL Editor Hangs on attempt to Launch

I have just downloaded the latest Community Installer (5.5.27) along with the MySQL WorkBench (5.2.41). I clicked OK on all default settings on setup. When I try to "Open a connection to start ...
1
vote
1answer
126 views

How export a database based in a primary key of a table?

So, I'm trying to export all the DB structure of my MySQL db. Attached is my DB structure, I have more then this, but I want these tables only. Basically Tools relate to Factsheets and Factsheets ...
2
votes
1answer
2k views

MySQL Workbench asking for password

I am trying to set MySQL server on my Windows 7 64 bit machine. I have downloaded MySQL server and MySQLWorkbench. I have started mysql service by command C:\> net start mysql as suggested ...
2
votes
1answer
1k views

Set-up MySQL Server on Windows 7 64-bit

I am trying to install MySQL Server on my Windows-7 64-bit machine. I have downloaded MySQL Server Community Edition and MySQL Workbench. I am trying to start a new Server Instance from Workbench. I ...
0
votes
1answer
278 views

MySQL ODBC + setting up a DSN on windows + MySQL Workbench

Sorry for the vague title, but here's my problem. I connect to my database in MySQL Workbench using the following method : TCP/IP over SSH However, when I try to set up the DSN on Windows 7 via: ...
1
vote
2answers
2k views

mysql workbench *reverse engineer* is not connecting tables graphically. How to fix?

I thought that previously when I reverse engineered databases, mySql Workbench figured out the relationships from the id names and connected the tables leading to an awesome ERD, even when the foreign ...
2
votes
1answer
597 views

Named Parameters in MySQL Workbench Queries?

In OpenOffice / LibreOffice I'm used to added :prefixed-parameter-names to my queries. For example: SELECT name FROM table1 WHERE id = :id Is there a similar functionality in MySQL Workbench?
1
vote
1answer
881 views

--local-infile=1 using MySQL Workbench?

When I start the MySQL bash client, I have been starting it with --local-infile=1 so that I can import data from a .csv file. Is there any way of doing this within MySQL Workbench?
2
votes
3answers
6k views

How can we add BOOLEAN datatype in mysql query browser?

I am trying to add a BOOLEAN column using EDIT TABLE in mysql workbench, but it automatically changes to TINYINT on applying changes. How can I get the column to be BOOLEAN?
1
vote
1answer
1k views

MySQL Workbench ERROR 1064

I have a problem with my database. I have created the model and now I want to sync it with my database on my WAMP Server (local) but it keeps giving me an error. I searched for the cause of the ...
4
votes
2answers
789 views

Is my EER Diagram correct? Why use relationships?

This is the first time I've made an Entity Relationship Diagram (ERD) for MySQL. Prior to this, I would never create relationships between tables, I would simply create the tables in MySQLAdmin and ...
1
vote
1answer
214 views

Referring to super parent or as a separate entity?

I have this person table as super parent, id firstname lastname email telephone ... ... and user table as a child id person_id (FK) password username screenname ... ... They must be 1:1 ...
1
vote
2answers
918 views

Client to use the slave when the master is down in MySQL replication

Is it possible for the client to use the slave when the master is down in mysql replication? I have already setup a simple mysql replication having a master and a slave. The client connects to the ...
3
votes
4answers
5k views

Can't connect to MySQL database over SSH with Workbench

I'm trying to connect to my database via SSH tunneling from one of our web app servers with MySQL Workbench. Here's the basic config; note that I changed some values in the screenshot for security ...
2
votes
1answer
3k views

MySQL Workbench 5.2 edition - Unable to establish the connection

I have installed MySQL (mysql-workbench-gpl-5.2.37-win32.msi ) which is a Windows Installation Workbench. Couple of times, I have done re-installation on my computer. Now, I am not able to establish ...
2
votes
1answer
1k views

MySQL Workbench - Create new server instance error

When attempting to create a new server instance I get an error at the 'Test Settings' step of the creation wizard. The error: What check_admin_commands/local Operation failed: ...
5
votes
1answer
2k views

MySQL Workbench Database Sizes

I'm trying to find the total size on the hard disk that all of my MySQL Workbench databases are using. Does anyone know of an easy way to figure this out? If nothing else, the default location ...
4
votes
2answers
2k views

Incremental backups using MySQL Workbench

I need to start doing regular backups of my databases, and I'd like them to be incremental; that is, only backing up the tables that have been changed. I use MySQL Workbench, and I've used the export ...
1
vote
2answers
1k views

I cannot access local database on terminal (MAC)

I have access to my databases on phpmyadmin and mysql Workbench on my local computer but I have a problem when I try to access the server using Terminal. Originally, I had uploaded the databases on ...
0
votes
1answer
2k views

SQL keyword difference between MySQL and Oracle 10g?

Good afternoon, Are there differences between Oracle 10g and MySQL with the CREATE, ALTER, DROP, REF, PRIMARY KEY, FOREGIN KEY and attribute variable type keywords? The reason I ask, is I'm planning ...
2
votes
2answers
8k views

MySQL tables do not show up in the phpMyAdmin and MySQLWorkbench

I just setup the phpMyAdmin and I have this problem: When I login, I can't see any tables. I had tried this with MySQLWorkbench and I got the same result. Any suggestions ?
8
votes
6answers
9k views

Alternatives to MySQL Workbench

I've been running into some problems with MySQL Workbench that I'm not sure will be able to be fixed (namely, what appears to be an old bug that may have resurfaced), so I'd like to be able to find a ...
2
votes
2answers
545 views

MySQL Workbench Loses Saved Connections

I've been using MySQL Workbench as my go-to management application for quite some time. However, recently (namely, in my most recent install), it will every so often lose the saved connections I've ...
1
vote
1answer
608 views

MySQL Workbench: Custom fields for Relationships

I have to manage an existing DB, created "manually" without mysql-wb. I want to draw the printable ER diagram. When I create a relationship, workbench creates its own external key fields. How can I ...
9
votes
5answers
23k views

Trying to use MySQL Workbench with TCP/IP over SSH - failed to connect

I can't connect using TCP/IP over SSH connection in MySQL Workbench from a PC. What's going on? I created a MySQL 5.1 database on an Ubuntu server mysql.myhost.com. I can access it locally. MySQL ...
2
votes
4answers
2k views

Connect to a remote MySQL Server from a dynamic IP address

My ISP at home uses a dynamic IP address. I'm trying to access a MySQL database at work. How can I connect to it (using MySQL Workbench)? I could grant all privileges to % so that any IP address will ...
3
votes
2answers
2k views

Creating and editing my.cnf by MySQL Workbench?

I just installed MySQL Server and MySQL Workbench on a clean Snow Leopard MacBook. I hooked up Workbench with the server and was able to start the MySQL Server from within the Workbench. I enter the ...
3
votes
1answer
6k views

Error creating foreign key from MySQL Workbench

I'm trying to synchronize schema changes from MySQL Workbench to my database. I'm getting the following error when it tries to create a foreign key: Executing SQL script in server ERROR: Error 1005: ...