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

learn more… | top users | synonyms

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 ...
1
vote
1answer
2k views

Cannot connect to MySQL sever with MySQL Workbench

I am using MySQL 5.6.26 Community Server on a Mac OSX 10.10.4. The server is running, according to the preference pane utility. Also I can connect to the server using the command line tool with the ...
0
votes
0answers
100 views

Comparison of MySQL Workbench model schema with existing database?

I need to compare the schema of a MySQL Workbench model with the schema of an existing database. My initial approach was to use the 'Forward Engineer SQL Create Script' option and compare its output ...
-1
votes
1answer
33 views

How do I make a WHERE statement affect both an AND and OR variable? [closed]

How do I make a WHERE statement affect both an AND and OR variable? For example this query is not recognizing both operators.. WHERE tableA.x = tableB.x AND tableA.y = 'abc' OR tableA.y = 'def' ...
2
votes
1answer
74 views

Calling stored Procedure from one db to give me a result in another db

CREATE DEFINER=root@localhost PROCEDURE AccountReqs( IN IsNewAccountStart VARCHAR (255) , In AccountName varchar (255) , IN AccountNumber varchar(255) ...
1
vote
1answer
166 views

Migrating from Oracle to MySQL via MySQL workbench: Table list is empty

MySQL workbench offers a migration tool that I'm using to migrate an Oracle database to MySQL. I'm using the migration wizard to migrate the complete Oracle schema to MySQL. I used that for the ...
0
votes
0answers
119 views

How to implement a query insert into BEFORE INSERT trigger syntax

I want to insert data using trigger into 2 tables. I want to implement my query insert to a before insert trigger. Since I was newbie for using MYSQL, I'm confused how to implement it. insert into ...
0
votes
1answer
21 views

Creating procedure in mysql [closed]

I am trying to build a procedure that i would use to check my data format before processing it to the net stop and i need this procedure to check the format of my file. So what i need is, my database ...
0
votes
1answer
1k views

ERROR 1091 (42000): Can't DROP 'created_date'; check that column/key exists

mysql> alter table bill_item add index idx_comp(created_date,product_id); Query OK, 0 rows affected, 1 warning (1 min 2.62 sec) Records: 0 Duplicates: 0 Warnings: 1 Trying to drop the index: ...
0
votes
0answers
50 views

How to view the data from a .mysql file?

I have a .mysql database file. I need to open it and view the data. I've MySQL Server & MySQL Workbench installed into my Ubuntu 14.04. Now how do I open the .mysql file and view the data inside ...
2
votes
0answers
27 views

Getting error 1064 in automatically-generated code from MySQL workbench [duplicate]

I have started using mySQL workbench (Version 6.3.4.0) and I have used the EER Diagram tool to design a schema. So far, so good. However, when I try and run the Forward Engineering, I get the error ...
1
vote
0answers
43 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 ...
4
votes
3answers
539 views

MySQL adds broken comment script after each line

Every time I try to create a table using MySQL Workbench 6.3 CE it adds "broken" comments at the end of the script. Example: I am trying to create a table called "user". This is what the table ...
3
votes
3answers
589 views

MySQL - Unable to Convert Primary Key to Auto Increment

I have a MySQL table where the Primary Key (int) was set by the software to be equal to the Primary Key (auto incremented) of the main table. Because of a change in design I now need the field to auto ...
0
votes
1answer
206 views

How to populate a table's foreign keys from other tables?

I have a database with the following tables: Airport ( iata PK, airport, city, state, country, lat, long) cancellation_cause ( cod_cancellation PK, description) Manufaturer (id_manufacturer PK, ...
0
votes
2answers
248 views

Create foreign key doesn't work, column types match

I'm trying to create a foreign key in mysql workbench, but keep getting this error: I've checked the columns on both tables, and they match up as well as I can make them. One is CHAR(21) not null ...
0
votes
1answer
26 views

Error 1241 When Calculating Percentages

I am trying to get my percentages to equal 100%. As of right now they far surpass 100%. I need to account for the percentages in two different tables, ua_money_allocation and ua_expenses_by_school. ...
1
vote
0answers
73 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 ...
0
votes
1answer
57 views

Is it possible to convert mssql to mysql?

I've mssql.sql file I need to convert to mysql schema. Any ideas how? I'm on mac, I guess my choice is very limited. Tried workbench but it asks me for a live server connection to mssql which I don't ...
1
vote
1answer
70 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 ...
3
votes
3answers
11k 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. ...
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 ...
2
votes
2answers
176 views

Scheduling MySQL Workbench to execute and export on a daily basis

Here's my question. I have a couple scripts (very simple stuff; select queries) that I run in MySQL Workbench which I can than export to CSVs. What I want to know is if it is possible to schedule ...
0
votes
1answer
577 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 ...
1
vote
1answer
966 views

No connection could be made because the target machine actively refused it. MYSQL work bench?

I have created php and Mysql site.Its Working Locally Xampp well. Finally I moved My site to server..i have Used Mysql Workbench. connected client database in Mysql Workbench in My system.when I Run ...
0
votes
2answers
1k 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
2answers
180 views

Is it redundant to set your primary key as a unique key?

I'm putting tables together in MySQL workbench and I'm currently ticking my primary keys to also be uniquely indexed. Is this a redundant configuration?
3
votes
1answer
164 views

MySQL Workbench team strategy

I'm considering to use MySQL Workbench at work, mainly because of the modelling tools and to easily sync the development and the production DBs. I work with another developer on the same project, and ...
0
votes
1answer
1k views

Is it possible to change ER diagram style in MySQL Workbench? How?

I am really new to database visualization. I am creating the ER diagram of my databases. I am using MySQL Workbench 6.3 (community version). I am creating the diagram using the default style. The ...
1
vote
2answers
99 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 ...
0
votes
0answers
280 views

PostgreSQL -> MySQL Migration with MySQLWorkbench

I'm trying to migrate data from a PostgreSQL DB to a MySQL DB (it's for permissions in the VPC, so please nobody link me the 'choose-something-else'). I'm getting this error from MySQL Workbench when ...
0
votes
0answers
194 views

MySQL Workbench error: Attribute error 'nonetype' object has no attribute 'parameterValues'

I am trying to export a database but i don't have access to "server administrator" at all... everytime i try to do something from Server administration i get the message mentioned in the title. What ...
0
votes
0answers
60 views

table design approach for a rental application with several one to many relationships

I'm trying to go about designing a database/tables for the following situation I'm being presented. I'm developing a rental web application with MySQL as db engine. It is for a nonprofit organizations ...
1
vote
3answers
52 views

Optimizing MySQL query with left joins

Ok, so first off i am going to provide a bit of information on the database structure I have 3 indexed tables that are used in this query (though one of them should probably be a weak entity, but ...
1
vote
1answer
294 views

Getting Data Type ID in MySQL

So, In SQL, We have the following query to find the system data type ID of columns in SQL Server; select name, system_type_id from sys.columns where object_id = OBJECT_ID(N'sometable') It gives the ...
1
vote
1answer
116 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.
1
vote
2answers
84 views

How to define partition according to Date?

I am currently using MySQL 5.6. In my database, I have a log table called paramlog_ems. It has 2M rows I want like to partition this log table according to Date. Here is the table structure: ...
1
vote
1answer
1k views

Correct 'lines terminated by' for query

I am trying to query two tables of data and send them to a csv file for upload to a website. However i am having trouble getting the formatting to play ball. I want headings to separate into columns ...
0
votes
1answer
183 views

MySQL Workbench: “Operation has completed with warnings”

As I synchronize my database, MySQL Workbench reports: "Operation has completed with warning. Please see logs for details." But the Message Log just says: Fetching schema list. OK WARNING: ...
0
votes
2answers
196 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 $$ ...
3
votes
1answer
140 views

Querying MySQL and SQL Server from same IDE

I am currently working with MySQL and SQL Server. For querying MySQL I use MySQL Workbench, for SQL Server I use SQL Server Management Studio. I am mixing up shortcuts all the time. For instance, ...
2
votes
1answer
271 views

Data normalization (from 0NF to 1NF)

I am designing a relational database in mySQL - a library management system. I want to show examples of the data in 1NF, 2NF, 3NF, BCNF, etc. My example of 1NF looks something like this "A relation ...
0
votes
1answer
27 views

Mysql Adding date/time stamp to file produced, or other method of automated file naming to keep resulting files unique

SELECT '"Part #"', '"Manu"', '"Qty"', '"partdesc"', '"Rohs status"' UNION all ( SELECT partno, manuf, qtyleft, partdesc, stfifo.ROHScompliance FROM stmaster, stfifo WHERE ...
2
votes
0answers
315 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 ...
3
votes
2answers
3k views

MySQL unknown column 'password_last_changed'

When creating a user using this command create user 'foo'@localhost'; this error is shown ERROR 1054 (42S22): Unknown column 'password_last_changed' in 'mysql.user' Using MySQL server version: ...
0
votes
1answer
241 views

middle table in one-to-many relationships

I just started using mysql workbench but it is slightly from the er diagram that i design in paper. I want to have a 1 to many relationship with three tables. For example a have entity A and entity B ...
1
vote
1answer
388 views

How we resolve Mysql Enterprise online backup error with “CORRUPT LOG RECORD FOUND” log error

I have configured my production MySQL database with MySQL Enterprise "online Backup" option. The configuration was went through successfully. When the assigned scheduler is try to take backup then i ...
1
vote
2answers
98 views

MySQL Workbench: How to detach reverse-engineered EER diagram from existing database?

MySQL Workbench provides the option to 'Create EER Model From Existing Database'. Trying to remove a table from the resulting diagram leads to a dialog asking: Should corresponding database ...
2
votes
1answer
110 views

Why MySQL Workbench automatically sets NOT NULL for ID column that is PRIMARY KEY?

My question is why MySQL Workbench automatically sets NOT NULL for ID column that is PRIMARY KEY? I thought that PRIMARY KEY's can't be NOT NULL by definition? Is it really necessary to set it to NOT ...