Questions tagged [mysql-workbench]

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

Filter by
Sorted by
Tagged with
1
vote
2answers
3k views

Import data into MySQL using Talend Open Studio

I have been trying to import CSV data about 60 MB; it contains about 400,000 rows, which should not be too much. I tried these ways to import the data: MySQL Workbench - it took about two hours!!! ...
0
votes
2answers
992 views

“Incorrect string value” while migrating from MSSQL to MySQL with Workbench

I got the task to migrate our MSSQL database into a MySQL database. Therefore I am using the recent version of MySQL Workbench and FreeTDS Driver. During the migration I always get errors like this: ...
1
vote
0answers
1k views

Dynamic SQL Stored Procedure called by a Function

I want to be able to dynamically call a function that contains a select statement whose table changes depending on the function parameters. I know this is not possible to do within a function, but I ...
0
votes
1answer
62 views

MYSQL workbench & other IDEs not working on fresh OS after reinstall?

I've recently had to format my computer and re-install my Win7 OS. Then I reinstalled the MySql workbench I was using last time. However, each time I open it and create a schema, the entire workbench ...
0
votes
1answer
1k views

Change table schema in the workbench

I have three different schemas, ended up creating all the tables in one, but now I want to put them in their correct schemas. How can I do this without using scripts? the version of Workbench that ...
6
votes
4answers
10k views

Delete Slow Query Log File

I was logging slow queries of my system. Now I have few queries to be optimized and reset the global slow_query_log variable to 0. Now I want to delete slow query log file mysqld-slow.log. can anyone ...
0
votes
1answer
671 views

How to export table definitions and data in mysql workbench

I am using mysql workbench 6.3 and I can´t find a way to generate a sql file with one table definition and data. I could find where to export data or table definition but not both.
1
vote
1answer
2k views

How to search in blob binary wise, and how to export data binary wise

I've a table with a blob field for each row. The blob contains binary data, which can be represented as bytes or text ( using mysql workbench - open value in viewer) Does anybody know how can I ...
-1
votes
1answer
24k views

I need to change the format of 'date' from yyyy-dd-mm to mm-dd-yyyy [closed]

My dilema, I was requested to populate a table of sample data and I completed the command to add a date. I entered '07-07-2016' as sample data. When running a query the "date_ordered" field came ...
0
votes
1answer
75 views

MySQL Workbench Synchronization False Positives

I have synchronized a table between a model and a live server database in Workbench, but every time I rerun the "Synchronize With Any Source..." wizard, Workbench detects (falsely) that there is a ...
2
votes
1answer
9k views

How to recover a lost password in MySQL 5.7.11? (for Windows)

I am running MySQL 5.7.11 on Windows 10 I am unable to login to root through the command line client since I lost my password. How do I change/reset the old password? Please help, and thanks in ...
2
votes
1answer
1k views

Fail to connect from MySQL Workbench to remote server

After trying many different suggestions as found on 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) ...
2
votes
2answers
37 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
1answer
711 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
47 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 ...
2
votes
1answer
536 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 ...
2
votes
2answers
3k 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 ...
0
votes
1answer
54 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;
3
votes
4answers
3k 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't ...
2
votes
1answer
1k 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 --...
2
votes
1answer
53 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
5k 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 ...
1
vote
1answer
2k 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
2k 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
1answer
122 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 ...
1
vote
3answers
1k 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
367 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 ...
2
votes
1answer
2k 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. ...
1
vote
1answer
3k 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
105 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 ...
1
vote
1answer
870 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 ...
1
vote
2answers
4k 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
110 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
2answers
1k 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
273 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
409 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
1answer
539 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 how ...
0
votes
1answer
501 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
365 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 ...
4
votes
1answer
4k 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
117 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
248 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 ...
7
votes
1answer
439 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
32 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 ...
5
votes
2answers
4k 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 ...
1
vote
1answer
1k 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 ...
2
votes
1answer
673 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 ...
9
votes
2answers
19k 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 ...
1
vote
1answer
2k 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
775 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?