MySQL Workbench : MySQL's Open Source GUI for Assisted DB Administration
0
votes
2answers
6 views
how make mysql table name case insensitive in ubuntu
I am using Ubuntu 13.10 and Mysql 5.6 and I know Database Name and Table Name are case sensitive in Ubuntu(some *nix) environment.
Now i want mysql should work for as case insensitive.
Is it possible. ...
0
votes
1answer
35 views
How can I push data from my local MAMP database to my remote database?
I'm developing a site locally using MAMP Pro, and I've created a mysql database locally that have the same structure as the remote server. (username and password are different though)
I'm inserting ...
0
votes
1answer
37 views
Copying MySQL tables, InnoDB tables not recognized
I have to set up a database copy on my local computer.
The problem is that that I have given just the raw database table files (.frm, .ibd, .MYD, .MYI).
I created the database by creating a folder in ...
0
votes
2answers
24 views
MySQL Workbench query tabs
I am trying MySQL Workbench 6.0 and when I execute a query the results are displayed with a tab called "Result 1". When I fire another query the same tab is reused, now named "Results 2".
I found no ...
1
vote
0answers
11 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
2answers
62 views
Optimize a MySQL Database using MySQL Workbench
I actually have a few issues.
First, I found this information about optimizing: MySQL OPTIMIZE all tables?
The problem is, I don't seem to have a mysqlcheck program anywhere. I'm using MySQL ...
0
votes
0answers
87 views
MSSQL to MySQL sync, using Workbench, FreeTDS, and iODBC on 10.9
I've been struggling to get the MySQL Workbench to behave properly to complete the following:
With Mavericks (OS X 10.9), connect to a MSSQL server and create a migration job to a MySQL server.
The ...
1
vote
2answers
67 views
MySql InnoDB tables are missing after restarting
I had a MySql database with a few InnoDB tables. After restarting the server, and starting MySql Server again, I connected to the MySql Server using MySql Workbench, and couldn't see the database at ...
0
votes
0answers
80 views
MySql Server can't start after loss of power on windows
after loss of power,my computer restarted, and mysql can't start anymore. I use workbrench, but can't start it until I reinstal mysql server and mysql workbrench.. Please Help
HERE IS PART OF MY MY ...
0
votes
1answer
52 views
MySQl master - master replication not working [closed]
I'm trying to setup a master - master setup and I see both masters connect to each other
in workbench:
server 1:
-- Thread Id: 112
-- User: slave
-- Host: 207.244.73.38:55164
-- DB: None
-- ...
0
votes
1answer
35 views
MySql One-to-zero to one-to-one
I have a table Persons with id as pk and auto increment. Then I have a table Addresses with id as pk and fk to the Persons id. But now person can exist without an address, and I don't want a person to ...
0
votes
2answers
193 views
How to migrate Oracle database to MySQL server?
Currently our application is running using Oracle 11g database. We are developing newer version of the application which runs on MySQL cluster. We need to migrate the data from Oracle database to ...
-1
votes
1answer
652 views
How to connect an oracle DB with MySQL workbench?
I am a bit confused:
I want to connect an Oracle DB with the application "MySQL Workbench". In order its from Oracle as well I throught that this is possible. But until now Im not able to do so.
With ...
1
vote
1answer
58 views
Change normal user to admin in MySQL
I have set up a MySQL database. My problem now is I can't add new users with the user I have created.
I try to grant access but I can't still add new users to my system. I use Workbench to add new ...
1
vote
1answer
137 views
Can MySQL Workbench generate data?
Is there a way to generate mass rows of dummy data in a table for testing in workbench?
If not, are there any free tools out there that is able to do that?
2
votes
2answers
374 views
How to auto-refresh/re-run a query every few seconds?
I have a script running against a database with no GUI. This simple query lets me see its progress:
select
*,
(select count(*) from domains) as count,
(select 456976-count(*) from ...
0
votes
0answers
219 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 ...
4
votes
1answer
94 views
Probable circular dependency, but query still runs
I built this ER diagram in MySQL Workbench and it will run and generate the database. My concern is that the relationship between the employees, departments, positions, and employment_statuses is a ...
0
votes
2answers
2k views
How to view table data in the newest 6.0 MySQL Workbench
I basically fail to view data in the new Workbench version without firing queries. I recall it was clearly possible in the previous version by simply using context menu something like "view table ...
0
votes
1answer
431 views
Migrating from SQL Server to MySQL using MySQL Workbench tool
I'm trying to migrate few tables from SQL Server to MySQL using MySQL Workbench migration wizard. All work fine for structure migrations but when I go to the data migration section it throws an error ...
1
vote
0answers
98 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
2answers
27 views
Finding code tab's associated schema in MySQL Workbench
I have a single-tenant setup of MySQL databases; i.e. a more or less identical schema instance for each client.
When I'm tasked with modifying the code of stored routines, I use MySQL Workbench. ...
0
votes
1answer
80 views
MySQL data retained after OS reinstall
Something strange happened today.
I reinstalled my OS and then when I reinstalled MySQL workbench some of my old data was still there. I think the actual local db is empty, but all the connections, ...
0
votes
1answer
1k views
How do I generate a SQL script from my diagram in MySQL Workbench? [closed]
I've created an EER diagram with tables, foreign keys, etc in MySQL Workbench and now I want to generate a ".sql" script that will create this database. How do I do that?
0
votes
0answers
86 views
please help me connect workbench on 5 system having one server
We have computing software which has one server for 5 computers.
I can work on server in MySQL workbench but when i try to work on second computer i get error failed to create ipc port : access is ...
2
votes
0answers
266 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 ...
1
vote
0answers
112 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).
...
0
votes
1answer
214 views
What does a round relationship icon mean in MySQL Workbench Visual Data Model
I have created a model in the Visual Data Model of MySQL Workbench, and on one single relationship, this icon shows up:
What does it mean? The Relation is 1:1, and this icon shows only on this ...
1
vote
1answer
261 views
MySQL Workbench Alter Procedure
i have a problem with my workbench program. I use Mac Lion OS X and mysql workbench program. When i want to do any procedure to alter that doesn't work. Which is show to the procedure code i right ...
2
votes
1answer
334 views
prevent MySQL Workbench to add index for foreignkey constraint when it is first part of primary
I know for each foreign key we should make an index on its column, But it is not necessary when that column in first part of PRIMARY index.
MySQL accepts this query:
CREATE TABLE IF NOT EXISTS ...
0
votes
0answers
25 views
Secure the jdbc and remote MySQL(windows) server connection [duplicate]
I'm a student doing a project which uses jdbc and mysql(on windows).
I have an app with connects to mysql server on remote host.
I just this connection to be a little secure.
I found this :
...
2
votes
1answer
595 views
Using Workbench to export. Views no longer work
I'm using Workbench 5.2 from my production DB machine (Ubuntu Linux). I've been trying to export. First try.. I had the entire schema selected including all tables and views in the right hand ...
0
votes
2answers
581 views
How can I add a column to multiple tables at once in MySQL Workbench?
I have a MySQL Workbench model (diagram) that belongs to a Ruby on Rails application. I now need to add the created_at and updated_at timestamp columns to each of the tables. What is a quick and easy ...
0
votes
1answer
336 views
MySQL Workbench - question about creating FK relationships
Forgive me a little new at databases and I came across something while working with Workbench that I have a question on.
In a very simple testing database, with three tables: Company, Department, ...
0
votes
0answers
58 views
Problems Making Configuration File Changes
I use MySQL 5.5 on both Mac OSX (10.6.8) and Windows 7; in both contexts I use Workbench for my administrative needs. I've recently started tinkering with the configuration files (my.cnf/my.ini), and ...
0
votes
0answers
173 views
Mysql query browser can't connect, Toad, Perl, workbench and command line can?
Mysql query browser used to work fine then suddenly stopped working:
cannot connect to database server. Your connection attempt failed for user 'brianp' from your host to server at viper:3306: Could ...
0
votes
1answer
204 views
Database for opening times of locations
I'm designing a database for opening times and created this solution.
The specifications of the database which will be a MySQL are, that a location have standard opening times in a week and can ...
0
votes
1answer
63 views
best relationship for this design?
There is a table users with autoincrement primary key id.
There is also a table employees (every employee is a user but not vice versa). The employees primary key is userid. The field userid is not ...
0
votes
1answer
108 views
Mysql query is very slow
I am developing a website like any other social networking site using mysql.
I wish it give people suggestion to my users, and I have implemented this functionality in my application, but It is ...
0
votes
1answer
125 views
MySQL not allowing text columns?
I'm using MySQL 5.5.27. I currently have a BLOB column, that I want to convert to text to allow fulltext searching. The ALTER TABLE command to create a text column is successful, but the ALTER TABLE ...
0
votes
0answers
57 views
mysql table not updating no errors
i am using mysql 5.2.44 CE revision 9933
i have a table in which i am trying to update a few columns of the rows
i am not using queries, just doing it using the edit table UI provided in the ...
1
vote
2answers
516 views
Mysql notifier Error
i'm getting error when opening Mysql notifier High Severity Error Element 'UpdateCheck' was not found. Line 3, position 2. My mysql server is running. why it's showing this error.
1
vote
0answers
568 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 ...
3
votes
1answer
405 views
What relationship type to use for this messaging system?
I am trying to make a small messaging system. It should have these properties:
One user can send a message to one or many users
Messages can be sent only to registered users (i.e. to an existing ...
1
vote
0answers
104 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 ...
2
votes
1answer
635 views
creating table syntax error 1064
I'm using workbench to create a table. This script is giving me a problem. It is saying that there is a syntax error new ').
DROP TABLE IF EXISTS `waitronmain`.`managers` ;
CREATE TABLE IF NOT ...
1
vote
1answer
221 views
ERROR: Error 1005: Can't create table 'progetto.museo' (errno: 121)
I've found on the web that:
You will get this message if you're trying to add a constraint with a name that's already used somewhere else
and
If the table you're trying to create includes a ...
3
votes
2answers
1k views
How to search for a specific column name in all the tables in MySQL Workbench?
In MySQL Workbench, is it possible to search for a specific column name in all the tables?
(Writing the string to look for in the field at the top right does nothing).
Thank you.
2
votes
2answers
3k views
how to add trigger in mysql workbench, without UDF, using EER design
I have designed a simple database using EER in workbench. However, i want to have a minimum value for the attribute salary (compared with min_value attribute from artist table). Here is the schema:
...
0
votes
1answer
64 views
What would be the first things you do to find out about an MYSQL environment you are taking over?
I am new to DBA role, and wanted to know if there was any commands (or free software) that come with Mysql 5.5 (master/slave/slave) replication to quickly get familiar with
the database, and also ...
