A visual database design tool developed by MySQL. It is the successor application of the DBDesigner4 project.

learn more… | top users | synonyms

1
vote
1answer
56 views

Insert all dates from a month into a table

I'm confused. How to get all dates from a month and insert them into a table in a database? I want to do this with a trigger so when I make a period, ex April 01-04-2016 / 30-04-2016, then in table ...
0
votes
0answers
22 views

Mysql workbench dies on a certain query

I'm running MySQL workbench 6.3 CE connecting to Mysql 5.7.11 running ubuntu via an SSH tunnel. When I execute the following queries, the first 3 complete easily, while the last one spins forever. ...
0
votes
3answers
48 views

How to select mutiple values with like clause

SELECT * from table WHERE column LIKE "AAA%" OR column LIKE "BBB%" OR column LIKE "CCC%" I have more than 10 values to select, so it is not appropriate to write like the above example. Is ...
0
votes
1answer
24 views

Can I reference a specific column in a remote table (MySQL)?

I have two databases (MySQL) on two different servers, and one table references a table in the other. However, I am unable to point the reference to a specific column in the remote table for some ...
1
vote
1answer
22 views

MySQL Workbench fails to store password in vault

I am trying to access my SQL server through MySQL Workbench. So I click the + sign to create a new connection. At this point I choose a connection name and enter the hostname, username, and port. ...
0
votes
1answer
37 views

Possible hidden limit reached in MySQL instance

I'm developing a node.js/sails.js application and host my MySQL database on a Google compute engine instance. During load testing it hits some limit at 1300 RPS. The instances hosting the application ...
0
votes
0answers
18 views

MySQL server v5.7 error 2013 and 2006 when system date is changed

I have a problem with my MySQL server v5.7 when I would perform a query and the system date is the current date everything works. But when I change the system date and perform the query again in MySQL ...
0
votes
0answers
30 views

Visual Explain Not working in MySQL Workbench

Is there some trick to getting the Visual Explain feature to work in MySQL Workbench? I am running version 6.3.6 on Windows 7. I've tried simple queries with just one join. I've tried it with complex ...
0
votes
1answer
31 views

Why does this MySQL 5.6 stored procedure not compile with MySQL Workbench?

Why doesn't this MySQL 5.6 stored procedure compile with MySQL Workbench? CREATE PROCEDURE spDataLocationSetActive ( IN driveLetter varchar(1), IN active ...
0
votes
1answer
27 views

Synchronize MySQL database from remote MySQL database

The documentation mentions a sync function, but that function is not available from the Database menu as shown in the screenshots there. Is this functionality available elsewhere? Using reverse ...
0
votes
2answers
29 views

MySQL Workbench doesn't automatically refresh the tables content

I have a database running on localhost and the content of this DB is updated by an app (using Hibernate, for the record). In this order: In Workbench I run a SELECT * to check to DB content I add a ...
1
vote
1answer
22 views

MySQL getting errno: 150 on table creation from Workbench

I'm inexperienced with MySQL and I am trying to build a few tables and getting errno 150 which I believe could be to do with Foreign Keys. Here is my SQL as generated by Workbench. Thanks in advance ...
0
votes
0answers
6 views

rubric for students mysql 5.7 [duplicate]

trying to make a rubric that will return grade percentages for labs ,etc and final grades for a given student using 5.7 and /or the workbench create database rubric; use rubric; create table student ...
0
votes
2answers
38 views

How to observe output from query in Workbench 6.3?

I am just starting to use MySQL Workbench 6.3, and I want to just run simple queries. I've created a table with the appropriate schema and everything, but I can't seem to observe the output from my ...
1
vote
0answers
56 views

Database design in MySQL workbench

After doing some change As Mr Vérace told me here in this question, by changing the id names of each table into table_name_id and using the singular notation, I still need your opinion about this ...
2
votes
1answer
54 views

How to model the relationship between these three tables

This is my first database, it is for a nutritional info meal tracker program. I have created a model in mySql work bench but I'm not sure if I have the relationships right. See image below.. My ...
0
votes
0answers
26 views

Problem creating database and tables from script [duplicate]

