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
16 views

Fail to connect from MySQL Workbench to remote server

After trying many different suggestions as found in the net, I'm still unable to establish a connection from the Workbench application to the server. Here is a brief list of things I tried: 1) ...
1
vote
1answer
134 views

MySQL schema recovery

Is there a chance to recover overwritten schema or table in a schema? I have accidentally overwritten schema with the back-up from other source.
3
votes
2answers
3k views

Problem with new MySQL Workbench connection

I'm working on Debian 8 and wanted to create database using MySQL Workbench. I did everything in this tutorial, but when I created a new MySQL Connection, the program returned: Failed to Connect ...
0
votes
3answers
530 views

MySQL - Alter Table Fails As Workbench Tries To Create Existing Table

I have been trying to add another column to a table in my database using MySQL Workbench. This generates an 'ALTER TABLE' command which then fails as it fails attempting a 'CREATE TABLE, which it ...
0
votes
1answer
133 views

mysql database migration of schemas with updated data and structures

I am a newbie with MySQL database dumps and am currently trying to work with data migration between a source schema and a target schema. Assuming the source schema is defined by (...
0
votes
2answers
133 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 ...
2
votes
1answer
23 views

Out of range errors while with insert statements

I'm having an issue regarding every third insert line of the database I'm trying to create. Some background, I have a huge .JSON file and used software (sqlizer) to turn it into input statements, ...
1
vote
2answers
64 views

UTF8 Trouble while migrating from MSSQL to MySQL with MySQL Workbench

I am tasked with migrating part of our database from an on-site MSSQL server to an Amazon RDS MySQL. This will be my first attempt with a database migration, so I am doing a dry run from our MSSQL ...
1
vote
1answer
143 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 ...
0
votes
2answers
243 views

How to create function using another functions mysql

I want to create a function in MySQL using another function but I am getting an error "Explicit or implicit commit is not allowed in stored function or trigger". This is my code: DELIMITER $$ ...
1
vote
1answer
162 views

MySQL Workbench can either Dump or Restore - How Do I Configure To Do Both?

I have previously posted this question on Stack Overflow, but have not solved the problem. Hopefully it is not incorrect to post it here in the hope that it will be seen by a some different ...
3
votes
3answers
13k views

Missing “MSVCR120.dll” during the Installation of MySQL Workbench 6.3 CE

When I install MySQL Workbench 6.3 into my Windows 8.1, I encounter the following System Error : I already tried to redownload and reinstall the program but this error dialog appears every time. ...
0
votes
1answer
1k views

ClearDB Granting Created User Access

I added the ClearDB addon to Heroku, but upon using the created username to create a new database, the error appeared: Executing: CREATE SCHEMA `androidchatterdatabase` DEFAULT CHARACTER SET utf8 ; ...
0
votes
2answers
2k views

No connection could be made because the target machine actively refused it

I have created a PHP site using MySQL. It works well on localhost. However, when I moved it to a remote server, it stopped working. The error shown is: "No connection could be made because the ...
0
votes
1answer
166 views

What is the optimal number of worker tasks to specify in MySQL Workbench for a speedy migration?

What is the optimal number of worker tasks to specify in MySQL Workbench for a speedy migration? The default is 2. The MySQL server is running on the same Windows machine, installed with defaults. ...
1
vote
1answer
57 views

How to restore database with ib_log0, ib_log1 and ibdata1 files in MySQL

We have a Mysql5.5 running on Windows server 2008 from past 4 years. Recently we have moved ib* files to new locations because of space constraint in c drive. When we started the Mysql it created ...
0
votes
1answer
27 views

Migration MySQL to Cloud Environment replication

I'm having 5 MySQL database server , these 5 server are used for e-business web-server. Now I Would like to move the MySQL database to cloud environment for database continuous running. Recently we ...
0
votes
1answer
12 views

Closed queries re-open when connecting to DB using MySQL Workbench

Using MySQL Workbench latest version (6.3) I've set up an Amazon EC2 connection successfully. Every time I open the connection, I've noticed all queries I did before are being opened, even if I closed ...
0
votes
1answer
860 views

migrate MySQL database with MySQL Workbench CE failed on table with blob data

I am using MySQL Workbench CE to migrate one schema from a server to another, all table is migrated successfully, except one table with blob data. The error message is : Found record bigger than ...
0
votes
1answer
750 views

MySQL output file location - accessing server files

I am running the MySQL Workbench 6.2 CE on Windows7. I have an output table of 200,000 rows and I need to save it. I will have to repeat this task, so I would like to iterate the following code: ...
0
votes
1answer
18 views

Grand read privilege to the user but is not allowed to grant the same privilege to another user?

i am a noob and this is how far i got so far, thanks and also how would you do it if you want to allow user to grant the same privilege to another user. GRANT SELECT ON DATABASE_NAME.* TO USER;
0
votes
0answers
12 views

mysqldbcompare giving Compare table checksum FAIL error

Running mysqldbcompare on two test databases on same server. There is no data discrepancy in any table but showing following message which I'm not able to understand. Any help is appreciated. TABLE ...
0
votes
0answers
13 views

Linked Server Mysql Workbench

Is it possible to use 2 MySql Workbench at a time by connecting it using Linked Server? Or is there any other alternative? By the way, I'm working on a web application with jsp and java.
0
votes
1answer
2k views

How can I get Performance Statistics to work in MySQL Workbench?

I have a complex query that is performing in subsecond time on my laptop, while the same query takes 70 seconds on my production server under no load against an identical schema. The EXPLAIN plan is ...
1
vote
1answer
478 views

Mysql query is very slow

I am developing a website like any other social networking site using mysql. I wish it give people suggestion to my users, and I have implemented this functionality in my application, but It is ...
1
vote
2answers
26 views

MySQL Front - Workbench

We have MySQL Front installed in our server, I can connect to it with no problems, there is a db with tables, everything fine. Now I installed MySQL workbench (client) in the same server, but can ...
0
votes
0answers
62 views

ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xx.xx' (10060)

I'm trying to connect my local MySQL workbench to a 2nd generation MySQL instance on Google SQL platform using the following command on my windows laptop. mysql --host=130.xxx.xx.xx --port=3306 --...
3
votes
0answers
42 views

Online text based game design - Am I linking the databases correctly?

I'm trying to recreate an old game that I used to play that went offline quite some time ago. I'm doing this as a hobby project for myself with the hope that maybe a few hundred people might enjoy it ...
0
votes
2answers
30 views

How to Add AFTER Delete Trigger in My case?

I am Making a Database Management System of Hospital in MySQL WorkBench, and i Want to Make a After Delete Trigger in my case. The scenario is i have two Tables 1) The Patients which are currently ...
0
votes
0answers
33 views

