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

learn more… | top users | synonyms

0
votes
2answers
77 views

how to display parent items with thier child items in mysql data base

i am using my sql data base i have table with following data and table name is account id name parent-id 1 aaa null 2 bbb 1 3 ccc 2 4 ...
0
votes
1answer
72 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 ...
0
votes
0answers
11 views

MySqlworkbench asking for convertion

hi everyone i have a question about sql in the programm of mysqlworkbench .I want to convert a er diagramm which i created in word into a database in sql.So Can anybody know to tell me how to connect ...
0
votes
1answer
418 views

Soccer league ER diagram (implementing a many to many relationship)

I am planning on creating a database to track teams and players in a soccer league. The stats I wish to track are as follows... goals scored/conceded(gk), assists, minutes played, cards received and ...
0
votes
1answer
122 views

Dropped connections, corrupted schema … is MySQL sick?

Lot's of problems and I wonder if it's all tracable to some root cause. I'm trying to load a simple schema related to product marketing. The symptoms are: Not being able to forward engineer said ...
0
votes
1answer
329 views

adding autoincrement to id already part of foreign key

I would like to add the autoincrement property for all my table's columns named id in a schema. However, most of them are part of a foreign key constraint. Is there any other way to do it without ...
0
votes
0answers
55 views

Update table with selected data from join of other two table

Hey i'm new bee for mysql , I require a help that where i'm going wrong and what better can be done Table A ID_No | Mobile_No -------------------- 1 | 9999999999 2 | 9888888888 ...
0
votes
0answers
72 views

How I do a complete backup restore of MySQL Schema with views and functions?

I am trying to backup a single schema on a Windows server and restore it to an Ubuntu 12.04 Linux server running MySQL 5.5.4. The schema includes views and functions. When I used the MySQL Workbench ...
0
votes
0answers
48 views

I can't import from self-contained file in Workbench

Hello I try to import a model database that believes in workbench but says that whenever I import see that says the process was successful but when I try to view the imported tables in schemas no ...
0
votes
0answers
82 views

How to use a subquery that returns multiple rows?

I am getting Error 1242 : Subquery returns more than 1 row. Basically, I have to do this : select data from my database based on a time criterion (between 2 dates) and then apply a filter on the ...
0
votes
1answer
120 views

MySQL Workbench: Edit hidden relationships in EER diagram

How can I open the Edit relationship options panel of a relationship that is previously been hidden? Workbench v6.2
0
votes
1answer
167 views

MySQL Workbench - “deploying” schema into a real database

a noob here, finding my way around. So, how can I "transfer, deploy or whatever the right term is" the database tables, fields, etc. that I have created with Workbench into a real database? The dB I ...
0
votes
1answer
168 views

Remove duplicate terms from column

This the tags column where all terms should be listed only once. Would like to remove all additional words from this column. For example the below contant: Lakshmi Bar & Restaurant, Dining ...
2
votes
3answers
127 views

getting MySQL error 1064 but very (absurdly) simple query in MySQLWorkbench

I'm getting a MySQL 1064 error for the simplest query when run with \G at the end. This works: select * from locations; and this doesn't: select * from locations\G hmmm... is there any way to ...
0
votes
0answers
90 views

Mysql Workbench Server Status CPU Metric

MySql Workbench 6.1 on Windows connecting to MySql 5.6 on Linux (Amazon RDS). The Management - Server Status page shows information about the connected Mysql server (Queries per Second, etc). It ...
1
vote
1answer
46 views

Differences between Authentication Types in MySQL Users and Privileges

I noticed that when I create a new account, that there are three different Authentication Typesavailable to choose from in MySQL Users and Privilegeswindow. What I am wondering is: What is the ...
0
votes
0answers
70 views

In Forward Engineering I have an error called 'table does not exist'

This is my forward engineering code. -- MySQL Workbench Forward Engineering SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, ...
0
votes
1answer
40 views

Relationship issue

I'm working on a ERD with mysql workbench, and i have a little question. I have a Database with this tables: company_address country state city I want to store the address of the company with all ...
0
votes
1answer
239 views

Duplicate entry error for unique key that doesn't exist

I have a model that had the following fields: +----------+----------+ | username | password | +----------+----------+ | AAA | *** | | BBB | *** | | CCC | *** | ...
0
votes
0answers
509 views

Mysql Workbench Foreign Key problem

I'm working on a simple company database design but i can't figure out why i can't create foreign keys for some tables. Let me give a screenshot of the design; I'm trying to create foreign key for ...
0
votes
1answer
77 views

How to call a windows program in mysql prompt in windows

I want to call an OS level commands from mysql prompt within Windows command line tool. In Unix* there is a system command available to execute OS commands within MySQL prompt. Any way of dong the ...
0
votes
1answer
187 views

Select Count on Big table take 15 minutes

I try to run select Count on table with like 16M rows, with MySql 5.5 and workbench 6.2. The query running almost 1000sec . Is it normal? The query : SELECT COUNT(1) FROM My_Table when I run ...
0
votes
1answer
291 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
0answers
19 views

Is it proper to make a grand-parent key, a primary key, in its grand-child, in a multi-level identifying relationship?

I'm modeling a DB for a conference ticketing system. In this system attendees are members of an attendee group, which belong to a conference. These relationships are identifying, and therefore FKs ...
-1
votes
1answer
59 views

what is the short cut key in mysql workbench to alter stored procedure or schema panel

what is the short cut key to alter stored procedure or navigate into schema panel in MySQL work bench windows 7
0
votes
1answer
85 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
0answers
39 views

What are correct database structure, variable names, types?

Here is my database ERR diagram I'm new to this and I'm creating a database for the following: Question and answer website The user will interact with only one question at a time. The user can ...
0
votes
1answer
77 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. ...
0
votes
0answers
18 views