I've done a model diagram with Mysql Workbench, when export the SQL script I run it on my MySql on my develpment ubuntu and works fine but when I run it on the production server the scripts fails. The ...
0
votes
1answer
36 views

Execution plan not understanding correctly

I am running a query: SELECT * FROM message where fr_user = 1 ORDER BY created DESC LIMIT 10; Without the LIMIT there would be 170 rows returned where fr_user = 1; I am now trying to understand ...
0
votes
0answers
10 views

mysqlworkbench nasty result grid with text columns

On MySQL Workbench 6.3, when you query a table with text columns that have carrier return \n in it, the Result Grid expands record's height accordingly. In the image, I've reduced the height of the ...
0
votes
1answer
47 views

MySQL workbench alter table is incomplete

I have just upgraded MySQL 5.6 to 5.7 and workbench from 6.2 to 6.3.6 to have the latest and do some modelling. The upgrade went fine and the app runs perfectly but something is different and I can't ...
1
vote
1answer
50 views

mysql workbench migration changed my database. Can I trust it?

I'm migrating a large production database(s) from mysql 5.5 to 5.6. Used Mysql Workbench Migration Wizard which creates a shell script to run on source and taget machines. The process worked well but ...
0
votes
1answer
80 views

MySql Workbench Data Import .csv

Hi I am trying to use to MySql Workbench Data Import facility to import a .csv file (thousands of records). However it stops importing the first 5 records. After studying the .csv file I could see ...
0
votes
0answers
58 views

Column Editing is Disabled. How to Enable?

I am using MySQL Workbench, in order to design an ERD (Entity Relation Diagram). I can make use of indexes, triggers, etc. but for some reason the columns tab, which allows me to add data or just ...
0
votes
2answers
31 views

MySQL Workbench - store a query to apply to various schemas

We have multiple identical schemas. How can I store a query and easily apply it to any of multiple schemas? Bonus points for a drag & drop or point & click method of executing the query. My ...
0
votes
0answers
27 views

How do you zoom in on the Visual Explain of MySQL Workbench?

On MySQL Workbench under Linux, how do you zoom in on the Visual Explain diagram? Clicking on the eye ("Zoom out the diagram") performs a zoom out, then a rectangle (moveable via mouse) permits to ...
4
votes
0answers
69 views

Nothing to do, no schemas or tables selected on export

I'm using MySql Workbench 6.3.6, on Windows 10, which has all updates. I have previously been able to get a data dump from this database. Now I can't get any from any of the schemas I have open in ...
1
vote
0answers
18 views

How to merge MySQL backup files (*.sql) [duplicate]

We have several MySQL backup files of a database in *.SQL format and we want to restore the database by using these files. However, as the sql files contains "DROP TABLE" definitions, running one ...
3
votes
2answers
168 views

How to merge MySQL backup files (*.sql)

We have several MySQL backup files of a database in *.SQL format and we want to restore the database by using these files. However, as the sql files contains "DROP TABLE" definitions, running one ...
0
votes
0answers
106 views

Change MySQL stored procedure 'Database Collation' name

I have imported a DB from Local machine to server machine. While importing the Database, the character set values of the DB are set by system default to "Latin". I have changed the character set to ...
0
votes
1answer
64 views

MySQL CONVERT_TZ returns null

MySQL CONVERT_TZ returns null, if timezone value is in plus. example: select CONVERT_TZ(now(),SUBSTRING(timediff(now(),convert_tz(now(),@@session.time_zone,'+00:00')),1,5),'+00:00'); it returns ...
0
votes
0answers
16 views

How to find out tables related to a certain query?

I need to copy tables that are included in a certain query from one schema to another schema. I do not want to dump all the tables from the old schema to new one, just the ones only required to get my ...
2
votes
1answer
52 views

Migrate a schema structure from one server to another MySQL

We have two Database environment server (Development and Production). Production DB is already being used in Production(means it already has production data etc.). My question is, is it possible to ...
2
votes
2answers
1k views

Connect MySQL workbench with MySQL container

I pulled MySQL container from Dockerhub and it is running on my macbook pro as you can see as follow CONTAINER ID IMAGE COMMAND CREATED STATUS ...
0
votes
1answer
46 views