Create a not unique FK in MySQL Workbench

I'm trying to model a database using MySQL Workbench (version 6.3.6, 64 bits, using linux mint). After syncing my model with a MariaDB (running in localhost, version 10.0.25), I discovered that the ...
0
votes
1answer
87 views

Export .MWB to working .SQL file using command line

We recently installed a server dedicated to unit tests, which deploys updates automatically via Jenkins when commits are done, and sends mails when a regression is noticed > This requires our ...
1
vote
2answers
104 views

Recreate a table that was deleted during an ALTER statement (errno: -1)?

For the third time in the past 2-3 weeks I've gotten the following message during an ALTER statement: Error 2013: Lost connection to MySQL server during query SQL Statement: ALTER TABLE `...
14
votes
3answers
34k views

How to make MySQL table name case insensitive in Ubuntu?

I am using Ubuntu 13.10 and MySQL 5.6 and I know database name and table name are case sensitive in Ubuntu (and some other *nix environments) by default. Now, I want to make MySQL work as case ...
1
vote
1answer
72 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
3answers
62 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
0answers
25 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. ...
5
votes
2answers
4k 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 ...
0
votes
1answer
30 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
9k views

Automatic backups for MySQL Workbench

Is there a way to schedule AUTOMATIC backups for specific tables in MySQL Workbench?
1
vote
1answer
47 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
49 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 ...
1
vote
1answer
792 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
19 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
113 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
34 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
2answers
52 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 ...
0
votes
1answer
39 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 ...
25
votes
7answers
81k 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 ...
1
vote
1answer
25 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 ...