Questions tagged [mysql-workbench]

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

98 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
1answer
70 views

Stored procedure getting delayed more

Stored procedure and it is getting delayed. Taking nearly more than half an hour if I call the stored procedure in MySQL command line client. This procedure is to update values in two tables drop ...
2
votes
1answer
48 views

find 16,000 words and replace with ##

I need to do a find a replace but rather than find one word to replace with another I have about 16k words, so as an example; table 1 has two words apple,orange - table 2 has the contents of a book, i ...
2
votes
1answer
257 views

Suggestion for a contact management database design

I am currently designing a contact management database for a chamber of commerce. The goal of the database is to store all the person (except our own staff), all recorded companies (regular companies ...
2
votes
1answer
31 views

MySQL - can't get the result of non-matching records

I am trying to get the result of a record which has a missing entry in the other table. I already tried using NOT IN and NOT EXIST but I cannot get the desired result. The output should be Kevin and ...
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 ...
2
votes
0answers
2k views

MySQL workbench won't import my sql file

I have an SQL file im trying to import via mysqlworkbench but I keep getting the error: Access denied for user 'wordpressuser79'@'localhost' (using password: NO) Operation failed with exitcode 1 ...
2
votes
1answer
473 views

mysql workbench connection type tcp/ip over ssh with libpam-google-authenticator enabled

I'm attempting to connect to my MySQL Database using the Connection Method "Standard TCP/IP over SSH". I filled out all the SSH and MySQL connection details correctly, however I get the message: "...
2
votes
0answers
1k views

The nature of the relationship between two tables in MySQL

Good day. I'm designing a database for a research project where we're predicting whether or not young female athletes will rupture their ACL(s) based on the nature of a test jump recorded with a ...
2
votes
0answers
943 views

Ignore foreign keys in mysql workbench model synchronization

I've made an ERD in MySQL Workbench, where I added foreign keys to visualize the relationships. In the actual database I want to work without the foreign keys (I'll organize that in my application). ...
2
votes
0answers
2k views

Migrating from Oracle to MySQL using WorkBench Migration Tool

I am currently migrating from Oracle to MySQL and I am going to use the migration tool in workbench to help me with the procedure. I have entered my source connection details as follows: Database ...
2
votes
0answers
516 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 ...
1
vote
0answers
38 views

Mysql Workbench generates an additional FK in child of a child table referencing the Parent of its Parent

I'm trying to create a Part that is a child of Sublot, which in turn is a child of Lot. Mysql Workbench automatically creates the foreign keys, when I insert the many-to-one relations graphically. ...
1
vote
0answers
201 views

Received an unsupported type from Postgres. (14) (SQLGetData)

I have database in PostgreSQL. It is simplest possible database with schema presented here: http://www.postgresqltutorial.com/postgresql-create-table/ I want to migrate it to MySQL. I trying to ...
1
vote
1answer
988 views

Error: The user specified as a definer ('Admin'@'%') does not exist

Error de SQL (1449): The user specified as a definer ('Admin'@'%') does not exist I have this error when I'm trying to update a table. I don't know what I must do, because this error only happens ...
1
vote
2answers
298 views

mySQL Workbench new Connection : There is no disk in drive. Please insert disk in \Device\Harddisk2\DR2