MySQL Workbench Automatically Capitalized and Reformatted Section of SQL Script

I was editing a SQL script that I was using in MySQL Workbench 6.3. To my surprise, I noticed that one section of the code had transformed into all uppercase. I normally type in mostly lowercase ...
0
votes
1answer
61 views

How to run mysql_upgrade on mysql workbench

Is there anyway to run mysql_upgrade on mysql workbench? Or it can be run only on command line?
1
vote
1answer
36 views

EER Diagram MySQL Workbench

I created a database in MySQL Workbench using Ubuntu. Is there a quick way to get an EER diagram of that database?
0
votes
1answer
321 views

Superclass/Subclass Relationship Implementation in MySQL Workbench ERD Diagram

This is a relational model! Trying to figure out how to implement a 1:1 superclass/subclass relationship in the ERD diagram. I'm new to this so I'm not sure whether I have to type out all the ...
0
votes
2answers
109 views

Does MySQL Workbench lock database during migration process?

I am doing a migration of my database from one server (RDS) to another (localhost) via the MySQL workbench tool. I want to know if during this process my database will be locked for write and read ...
0
votes
1answer
112 views

MySQL very long-running queries

I have a quite large db (800+Mb dump file) that I imported to my local server. It's a Wordpress db from witch I need to extract certain posts. There are around 160,000 posts inside. Currently I'm ...
1
vote
1answer
43 views

Not able to connect to local MySql database “only” when connected to VPN on VM [closed]

Setup: MySql installed on my Mac using Xammp VM installed using VMware Fusion running win XP. I am able to connect to the mysql database through my VM normally. As soon as I connect to a VPN it ...
0
votes
0answers
279 views

MySql Workbench 6.3 error with Server Status on Windows 7

I am using 32 bit Windows 7 Ultimate and MySql Workbench 6.3, with WAMP installation (MySQL5.6). I am able to set connection, and run few SQL queries against test named database. But whenever I ...
0
votes
1answer
45 views

How to create a one to one relationship

DROP DATABASE if exists test; CREATE DATABASE test; USE test; CREATE TABLE A( a1 int not null, a2 int, PRIMARY KEY (a1) ); CREATE TABLE B( b1 int not null, b2 int, PRIMARY KEY (b1) ); How can I ...
0
votes
0answers
18 views

1175 during UPDATE in MySQL Workbench

I have this error in Mysql Workbench when I update table without using key in where clause but update query fire from my Application using connectivity of database surprisingly I have no error . ...
4
votes
1answer
203 views

Alter ON DELETE CASCADE in 1 table

I'm really new to ON DELETE CASCADE. How can I delete child comments when the parent comment gets deleted in a table? Table Schema 'CREATE TABLE `comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, ...
1
vote
1answer
532 views

MySQLWorkbench with MariaDB 10.0 Performance tab not working

I'm using MySQLWorkbench 6.3.3.0 (build 592) and I cannot use the performance tab on a Mariadb10 connection. This is the error I receive: This feature requires MySQL version 5.6.6 or newer ...
0
votes
0answers
23 views

How to stop MySQL Workbench screens from staying on top

I have MySQL Workbench. I am doing multiple things at the same time - when one app is processing or doing something, I am working with another application. Workbench however when it's doing ...
0
votes
0answers
40 views

MySQL. If Then Across two tables print results into third table

So I have 2 spreadsheets on excel. Both containing the same information across different periods. In a third spreadsheet, I have written some formulas to query the first two sheets. The queries look ...
0
votes
0answers
25 views

MySQL import a sql file but login for which is different than localhost db

I have a SQL file which I want to import into MySQL using the command line but get an error saying that the username does not have access to it. The file is too big, like 35GB, so I can't open it and ...
0
votes
1answer
45 views

how to Import MySql Dump file in MySQLWorkBench

I have a MySQL Dump file for few objects of a database and I have to import only one table from that file in MYSQL Work Bench. My question is How can I import a dump file in MySQL Work Bench for ...
0
votes
0answers
22 views

MySQL Workbench Ground To A Virtual Halt

I have been using MySQL Workbench for a while for both backups and to develop a database and associated queries. Over that time I have noticed that it slows noticeably if the SQL Editor has to many ...