Usuable Linux GUI Tool For Start Creating And Modeling A New DB?
I need a free linux usable GUI tool, I'm not an expert so I need a easy GUI for modeling and then create in to mysql, but now I haven't found a free usable GUI program.
I have a few days trying with MySQL WorkBench but with not good result and I am not ready yet to buy some complex and expensive program.
Most programs I have evaluated are for administration and querys, but no for begining the creation of. Is there one that combines modeling, creation, administration and querying?
View Complete Forum Thread with Replies
Related Forum Messages:
Good DB Modeling Tool
I'm wondering which tool you guys recommend for creating a database model. This will be used for MySQL and possibly SQL Server 2000/2005. Also, I'd like to have the capability to reverse engineer my diagram to create the appropriate SQL code. Price isn't much of an issue if such software must be purchased.
View Replies !
Open-source/free DB Modeling Tool
I'm looking for a decent DB modeling/designing tool that is free and supports the following features: 1. Visual design of tables/relationships 2. Syncronization to database 3. Query mode 4. Ability to sync with different database types I've been using DBDesigner, but it has a few bugs that are really annoying.
View Replies !
I Can't Start Mysql Server On Linux.
I'm triyng to install mysql server with rpm on a linux red hat 9.0 machine. The installation was succesfully, but now I can't start the server. I think the right command is mysqld_safe --user=mysql but during the starting procedure the server shutdown, it reports: [root@psiche root]# mysqld_safe --user=mysql Starting mysqld daemon with databases from /var/lib/mysql 040525 09:32:25 mysqld ended If I try to rebuilt the grant tables using the mysql_install_db it reports some errors: "asked for 196608 thread stack, but got 126976" and "to start mysql at boot time you have to copy support-files/mysql.server to the right place for your system".
View Replies !
Data Modeling And Design
I am going to start a MySQL database and need to know the difference between Data Modeling, Schema and Database design? I always thought of Data Modeling and schema as defining relationships and primary and secondary key? Not sure what is meant by Database design? Is that where you put in table fields and table names?
View Replies !
ERD Tool?
I need a good ERD tool for reverse engineering a few databases. It must be able to properly reverse engineer the foreign keys and create the entity relationships for InnoDB tables. (The fabforce product does not, for example, or at least I can't figure out how to make it do so) Free is preferable, but commerical/licensed products are okay too.
View Replies !
Graphical Tool
I'm building my first MySQL database and come into trooble when trying to create constraint integrity. I'm trying to get it work by hand (notepad) but thing that it would be better to create the tables using a graphical tool, but I can't find any for MySQL.Please help by giving me URL's for graphical tools (if possible free) that manage constraint integrity.
View Replies !
Looking For Encryption Tool
I have a prospect that needs to collect sensitive personal data via the web for mortgage applications. A certificate & SSL seems to protect the data from the browser to the server, but I need some way to encrypt the data for storage in mysql and (possibly) into a flat file for retrieval by the prospect. I have not been able to find a simple solution for this compatible with BSD and Apache.
View Replies !
Php Admin Tool
I recently upgraded from phpmyadmin 2.5.0 to 2.6.3-pl1. I cannot find the functionality to 'load text files into tables'.
View Replies !
Report Tool
Is there any MySQL reporting tool that is open source and doesn't require programming knowledge? I need a front end for MySQL that will allow a user to input a couple parameters and will produce a report, including graphs. I haven't been able to find an adequate open source solution for this.
View Replies !
Migration Tool Kit
I'm new to MySQL and cannot get a connection to my database at my ISP. My ISP is lowesthosting.com they use an Apache Server. I've tried to connect using the dns # 207.44.216.56. I've also tried using my FTP address and I cannot get a connection. I get a message in the details that it will not recognize my password. I know I'm doing something wrong but can't figure out what?
View Replies !
Migration Tool
I'm new to using the Migration Tool and don't know where to look for help, so I posted here rather than the Migration Tool forum. What I am trying to do is get data from a high-traffic Oracle server over to a local MySQL so I can dissect and analyze the data with large amounts of data (with temporary query space too big for MS Access). In the migration tool is there a way to do the following: On the Oracle Server: - Select ACCOUNT_ID, CALL_DATE, CALL_TIME, CALL_RESULT from DATA_REPOSITORY.ACCOUNT_CALLS where CALL_DATE >= TO_DATE('07/01/2007','MM/DD/YYYY') and CALL_DATE <= TO_DATE('07/31/2007','MM/DD/YYYY') On the MySQL Server I want to migrate it into a local schema/table called LOCAL_PROD.CALLS_200707. The major things that I want to do here is only select the 4 fields I need out of the data repository, and I only want to do a month at a time since there is usually ~27 million records per month with data going back all the way to 2005 and I want it split up for faster querying and right now I don't care for anything before the last couple of months. Is this possible using the Migration Tool? I can connect to the Oracle DB and local MySQL fine. However, when I try to mess with the SQL statements under the Advanced options and Apply Changes, it looks like everything is going fine. However, the WHERE statement will go away during the Bulk Transfer and the process will still try to take the entire contents of DATA_REPOSITORY.ACCOUNT_CALLS and create a DATA_REPOSITORY schema on the local server and try to put the entire contents in a table of the same name. I'm open to other suggestions if the Migration Tool is not made for that kind of functionality.
View Replies !
GUI Admin Tool
I am looking for GUI tool throught which I can: Connect Remote MySQL servers Execute query in GUI tool View Records Modify Record directly by selecting and editing row. Delete tables View tables Almost, similar like what TOAD offers for Oracle. Which is suitable/best GUI tool for MySQL Admin activities.
View Replies !
MySQL GUI Tool
I just downloaded mysql but i would like to use a tool that would let me create/drop/alter tables , delete, add files etc. Which tool do you think is the BEST one for this?
View Replies !
Stand Alone SQL Tool?
i have been using SQLyog 2.5.1 for my sql administration during development. i went back onto their site to see if there were any updates and realised that they were on 3.5 and you had to register the software! (2.5.1 was freeware).
View Replies !
Database Design Tool
Is there a good (free) database design tool for windows and MySQL? I have been using DBDesigner but it seems to ignore foreign key constraints when I generate an SQL create script.
View Replies !
Tool To Produce A Shema
Is there a tool that can compare db1 with db2 and just output the SQL to make db1 look like db2?Would appreciate if that was possible in phpmyadmin either directly or with an extension if those exist.
View Replies !
MySQL Monitoring Tool
I have an application thats running 24/7 but every night its loosing connection to the database. When I restart the app in the morning it works fine again. I want to monitor the DB and the server for 24 hours to see what is causing the application to loose connection at night. The provider of the app said that the DB could be tying up too many resources and its loosing connectivity.
View Replies !
MySQL GUI Client Tool
I am looking for a gui-based open source client tool for mysql. Does anybody have any suggestion besides those listed in the first few posts in the beginning of the forum?
View Replies !
MySQL Migration Tool
how trustworthy and capable is the Migration Tool? If it says everything went smoothly does it mean that everything went smoothly? Just a little example, Access stores dates on the background in US format although it displays it to me normally in EU/Dutch format (day-month-year). This I could easily check to see if it migrated things well because I'm aware of this issue with Access. But are there any pitfalls I should look out for with this migration tool? Not sure if others have experience with it.
View Replies !
Problem With MysqlAdministrator' Tool
when I first time to login database via 'mysqlAdministrotr' with user 'root', it does not work. Then when I close it, the error message comes out like this 'Exception EAccessviolation in module libmysqladmin.dll at 000013d8 access violation at address 00AC13D8 in module 'libmysqladmin.dll'. Read'.
View Replies !
MySQL Diag Tool For XP
I have MySQL v5 installed on my XP PC. MySQL is used by another program on the same PC. Currently this other program, which I create scripts with in its' native scripting language and run within the program, is coming back with an error that says Error: Table is Read Only. I have used the MySQL GUI admin tool to look at the database that this program uses to see if I can see anything wrong, but it all looks OK. Is there a tool I can use to try and write/access the tables within this programs MySQL database so I can try and identify the offending table and maybe fix the problem.
View Replies !
Error After 30s Of Loading Via ETL Tool
Exception in component tMysqlBulkExec_4 com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Last packet sent to the server was 30074 ms ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:532) at com.mysql.jdbc.Util.handleNewInstance(Util.java:353) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2720) at com.mysql.jdbc.MysqlIO.sendFileToServer(MysqlIO.java:2798) at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2033) at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1421) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1772) at com.mysql.jdbc.Connection.execSQL(Connection.java:2430) at com.mysql.jdbc.Connection.execSQL(Connection.java:2359) at com.mysql.jdbc.Statement.execute(Statement.java:719) at datastrata.load_0_2.load.tMysqlBulkExec_4Process(load.java:1801) at datastrata.load_0_2.load.tFileExist_3Process(load.java:1735) at datastrata.load_0_2.load.tFileExist_1Process(load.java:1573) at datastrata.load_0_2.load.tFileList_1Process(load.java:4491) at datastrata.load_0_2.load.runJobInTOS(load.java:5722) at datastrata.load_0_2.load.main(load.java:5616) Caused by: java.net.SocketException: Broken pipe at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109) at java.net.SocketOutputStream.write(SocketOutputStream.java:153) at java.io.BufferedOutputStream.write(BufferedOutputStream.java:122) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2703) ... 13 more
View Replies !
A Tool That Can Compare Db Difference
I have a dev. database, and the real db. In the dev db I testing/developing all new things. I wanna ask that have the MYSQL some tool that can compare two databases (structures) to say what is the different. If it is not exists possible solution if I make two sql dump, and make a "diff" on it. But I wanna automatize it.
View Replies !
Code Coverage Tool
I am working on MySQL as well Oracle database. But I did not find any code coverage tool for mysql. In oracle, we use DBMS_PROFILER to get the code coverage. Is any similar tool available in MySQL or not?
View Replies !
Database Comparison Tool
I have 2 different servers on different machines. I would like to compare database from this server to each other. Example: I would like to compare database1 (on server 1) to database 1 (on server 2)
View Replies !
Mass Update Tool
we have so many mass upload tools, load from the file, load from other database built in. How about mass update tools? Say I have a table have 3000 products in it. I want to update the price of these 3000 products with a new table (or excel sheet) of new price by matching the product code (key).Is there a tool for that?
View Replies !
Tool To View Data
I have executed select statement using mysql command like client window. The data is garbled since there are too many columns. Do you know any good tools that I can use with mysql database to see data properly?
View Replies !
Stored Procedure Tool
I'm using mySQL 5 and i'm trying to create some stored procedures. Does anyone know what do I have to do, to make "MySQL Query Browser" works like if i was using the mySQL console ? Cause, when i try to run this code at the "MySQL Query Browser" or another mySQL query tool: DELIMITER | DROP PROCEDURE IF EXISTS sp_declareG| CREATE PROCEDURE sp_declare (P INT) BEGIN DECLARE x INT; DECLARE y INT DEFAULT 10; SET x = P*y; SELECT x; END| DELIMITER ; I get several errors. BUT, if i paste this inside the mySQL console it works FINE ! What do i have to do to make "MySQL Query Browser" works just like the console ?
View Replies !
Tool For Merging Tables
I want to merge these tables into one big table and have the original tables replaced with views. Of course I can hand hack this, but I would rather have a tool do the work for me. Is there a tool that can do this and if yes where can I get it? The tool must take care of table data, foreign keys, datatypes and allow me to select columns that are the same.
View Replies !
Where Can I Find 'crash-me' Tool
I remember I could find and use 'crash-me' tool on the mysql.com site. It was very nice to compare mysql with other database products, although not neatly arranged with too many details. Now when I go to the place (http://dev.mysql.com/tech-resources/crash-me.php), it says: Note: The crash-me table is normally generated from DBMSs started with default parameters. If this is not the case, the fact is noted in the comment row. I can I access and use the tool to compare the features of each databases?
View Replies !
Tool For Displaying The Structure Of A Db?
im trying to make sense of a large'ish mysql database with around 60 tables. are there any tools available (free or commercial) that are able to show me a visual diagram of the db, esp showing which tables are linked to other ones and what keys are used? pref a desktop app. im not interested in the content of the db at this stage, only the structure, keys, etc.
View Replies !
Multi - Database Update Tool?
I need a solution to 'simultaneously' update / insert records into multiple mySQL databases that are identical in structure. Merging the DBs is not a viable solution. I have been using phpMyAdmin to do some updates individually, but the number of DBs will be growing, so I need to find a solution. Open-source / Freeware is preferred. The DBs are managed by the same MySQL instance on a single server. The specifics are: I am running cloned Mambo content management based websites (that run on MySQL DBs) that have different content. I need a way to implement global multiple site DB changes without having to go in and edit each DB. No schema changes, just updating fields and inserting new records etc. Pre-exsisting data will not be identical in all fields. The DBs have no interaction with each other; no sharing involved. The DBs are copies of each other that are accessed independently by unique sites. I just need an admin tool that will allow me to update or insert the same record in all the DBs, in the same table in every DB.
View Replies !
Visual Tool For Database Documentation
We have a mysql database for which I would like to create a documentation. For this I am searching for some tool that can read the database structure (either from the mysql instance or from SQL code) and create a visual picture of table relationships. Does anyone know if such tool is available?
View Replies !
PDA Client Or Access Sync Tool
I have a software application with an Access front end and an Access backend to house the data. Recently I converted the backend to MySQL. The Access frontend works fine connecting to the MySQL backend. The issue I have now is that I also have a syncronized database on a PDA. I was using ActiveSync and Pocket Access to create the database on the PDA and keep it syncronized with my PC (backend) database. I'm using eVB programs to retrieve and update the data on the PDA, then all I have to do is sync the PDA with ActiveSync and it will update my Access Backend database accordingly and vise-versa. If that is not an option, on the PC side, I could keep a replicated/synchronized Access database using a third party app (like Access2MySQL Sync). I would still keep the MySQL backend, but also have a replicated/syncronized Access database strictly for use with my PDA. This would allow me to keep my ActiveSync & Pocket Access synchronization process. My problem is I can't find a third party app that actually works well enough to put into a production environment.
View Replies !
PDA Client Or Access Sync Tool?
I have a software application with an Access front end and an Access backend to house the data. Recently I converted the backend to MySQL. The Access frontend works fine connecting to the MySQL backend. The issue I have now is that I also have a syncronized database on a PDA. I was using ActiveSync and Pocket Access to create the database on the PDA and keep it syncronized with my PC (backend) database. I'm using eVB programs to retrieve and update the data on the PDA, then all I have to do is sync the PDA with ActiveSync and it will update my Access Backend database accordingly and vise-versa. I know MySQL doesn't have a PDA client, but I was wondering if anyone knew of a third party application that I might be able to use to create and sync a database on the PDA with the MySQL database on the PC. If that is not an option, on the PC side, I could keep a replicated/synchronized Access database using a third party app (like Access2MySQL Sync). I would still keep the MySQL backend, but also have a replicated/syncronized Access database strictly for use with my PDA. This would allow me to keep my ActiveSync & Pocket Access synchronization process. My problem is I can't find a third party app that actually works well enough to put into a production environment. Does anyone have any recommendations or suggestions?
View Replies !
MySql Query Checker Tool
I want to test my web site for the query load checking. Basically mine is a dynamic site where there is lots of traffic. I want to check my query with multiple requests at same time to see how it is affecting my server and how mysqld service is behaving? I have rectified all the things for my query however still some time my mysql service reaches 99% load under high traffic which leads to server crash. So if I can check my query with heavy traffic, then only I ll be able to find actual problem.
View Replies !
Command Line Tool With Another User
The command line tool runs fine upon install with the root account, but I've added a new user (newUser1) and am trying to either switch to that user from root in the command line tool or start the command line tool as that user. I can't see how to "switch" once I'm in the tool as root. I've tried --user=newUser1 (but there is no effect) I also went back to the directory where MySQL was installed (C:Program FilesMySQLMySQL Server 5.0in) in the Windows command prompt and tried to run mysql from there: Try #1 = mysql --user=newUser1 --password=xxxxxx newDataBase Result #1 = a listing of a bunch of variables and options related to MySQL, after which time it returns to the Windows command prompt Try #2 = mysql --user=newUser1 (I thought that it might prompt me for the password at that point) Result #2 = ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)
View Replies !
|
TRACKER