I'm trying to migrate the data at my company from Excel to mySQL so I'm very new at this. I just installed the latest mySQL package via the standard installer and when I try a new connection (I'm ...
1
vote
0answers
31 views

How to fully dump mySQL database via workbench?

I am exporting database in SQL file using workbench. Export is done successfully, but when I import data and compare record counts with older database, some of the records are missing. Not all records ...
1
vote
1answer
199 views

DBForge can't connect with MySQL server, server is running

I recently installed the latest version of MySQL Server. I initialized it with --initialize-insecure so I have a "root" user with no password set. The server is running, with the command mysqld --...
1
vote
1answer
815 views

MySQL Workbench Unable to Connect to Azure Databases for MySQL

When trying to connect to a MySQL database in Azure I get the following error: ERROR 2026: SSL connection error: socket layer receive error At first I thought it was a firewall/security issue but ...
1
vote
0answers
785 views

Stored Procedures doesn't show up in MySQL WorkBench

I have a MySQL database which has a few stored procedures, functions, and tables. The problem I face is when I try to load the MySQL Database in MySQL WorkBench 6.3, it shows only Tables. Views, ...
1
vote
0answers
120 views

Resetting MySQL Workbench 6.3 CE password

I'm a rookie using MySql Workbench 6.3 CE on Windows 10. Before I could even try to open my first data table to begin learning SQL, I've managed to forget my password. Can someone help me re-set it ...
1
vote
0answers
261 views

Convert string to int unsigned

I am creating a procedure that will allow me to auto increment a primary key my way. They key has a structure of M or V followed by a number. The key for the table is defined as varchar(100). The ...
1
vote
0answers
675 views

MySQL Workbench - Migration Wizard - invalid option

I encountered following error during "Bulk Data Transfer" stage in MySQL Workbench Migration Wizard: Starting... Prepare information for data copy... Prepare information for data copy ...
1
vote
0answers
646 views

Importing larger CSV files to an empty table in a local MySQL database

I am building a local database made up of a handful of tables. The first few worked fine using the Export/Import option on the window that comes up after right clicking on a table and selection "...
1
vote
0answers
33 views

Weird MySQL Model synchronization error

Why do I get this weird error when trying to synchronise my model with the mysql database (v5.7.19, workbench v6.3.9)? As you can see from the screenshot, table1_createdOn doesn't even have a default ...
1
vote
0answers
1k views

transaction isolation in MySQL workbench

MySQL Workbench has a bug where every new created session receives default session parameter values regardless of the server's definition for that parameter. For example, when the server's "...
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 ...
1
vote
0answers
282 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 ...
1
vote
0answers
147 views

Replicate existing database live

New to db admin here and I have a question. My setup is Windows Server 2012 R2, MySQL, using MySQL Workbench. I have Database A on Server A, how can I make an exact clone of this database (Database B)...
1
vote
0answers
101 views

How to pass the value of PK to FK

Ok, so here it goes. I have a table called employee. then I have another table called languages. I need to copy the value of PK of employee table to foreign key in Languages table, rather than ...
1
vote
1answer
198 views

How can I import latitude and longitude data into a database using Mysql Workbench?

I am currently trying to get some latitude and longitude data to import into a database using the data import wizard in mysql workbench. the problem is that the floating point values that get ...
1
vote
0answers
66 views

Get unique rows based on max of a column in mysql

I came across many solutions like the one in this question. However, they all are restricted to data from one table. I'm very very new to SQL. I'd like to get the same results as in the linked ...
1
vote
0answers
323 views

How to limit the no of rows to copy in MySQL Workbench Data Migration

I am trying to migrate a huge MS SQL database to a MySQL database using MySQL Workbench. The source database is too big and i am only interested in 1000 records per table for migration. ...
1
vote
0answers
576 views

MySQL Workbench Forward Engineer from only the current diagram

I want to create a test database from a huge schema in MySQL, but when I try to do Forward Engineer from a Diagram with about 6 tables, it try to create all the tables, views and routines groups that ...
1
vote
0answers
10k views

Multi user messaging database design

I'm designing a database for a new project and I'm looking for some feedback on the design before I start to implement. It basically consists of secure messaging system with those abilities : One ...
1
vote
0answers
129 views

How to get data comparations from two mysql tables

What I have: The next structure: Table ChrM LID (PRIMARY with auto increment) LOCUS (varchar (9)) Example value: (At1g30500) (Fixed Number of LOCUS values =173 rows) StartPoint (INT) (Exclusive ...
0
votes
1answer
24 views

Is it possible to run multiple versions of MySQL Workbench?

I'm doing an application migration from MySQL 5.5 to workbench v8... 5.5 supports MySQL Workbench up to version 6.3... However, MySQL server 5.5 only supports up to version 6.3 of the workbench. I ...
0
votes
0answers
9 views

Syntax error when creating procedure in mysql

I am trying to create a procedure, but I am always getting syntax error and it is marking me "(" or ",". Iam using version 6.3. Can somebody help me to fix this problem? And here is my code
0
votes
0answers
15 views

prepared statement returns NULL, unable to retrieve the column value

I'm creating a procedure where it will iterate over every column in a table and get maximum value of every column. This is my code: DELIMITER // DROP PROCEDURE IF EXISTS min_max // CREATE PROCEDURE ...
0
votes
0answers
12 views

Import mysql tables and data into Sql server2008, when mysql is on a remote server and sql server 2008 is my local server

I am trying to import mysql tables and data (on a remote server), to sql server local database. I have exported data from mysql workbench and saved them as .txt and then imported flat text files into ...
0
votes
0answers
11 views

How can I get the MySQL Workbench migration report in a file?

I am looking into a possible migration from SQL Server to MySQL. I've run the migration tool and generated a report but the output is HUGE and I need to share different parts of the report with ...
0
votes
0answers
22 views

How to find executed query by user

I want to find all the queries executed by an particular user in a database over a period of time in MYSQL. Even they executed query by using MYSQL workbench i want to see log in my Database cloud ...
0
votes
1answer
32 views

How to get dates from a table while the date range is from the date belonging to another table?

I have a table datedim which has all the dates of a month in it. I have another table attendance that has dates on which attendance were taken. I need to write a query where i can get all the dates ...
0
votes
0answers
20 views

MYSQL need log executed query in table along with executed user name

I would to like the executed quires with entire database tables for some mysql users only. Because some of users executed wrong query in production environment. And needs to store this log in new ...
0
votes
0answers
294 views

MySql Workbench Couldn't find section mysqld in the remote config file /etc/mysql/my.cnf

if you get this trying to connect to your remote server using MySql Workbench, then try to (on your remote server) navigate to /etc/mysql/my.cnf and add [mysqld] then it should look like: !...
0
votes
0answers
174 views

How to improve the speed of a large data migration between SQL Server and MySQL server?

I have an application that is connected to a SQL Server Express database. The database grew and the database is almost at 10GB which is the max limit that SQL Server Express allows for. I am trying ...
0
votes
0answers
48 views

Insert values into a table using a trigger with values from stored procedure

I'm a newbie here. So, please feel free to correct me if my code or thinking approach can be worked upon. I am working in MySQL Workbench and MySQL 8.0 Command Line Client. I have a database called ...
0
votes
0answers
94 views

How to restore the missing mysql db schema?

My DB schema is missing/deleted by someone without my knowledge from ASW EC2 windows machine. Seems some unauthorized user entered into the system illegally and did something. Since I can find some ...
0
votes
0answers
291 views

Load From S3 MySQL Error Code 2013 — AWS Aurora

I am attempting to load S3 files to an Aurora MySQL DB Cluster using the below AWS documentation: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Integrating.LoadFromS3.html ...
0
votes
0answers
22 views

one to many relation how to create a new row with mysql trigger

i'm really new to mysql triggers so...i have 3 tables: a,b and c. table a is related with table b with a one to many relaion and table c is the table that get the triggered infromation from the 2 ...
0
votes
0answers
234 views

mysql trigger before insert

How can i make this trigger update my table DATA if there is no row to update. Until i insert data in other table lets called ABC, this table uses a after insert trigger to insert information into ...