Is online schema change possible with MySQL Cluster?

I believe that this is the first question on this community. I'm surveying MySQL Cluster for next project in my workplace. I read a lot official/unofficial pages on the web. But I'm not a native ...
0
votes
1answer
154 views

Clarification on MySQL Workbench Options File Configuring

When in the MySQL Workbench tool, configuring the "Options File," I see a drop-down in the lower right corner with the options: client mysql mysqld By default, 'mysqld' is selected and I see my ...
0
votes
0answers
80 views

connecting Pervasive PSQL and MYSQL

I have Peachtree/Sage 50 on the server and trying to sync/integrate with MySQL, I already created a ODBC datasource but how can import all tables in sage to MySQL. What im trying to accomplish is to ...
1
vote
1answer
684 views

WARNING Error checking mysqldump version Error retrieving version from mysqldump.exe: mysqldump: unknown option '--no-beep' (exit 2)

When i go to do a manual export from mysql database to workbench, this error occurs, i dont know solve
2
votes
2answers
3k views

High MySQL “InnoDB Writes Per Second” - Can't see the queries?

On our live MySQL 5.5 database server, we use MySQL Workbench for running manual queries, checking running queries to see what's going on, etc. I noticed today that on the "Server Status" tab there's ...
2
votes
1answer
305 views

How to force MySQL/MariaDB to show numbers in scientific notation?

I have a local MariaDB server 5.5.37 where I have some numeric data in it stored as DOUBLE. I need to perform some queries on this data (things like AVG(...) or STD(...)), and I also have a MySQL ...
0
votes
1answer
247 views

MySQL JDBC does not behaves as the MySQL Workbench

I'm running the following from the MySQL Workbench, and from my local tomcat using jdbc. START TRANSACTION; CREATE SCHEMA IF NOT EXISTS `ROOT`; CREATE TABLE IF NOT EXISTS `ROOT`.`all_tables` ( ...
0
votes
0answers
392 views

SQL Server to MySQL migration using MySQL workbench

I tried to migrate database from SQL Server 2012 to MySQL v5.5. I used MySQL workbench v6.1 community edition. What I was migrating is just schema only, not for the data. I got this error Reverse ...
0
votes
1answer
1k views

MySQL Workbench run SQL script file Character Set encoding issue

Upon running a .sql file for creating a schema in MySQL Workbench 6.1, it prompts a window saying it cannot decide the right character set What's the proper thing to do?
1
vote
1answer
33 views

MySQL Utilities seems outdated?

http://dev.mysql.com/downloads/utilities/ has MySQL Utilities 1.4.4 for Mac OS X 10.7. Is this still updated and recommended to use along with MySQL Workbench? I'm at the latest MySQL Workbench 6.1 ...
1
vote
1answer
4k views

Automatic backup MySQL Workbench

Is there a way to schedule AUTOMATIC backups for specific tables in MySQL Workbench?
1
vote
2answers
144 views

Creating a database with only MySQL command line?

The linux server on which I'm attempting to create a MySQL database has many difficult to work with permissions. My supervisor has tried to install MySQL Workbench on the server, but has been unable ...
-4
votes
1answer
183 views

How to run mssql server dependent application to mysql workbench [closed]

I am very new in mysql workbench. I have created an application in c# which uses sql server 2008 r2 database. Now i have migrated my database on mysql workbench. i want to run my application now. My ...
1
vote
1answer
905 views

Cannot create foreign key on 2 VARCHAR(45) columns in MySQL Workbench 6.1

I'm trying to create a foreign key. The columns in both tables are VARCHAR(45) and neither is a PK, however I keep getting this error message: It is saying the PK of reference table is INT, which ...
0
votes
0answers
22 views

Best Practice for database design (storing images to a database) [duplicate]

I am currently developing a webpage for a real estate (using Java server faces) ,so it is essential to store images connected to its house. I am using mysql workbench and I really have a hard time ...
0
votes
1answer
514 views

How to generate the E-R Diagram of Wordpress using mySQL Workbench

I am trying to generate the E-R Diagram of Wordpress using the 'Reverse Engineer' feature. There is a slight obstacle though. The diagram does not show the relationships between the entities. Is this ...
0
votes
0answers
22 views

Continue a command on the remote MySQL server when I exit local MySQL workbench?

I'm issuing a DROP TABLE command that is taking a very long time. If I close down my local MySQL Workbench, will the command still be running and finish on the remote server? If it doesn't, is there ...
0
votes
2answers
2k views

query execution time in mysql

I have run the query in mysql which consists of approximately 33million records when i have executed the query select population1 < 200000 from city; it shows like this after execution ...
1
vote
1answer
62 views

my phpMyAdmin data is hashed or hexed?

I have a mySQL db setup in MAMP in which I connected mySQL Workbench to administer the design of the database. When I inserted some data today from within myPhpAdmin (localhost:8888), I noticed the ...
1
vote
1answer
836 views

Issue when connecting to open shift via mysql workbench on Mac

I am trying to connect to open shift with mysql workbench on an iMac. A colleague has shown me his setup on Windows which looks exactly as follows (other than the usernames / passwords changing) ...
0
votes
0answers
130 views

Which local port does MySQL Workbench forward to in 'Standard TCP/IP over SSH' connections?

So if I was to set up an ssh tunnel for MySQL in terminal I would forward remote 3306 to local 3307: ssh -L 3307:127.0.0.1:3306 user@domain.com mysql -h 127.0.0.1 -P 3307 -u user -p db When ...
0
votes
1answer
48 views

To check who has updated my database

I have server database MySQL which is connected to different network(or ip address) i want to find out which user has updated what and when ? can log file help me in this if so how ? please can ...