MySQL Workbench : MySQL's Open Source GUI for Assisted DB Administration
1
vote
1answer
33 views
MySQL Workbench, how to refresh EER diagram?
I'm using MySQL Workbench to design my MySQL database and model how entities would look like and how they would relate to each other. Now, sometimes I use Doctrine ORM. When using Doctrine ORM, I ...
0
votes
1answer
27 views
Print table documentation with comments?
I have a MySQL database, and I have used MySQL Workbench to insert text into the "comment" fields of many of the columns and tables; the plan was to have the documentation stored in the database.
...
1
vote
2answers
59 views
How to view contents of table in mysql-workbench
Hi everyone am fairly new to mysql, I made a java program that stores data in mysql database. I am using this tool called mysql-workbench that can create databases, tables and much more. What I wanted ...
1
vote
1answer
45 views
MySQL Database Temporarily Compromised?
Two days ago, I had connected to my ClearDB test server with MySQL workbench. I had left this workbench open and when I had checked it today, there were two new schemas named "test_justin" and ...
2
votes
0answers
56 views
MySQL Workbench model/source synchronize issue
I've been looking all over for any description of an issue like this and I haven't found anything so far.
I am trying to update my MySQL database using MySQL Workbench (5.2.40 CE). I am using the ...
2
votes
2answers
158 views
MySQL Workbench copies Schema, but not data, from SQL Server 2008
I need to copy/migrate a database from MSSQL (SQL Server 2008) into MySQL. I am using the MySQL Workbench kit, and work through the process of the Migration. Each respective DB user has full access, ...
2
votes
3answers
88 views
Memory problems with MySQLWorkbench
I'm currently using MySQLWorkbench 5.2.40 on my PC (8GB rRM, Corei7). I have a table with almost 1.5 million records, which I need to visually look over. Surprisingly, the total size does not exceed ...
1
vote
0answers
60 views
Primary key type change not reflected in foreign keys with MySQL Workbench
I have a problem with MySQL Workbench and primary/foreign keys.
I have some tables with PKs involved in relationship with other tables. If I modify the type of the PK, the type of the FK doesn't ...
1
vote
2answers
71 views
How export a database based in a primary key of a table?
So, I'm trying to export all the DB structure of my MySQL db.
Attached is my DB structure, I have more then this, but I want these tables only.
Basically Tools relate to Factsheets and Factsheets ...
2
votes
1answer
106 views
MySQL Workbench asking for password
I am trying to set MySQL server on my Windows 7 64 bit machine. I have downloaded MySQL server and MySQLWorkbench.
I have started mysql service by command
C:\> net start mysql
as suggested ...
2
votes
1answer
97 views
Set-up MySQL Server on Windows 7 64-bit
I am trying to install MySQL Server on my Windows-7 64-bit machine. I have downloaded MySQL Server Community Edition and MySQL Workbench. I am trying to start a new Server Instance from Workbench. I ...
0
votes
1answer
73 views
MySQL ODBC + setting up a DSN on windows + MySQL Workbench
Sorry for the vague title, but here's my problem.
I connect to my database in MySQL Workbench using the following method : TCP/IP over SSH
However, when I try to set up the DSN on Windows 7 via:
...
1
vote
1answer
143 views
mysql workbench *reverse engineer* is not connecting tables graphically. How to fix?
I thought that previously when I reverse engineered databases, mySql Workbench figured out the relationships from the id names and connected the tables leading to an awesome ERD, even when the foreign ...
0
votes
0answers
53 views
Named Parameters in MySQL Workbench Queries?
In OpenOffice / LibreOffice I'm used to added :prefixed-parameter-names to my queries.
For example:
SELECT name FROM table1 WHERE id = :id
Is there a similar functionality in MySQL Workbench?
1
vote
1answer
112 views
--local-infile=1 using MySQL Workbench?
When I start the MySQL bash client, I have been starting it with --local-infile=1 so that I can import data from a .csv file.
Is there any way of doing this within MySQL Workbench?
