Ajax based GUI for MySql
I have researched quite a lot before posting to this mailing list, so I hope this is NOT old news. I was on a quest to find tool that allows me to manage 3 different web hosting accounts each with about 6-7 MySql databases on it. The usual suspects like PhpMyAdmin were involved, of course, but failed quite badly as it is not that easy to go from one server to another and copy/replicate table structures..etc. It seems that one company made quite a nice program that would handle my requirements: NovaQuantum. If anyone has tried yet their service, I'd like to hear their thoughts about it:) Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL GUI Tools
What are the best MySQL GUI tools available at the moment, for example SQLyog. Have you tried Database Workbench (Pro) yet? See www.upscene.com With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL GUI Tools
What are the best MySQL GUI tools available at the moment, for example SQLyog. You could start with our AnySQL Maestro (free version available). http://www.sqlmaestro.com/products/anysql/maestro/ Sincerely yours, SQL Maestro Group Team http://www.sqlmaestro.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL GUI Tools
Thanks for all the feedback. Going to download all of these and see which best suits our needs. Neil On Thu, Oct 15, 2009 at 2:56 AM, Ye Yuan yuan4...@gmail.com wrote: Hi Neil, You can try toad for mysql. It is free. -- Thanks, YY
MySQL GUI Tools
What are the best MySQL GUI tools available at the moment, for example SQLyog. Thanks Neil
MySQL GUI Tools
If I am looking for a application that will connect to MySQL and allow me to make database / table / user / permission modifications via a graphical tool, is there something specific out there you guys recommend? I have been doing everything via CLI only and would like to try a GUI option if available. Anyone know if this exist for Linux? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL GUI Tools
On July 13, 2009 12:03:49 pm Carlos Williams wrote: If I am looking for a application that will connect to MySQL and allow me to make database / table / user / permission modifications via a graphical tool, is there something specific out there you guys recommend? I have been doing everything via CLI only and would like to try a GUI option if available. Anyone know if this exist for Linux? PhpMyAdmin http://www.phpmyadmin.net/home_page/index.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL GUI Tools
Yup. That was what I was looking for. Thanks! On Mon, Jul 13, 2009 at 3:27 PM, Rayr...@stilltech.net wrote: On July 13, 2009 12:03:49 pm Carlos Williams wrote: If I am looking for a application that will connect to MySQL and allow me to make database / table / user / permission modifications via a graphical tool, is there something specific out there you guys recommend? I have been doing everything via CLI only and would like to try a GUI option if available. Anyone know if this exist for Linux? PhpMyAdmin http://www.phpmyadmin.net/home_page/index.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=carlosw...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: MySQL GUI Tools
Did you even look here: http://dev.mysql.com/downloads/gui-tools/5.0.html -Original Message- From: Carlos Williams [mailto:carlosw...@gmail.com] Sent: Monday, July 13, 2009 12:43 PM To: Ray Cc: mysql@lists.mysql.com Subject: Re: MySQL GUI Tools Yup. That was what I was looking for. Thanks! On Mon, Jul 13, 2009 at 3:27 PM, Rayr...@stilltech.net wrote: On July 13, 2009 12:03:49 pm Carlos Williams wrote: If I am looking for a application that will connect to MySQL and allow me to make database / table / user / permission modifications via a graphical tool, is there something specific out there you guys recommend? I have been doing everything via CLI only and would like to try a GUI option if available. Anyone know if this exist for Linux? PhpMyAdmin http://www.phpmyadmin.net/home_page/index.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=carlosw...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=dae...@daevid.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL GUI Tools for 5.0 Release 16 for Windows available for download
On 31.01.2009 14:34 CE(S)T, Mike Lischke wrote: we are pleased to announce a new maintenance release of the legacy GUI Tools Bundle. Why is this called legacy? What's the newer/better alternative? I could not find anything like this on the MySQL website. Workbench is an E/R modeling tool. The only screenshot of it shows a database diagram. No users, tables or instances management. Enterprise Monitor seems to be a monitor only, and it's not free. -- Yves Goergen LonelyPixel nospam.l...@unclassified.de Visit my web laboratory at http://beta.unclassified.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Navicat MySQL GUI for Linux version 8.0.23 is released.
By Premiumsoft. Navicat MySQL GUI Manager is a powerful yet easy to use MySQL client provides extensive functionality for managing and developing MySQL. It features an intuitive interface and provides a set of useful tool to import/ export, backup/ restore data, Synchronize database and connect to remote MySQL server, etc. Navicat MySQL GUI ver. 8 is the latest iteration of the database management tool that offers more than 100 improvements and some new powerful features. Major new features of ver. 8 at a glance: To check out details, please see a release notes at: http://www.navicat.com/release_notes_linux.html. Major new features: 1.Code Completion - Speedup your sql writing. 2.Form View - Input record via form view. 3.Virtual Grouping - Provides better categorization for objects. 4.Event Scheduler - New MySQL feature as of MySQL 5.1. Other major features: Visual Query Builder SSH/ HTTP Tunnel for remote database connection Database transfer from server to server Data and Structure Synchronization Data backup and restore Import/ Export of most popular data formats to and from MySQL Report Builder Tasks Scheduling and Easy-to-use wizards tool. Further Enhancements: Compatible with any MySQL server version up to 5.1.x. Incremental Search, Hex Editor and more supports in Table View. Usability enhancement in Table Design. Many other improvements on features and user-friendliness. To find out more details about the product, please visit at: http://www.navicat.com/linux_detail.html -- View this message in context: http://www.nabble.com/Navicat-MySQL-GUI-for-Linux-version-8.0.23-is-released.-tp15177231p15177231.html Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Navicat MySQL GUI for Linux version 8.0.23 is released.
Hmm. Speaking of Navicat, does anybody out there have an easy way to scrub the control coding from scripts developed under Navicat? I expect that they're there mostly for coloration on displays, but it's kind of obnoxious when you want to do anything else with them. -- Barry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL admin GUI
Yes, I've been using phpmyadmin. Thanks. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -Original Message- From: Jim Ginn [mailto:[EMAIL PROTECTED] Sent: Friday, July 13, 2007 3:16 PM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: MySQL admin GUI Jerry: or: http://www.phpmyadmin.net/home_page/index.php ? Thanks! Jim Ginn http://www.Tenant.com Does anyone know how to add a field anyplace but at the bottom? I haven't found any insert here functionality. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com http://www.the-infoshop.com/ www.giiexpress.com http://www.giiexpress.com/ www.etudes-marche.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL admin GUI
Does anyone know how to add a field anyplace but at the bottom? I haven't found any insert here functionality. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com http://www.the-infoshop.com/ www.giiexpress.com http://www.giiexpress.com/ www.etudes-marche.com
Re: MySQL admin GUI
Jerry: or: http://www.phpmyadmin.net/home_page/index.php ? Thanks! Jim Ginn http://www.Tenant.com Does anyone know how to add a field anyplace but at the bottom? I haven't found any insert here functionality. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com http://www.the-infoshop.com/ www.giiexpress.com http://www.giiexpress.com/ www.etudes-marche.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL admin GUI
The only way I know how to do this with MySQL Admin is to alter the sql code it shows you after clicking apply (add and after column_name) before executing On 7/13/07 3:05 PM, Jerry Schwartz [EMAIL PROTECTED] wrote: Does anyone know how to add a field anyplace but at the bottom? I haven't found any insert here functionality. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com http://www.the-infoshop.com/ www.giiexpress.com http://www.giiexpress.com/ www.etudes-marche.com - Olaf Stein DBA Center for Quantitative and Computational Biology Columbus Children's Research Institute 700 Children's Drive phone: 1-614-355-5685 cell: 1-614-843-0432 email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL admin GUI
In the os x version I am able to insert columns anywhere I want. Now I've noticed that there's no such option in windows' version. Strange. Cheers, Mihail - Original Message - From: Olaf Stein [EMAIL PROTECTED] To: Jerry Schwartz [EMAIL PROTECTED]; MySql mysql@lists.mysql.com Sent: Fri Jul 13 15:26:00 2007 Subject: Re: MySQL admin GUI The only way I know how to do this with MySQL Admin is to alter the sql code it shows you after clicking apply (add and after column_name) before executing On 7/13/07 3:05 PM, Jerry Schwartz [EMAIL PROTECTED] wrote: Does anyone know how to add a field anyplace but at the bottom? I haven't found any insert here functionality. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com http://www.the-infoshop.com/ www.giiexpress.com http://www.giiexpress.com/ www.etudes-marche.com - Olaf Stein DBA Center for Quantitative and Computational Biology Columbus Children's Research Institute 700 Children's Drive phone: 1-614-355-5685 cell: 1-614-843-0432 email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Is there a professional quality mySQL GUI for Linux?
On Mar 15, 2007, at 4:25 AM, Daevid Vincent wrote: Can anyone recommend a real, quality, professional level mySQL GUI for Linux? KDE, Gnome, whatever. Doesn't matter. Beggars can't be choosers right. Something along the lines of SQLYog (Enterprise ideally). I'm kind of disappointed that I can't seem to find anything. They're all either some Admin tool designed to setup users and all that stuff. Yawn. Or they're so limited, I might as well just use an XP VMWare and a windows GUI client instead. Sadly SQLYog has no intentions of porting to Linux :-\ mySQL Query Browser is for the most part useless. It's v1.1.18 and gives almost no benefit to using the CLI mode. You can't sort by clicking headings. They UI is awkward to use. You can't even set the font sizes, so it's HUGE (at least in my KDE it is). mySQL Workbench is Alpha, and I couldn't even get it to connect to the localhost server (despite the other tools in that package work)!!? phpMyAdmin is wonderful -- for a Web UI tool. But not very practical for serious development. Anything else in my search is either equally amateur or simply just an inactive or dead project. How is it that mySQL is effectively a Linux native tool for all intents and purposes, yet there isn't nearly the level of GUIs for it that there are for Windows?! (Sorry Daevid, I neglected to send this to the entire list) After searching around, I settled on AquaFold's Aqua Data Studio 6.0 (www.aquafold.com). I've been using it since version 4. It is a Java app, but it is very professional and works real well. I use it on my MacBookPro as well as my Linux boxes. Not cheap though. $399 per license. However, it is the best thing around. The license allows multiple installs, but you are only allowed to run one at a time. This is a nice convenience. It also supports many databases besides MySQL. Again, expensive but worth it in terms of productivity. -Joe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there a professional quality mySQL GUI for Linux?
Can anyone recommend a real, quality, professional level mySQL GUI for Linux? KDE, Gnome, whatever. Doesn't matter. Beggars can't be choosers right. Something along the lines of SQLYog (Enterprise ideally). I'm kind of disappointed that I can't seem to find anything. They're all either some Admin tool designed to setup users and all that stuff. Yawn. Or they're so limited, I might as well just use an XP VMWare and a windows GUI client instead. Sadly SQLYog has no intentions of porting to Linux :-\ mySQL Query Browser is for the most part useless. It's v1.1.18 and gives almost no benefit to using the CLI mode. You can't sort by clicking headings. They UI is awkward to use. You can't even set the font sizes, so it's HUGE (at least in my KDE it is). mySQL Workbench is Alpha, and I couldn't even get it to connect to the localhost server (despite the other tools in that package work)!!? phpMyAdmin is wonderful -- for a Web UI tool. But not very practical for serious development. Anything else in my search is either equally amateur or simply just an inactive or dead project. How is it that mySQL is effectively a Linux native tool for all intents and purposes, yet there isn't nearly the level of GUIs for it that there are for Windows?! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Is there a professional quality mySQL GUI for Linux?
On Thu, 2007-03-15 at 01:25 -0700, Daevid Vincent wrote: Can anyone recommend a real, quality, professional level mySQL GUI for Linux? KDE, Gnome, whatever. Doesn't matter. Beggars can't be choosers right. has it got to be Free of COST and FLOSSware? If Not, then consider Aqua Data Studio. Looks and works nicely. Java Based though.. so it's a resource hog -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Is there a professional quality mySQL GUI for Linux?
No, it doesn't have to be free. However I'm not a big fan of Java Applications either for the very reason you mention. They tend to be big, bloated and slow. Zend IDE is an example of that, and is mostly unuseable for real work IMHO. Whoa! $400 for single license! Yipes! http://www.aquafold.com/licensing.html -Original Message- From: Ow Mun Heng [mailto:[EMAIL PROTECTED] Sent: Thursday, March 15, 2007 1:37 AM To: Daevid Vincent Cc: mysql@lists.mysql.com Subject: Re: Is there a professional quality mySQL GUI for Linux? On Thu, 2007-03-15 at 01:25 -0700, Daevid Vincent wrote: Can anyone recommend a real, quality, professional level mySQL GUI for Linux? KDE, Gnome, whatever. Doesn't matter. Beggars can't be choosers right. has it got to be Free of COST and FLOSSware? If Not, then consider Aqua Data Studio. Looks and works nicely. Java Based though.. so it's a resource hog -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Is there a professional quality mySQL GUI for Linux?
No, it doesn't have to be free. However I'm not a big fan of Java What about using Wine? Ours works fine under Wine. Or you could try the one at www.sqlly.com Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Is there a professional quality mySQL GUI for Linux?
I use SQLYog emulated with wine and/or cross over office it works 100% fine :D wine sqlyog.exe Next Next Next Finish :D On 3/15/07, Daevid Vincent [EMAIL PROTECTED] wrote: Can anyone recommend a real, quality, professional level mySQL GUI for Linux? KDE, Gnome, whatever. Doesn't matter. Beggars can't be choosers right. Something along the lines of SQLYog (Enterprise ideally). I'm kind of disappointed that I can't seem to find anything. They're all either some Admin tool designed to setup users and all that stuff. Yawn. Or they're so limited, I might as well just use an XP VMWare and a windows GUI client instead. Sadly SQLYog has no intentions of porting to Linux :-\ mySQL Query Browser is for the most part useless. It's v1.1.18 and gives almost no benefit to using the CLI mode. You can't sort by clicking headings. They UI is awkward to use. You can't even set the font sizes, so it's HUGE (at least in my KDE it is). mySQL Workbench is Alpha, and I couldn't even get it to connect to the localhost server (despite the other tools in that package work)!!? phpMyAdmin is wonderful -- for a Web UI tool. But not very practical for serious development. Anything else in my search is either equally amateur or simply just an inactive or dead project. How is it that mySQL is effectively a Linux native tool for all intents and purposes, yet there isn't nearly the level of GUIs for it that there are for Windows?! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- -- Thiago LPS C.E.S.A.R - Administrador de Sistemas msn: [EMAIL PROTECTED] 0xx 81 8735 2591 --
RE: Is there a professional quality mySQL GUI for Linux?
I trade between SQLYog and SQL Exporer plugin for Eclipse. The former only shows 1 result set at a time (boo) while the latter shows more than one (yeah!) The former doesn't let you sort columns from your own query, only the table preview. The latter doesn't let you sort the columns. Neither one is perfect. Tim -Original Message- From: Daevid Vincent [mailto:[EMAIL PROTECTED] Sent: Thursday, March 15, 2007 4:26 AM To: mysql@lists.mysql.com Subject: Is there a professional quality mySQL GUI for Linux? Can anyone recommend a real, quality, professional level mySQL GUI for Linux? KDE, Gnome, whatever. Doesn't matter. Beggars can't be choosers right. Something along the lines of SQLYog (Enterprise ideally). I'm kind of disappointed that I can't seem to find anything. They're all either some Admin tool designed to setup users and all that stuff. Yawn. Or they're so limited, I might as well just use an XP VMWare and a windows GUI client instead. Sadly SQLYog has no intentions of porting to Linux :-\ mySQL Query Browser is for the most part useless. It's v1.1.18 and gives almost no benefit to using the CLI mode. You can't sort by clicking headings. They UI is awkward to use. You can't even set the font sizes, so it's HUGE (at least in my KDE it is). mySQL Workbench is Alpha, and I couldn't even get it to connect to the localhost server (despite the other tools in that package work)!!? phpMyAdmin is wonderful -- for a Web UI tool. But not very practical for serious development. Anything else in my search is either equally amateur or simply just an inactive or dead project. How is it that mySQL is effectively a Linux native tool for all intents and purposes, yet there isn't nearly the level of GUIs for it that there are for Windows?! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Is there a professional quality mySQL GUI for Linux?
Tim Lucia [EMAIL PROTECTED] wrote on 03/15/2007 07:47:29 AM: I trade between SQLYog and SQL Exporer plugin for Eclipse. The former only shows 1 result set at a time (boo) while the latter shows more than one (yeah!) The former doesn't let you sort columns from your own query, only the table preview. The latter doesn't let you sort the columns. Neither one is perfect. Tim SQLYog 5.25 was just released and it now allows multiple result sets (one per query tab). There is also a beta release of a new monitoring tool. Donna
RE: Is there a professional quality mySQL GUI for Linux?
I have upgraded to 5.25 today and it is true. Outstanding! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 15, 2007 12:16 PM To: mysql@lists.mysql.com Subject: RE: Is there a professional quality mySQL GUI for Linux? Tim Lucia [EMAIL PROTECTED] wrote on 03/15/2007 07:47:29 AM: I trade between SQLYog and SQL Exporer plugin for Eclipse. The former only shows 1 result set at a time (boo) while the latter shows more than one (yeah!) The former doesn't let you sort columns from your own query, only the table preview. The latter doesn't let you sort the columns. Neither one is perfect. Tim SQLYog 5.25 was just released and it now allows multiple result sets (one per query tab). There is also a beta release of a new monitoring tool. Donna -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What is your favorite GUI tool for creating and querying tables in MySQL?
Hi, What is your favorite GUI tool for working with MySQL. EMS SQL Manager is feature-rich but sometimes buggy and also very expensive. Navicat is not very handy. It forces to switch between mouse and keyboard repeatedly. What is your favorite tool? Regards, Behi -- Science is a differential equation. Religion is a boundary condition - Alan Turing Behrang Saeedzadeh http://www.jroller.com/page/behrangsa http://my.opera.com/behrangsa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is your favorite GUI tool for creating and querying tables in MySQL?
Hi, What is your favorite GUI tool for working with MySQL. EMS SQL Manager is feature-rich but sometimes buggy and also very expensive. Navicat is not very handy. It forces to switch between mouse and keyboard repeatedly. What is your favorite tool? Mine is Database Workbench, but hey, I'm biased, being the creator and all. www.upscene.com Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is your favorite GUI tool for creating and querying tables in MySQL?
sqlyog is pretty nice: http://www.webyog.com/ saqib http://www.full-disk-encryption.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is your favorite GUI tool for creating and querying tables in MySQL?
and also http://fabforce.net/dbdesigner4/ sorry for 2 seperate emails. saqib http://www.full-disk-encryption.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is your favorite GUI tool for creating and querying tables in MySQL?
On 12/21/06, Behrang Saeedzadeh [EMAIL PROTECTED] wrote: Hi, What is your favorite GUI tool for working with MySQL. EMS SQL Manager is feature-rich but sometimes buggy and also very expensive. Navicat is not very handy. It forces to switch between mouse and keyboard repeatedly. What is your favorite tool? I've always found the MySQL Query Browser to be rather handy for creating querying tables. http://dev.mysql.com/downloads/gui-tools/5.0.html -- Kevin. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
GUI Tools Book and the ID mapping machinery
The MySQL GUI tools have been available as a suite of all tools for quite a while (http://dev.mysql.com/downloads/gui-tools/5.0.html). Therefore, it seemed logical to also provide a single manual covering all tools (MySQL Administrator, MySQL Query Browser, MySQL Migration Toolkit, and MySQL Workbench). We've done this now, and will remove the individual manuals once we're able to provide all formats. At the moment, we're providing PDF only: See http://dev.mysql.com/doc/#gui-tools. Combining the individual manuals into one GUI tools book has become possible due to our newly created ID mapping machinery. It allows us to compile customised documentation out of anything that's a DocBook XML file. The main problem is that there will be broken links in that customised document, and that's what the mapping machinery takes care of. With this in place, we could even create a customised manual that would consist of the introduction to the MySQL server, the GUI tools' table editor, and a chapter from the Cluster NDB API manual. Not that this would necessarily make a lot of sense ... But if you have a need for a senseful combination of MySQL documentation excerpts, don't hesitate to ask us for this! If it's possible to create (there are still a few limitations), we'll make it available to you, and/or to the general public. Regards, Stefan -- Stefan Hinz [EMAIL PROTECTED] MySQL AB Documentation Team Lead. Berlin, Germany (UTC +2:00) Skype:stefanhinz Cell:+491777841069 Desk:+493082702940 Fax:+493082702941 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Benchmarking GUI tool
Hello, Does anybody know a Benchmarking GUI tool for MySQL under windows? Thanks, Mic signature.asc Description: OpenPGP digital signature
Re: MySql GUI
OK, so I suggested phpMyAdmin. Dan Trainor said: I highly suggest staying away from PHPMyAdmin. and, even more helpfully, 'Anthony' wrote: :-\ Fine - from this I gather phpMyAdmin is perhaps not a Good Thing. Now, given that I'm a relative newbie to all this, can someone please tell me why in slightly more coherent terms? So far, I've found it very useful. -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ If you have to ask what jazz is, you'll never know. -- Louis Armstrong -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql GUI
Hi Chris, I would agree, I have found it useful as well. It does have a few limitations (well the versions I've used) but once it is up and running, it works fine. eg. It doesn't help with replication, amongst a few others. I use it internally within an intranet so there isn't much of a security issue. Perhaps that was the intent? I'm a bit confused by the responses also. Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +618 8408 4273 _/ _/ _/_/_/ Mobile: 0417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Chris Sansom [mailto:[EMAIL PROTECTED] Sent: Wednesday, 31 May 2006 6:32 PM To: MySQL List Subject: Re: MySql GUI OK, so I suggested phpMyAdmin. Dan Trainor said: I highly suggest staying away from PHPMyAdmin. and, even more helpfully, 'Anthony' wrote: !!! ! :-\ Fine - from this I gather phpMyAdmin is perhaps not a Good Thing. Now, given that I'm a relative newbie to all this, can someone please tell me why in slightly more coherent terms? So far, I've found it very useful. -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ If you have to ask what jazz is, you'll never know. -- Louis Armstrong -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql GUI
At 19:44 +1000 31/5/06, Logan, David (SST - Adelaide) wrote: I would agree, I have found it useful as well. It does have a few limitations (well the versions I've used) Actually, having just mildly sung its praises, there do seem to be some bugs in the latest version I installed on my local machine (2.8.1). However... eg. It doesn't help with replication, amongst a few others. This is beyond my modest needs at the moment. I use it internally within an intranet so there isn't much of a security issue. Perhaps that was the intent? I'm a bit confused by the responses also. I use it in two situations: on my own Mac (my development platform, if you like, but also the computer I use for everything :-) ), where it's all within my local 192.168.x.y setup, so no security problems there. It's also provided by the two hosts I use as part of their 'control panel' systems (which include general account management, webmail and all the rest), so it's not installed in my web root folder - I certainly wouldn't particularly want to do that. So... what's the problem? OK, it's a bit flaky in places, but perfectly usable, and I've never had it do anything nasty to any of the small databases I manage. Furthermore, I've just downloaded the two suggested packages from mysql.net - MySQL Query Browser and MySQL Administrator - and while I can use them locally they're no use on the main host I use because they require MySQL 4.x and - until they get round to a long promised upgrade - the host's still running 3.23. -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ War is only a cowardly escape from the problems of peace. -- Thomas Mann -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql GUI
Chris Sansom wrote: At 19:44 +1000 31/5/06, Logan, David (SST - Adelaide) wrote: I would agree, I have found it useful as well. It does have a few limitations (well the versions I've used) BTW, what are the limits on OpenOffice's Base being used as a front end? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql GUI
Chris Sansom wrote: OK, so I suggested phpMyAdmin. Dan Trainor said: I highly suggest staying away from PHPMyAdmin. and, even more helpfully, 'Anthony' wrote: :-\ Fine - from this I gather phpMyAdmin is perhaps not a Good Thing. Now, given that I'm a relative newbie to all this, can someone please tell me why in slightly more coherent terms? So far, I've found it very useful. I do suggest using phpMyAdmin, it is a great tool, as long as you use a stable version, i have been using it for the past 4years, and i have always been satisfied from it, and there is also http://phppgadmin.sourceforge.net/ for Postgres users i have noticed that my answer was missunderstood, i was shocked why does 'Dan' suggested staying away from it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql GUI
Dan Trainor wrote: I highly suggest staying away from PHPMyAdmin. :-\ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql GUI
At 10:23 +0200 30/5/06, Anthony wrote: :-\ Very helpful - thanks. -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ What contemptible scoundrel has stolen the cork to my lunch? -- W.C. Fields -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySql GUI
Hello I understand that there is a free gui that will allow an administrator or user to create databases and maybe even add, update and modify rows in tables. It is something like MySQL Controller. Does this still exist and what is the link? Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql GUI
At 12:31 -0700 29/5/06, AndrewMcHorney wrote: I understand that there is a free gui that will allow an administrator or user to create databases and maybe even add, update and modify rows in tables. It is something like MySQL Controller. Does this still exist and what is the link? Maybe you're thinking of pypMyAdmin? http://www.phpmyadmin.net/ -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ I've never had major knee surgery on any other part of my body. -- Winston Bennett, University of Kentucky basketball forward -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql GUI
On Monday 29 May 2006 21:31, AndrewMcHorney wrote: Hello I understand that there is a free gui that will allow an administrator or user to create databases and maybe even add, update and modify rows in tables. It is something like MySQL Controller. Does this still exist and what is the link? Andrew Try searching for MySQL Control Centre. IIRC it's not maintained anymore but still useable. ( Qt-based so Cross-platform ) Kind Regards, Peter -- This message was scanned with clamAV version 0.88, clamav-milter version 0.87. and is guaranteed free of viruses. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql GUI
AndrewMcHorney wrote: Hello I understand that there is a free gui that will allow an administrator or user to create databases and maybe even add, update and modify rows in tables. It is something like MySQL Controller. Does this still exist and what is the link? Andrew Hi - MySQL Query Browser and MySQL Administrator can both be found on MySQL's Download section. I believe this is what you are looking for. I highly suggest staying away from PHPMyAdmin. Thanks -dant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql GUI
At 14:02 -0700 29/5/06, Dan Trainor wrote: I highly suggest staying away from PHPMyAdmin. Why in particular? -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ The world is proof that God is a committee. -- Bob Stokes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Many sources are in correct. For example the Gui Tools.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 What has happended to all the bk repo's? The documentation says there there but they are not. For example. http://dev.mysql.com/doc/administrator/en/mysql-gui-install-source-download.html http://dev.mysql.com/doc/query-browser/en/mysql-gui-install-source-download.html http://dev.mysql.com/doc/refman/4.1/en/development-source.html http://dev.mysql.com/doc/refman/5.0/en/development-source.html http://dev.mysql.com/doc/refman/5.1/en/development-source.html I know some have gone to SVN where are the publice repo's? Thanks, - -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 1042 East Fort Union #135, Midvale Utah 84047 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQFERYIwVtBjDid73eYRAul8AJ43E+aH4Y41gjmOp45fd3zPrMfNWQCdEOhx JEhK1BR7c6+kRzpyeislKvI= =HOJg -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Many sources are in correct. For example the Gui Tools.
On Tue, Apr 18, 2006 at 06:19:53PM -0600, Boyd Lynn Gerber wrote: What has happended to all the bk repo's? The documentation says there there but they are not. For example. http://dev.mysql.com/doc/administrator/en/mysql-gui-install-source-download.html http://dev.mysql.com/doc/query-browser/en/mysql-gui-install-source-download.html http://dev.mysql.com/doc/refman/4.1/en/development-source.html http://dev.mysql.com/doc/refman/5.0/en/development-source.html http://dev.mysql.com/doc/refman/5.1/en/development-source.html I know some have gone to SVN where are the publice repo's? You can find the SVN repositories for the GUI tools and Connectors at http://svn.mysql.com/ The server repositories are still at http://mysql.bkbits.net/ Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Many sources are in correct. For example the Gui Tools.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 What has happended to all the bk repo's? The documentation says there there but they are not. For example. http://dev.mysql.com/doc/administrator/en/mysql-gui-install-source-download.html http://dev.mysql.com/doc/query-browser/en/mysql-gui-install-source-download.html http://dev.mysql.com/doc/refman/4.1/en/development-source.html http://dev.mysql.com/doc/refman/5.0/en/development-source.html http://dev.mysql.com/doc/refman/5.1/en/development-source.html I know some have gone to SVN where are the publice repo's? They have all been moved into a new mailing list so that we can keep the support questions separate from the development updates. Check here: http://lists.mysql.com and look for MySQL Commits I know about the commits list. Before on mysql.bkbits.net connector-net myodbc-3.52 myodbc-3.53 myodbc3 mysql-5.1 mysql-administrator mysql-com-sign-up mysql-gui-common mysql-instance-config mysql-query-browser mysql-server-setup mysqlcc mysqldoc and these that are still there. mysql-5.1-new mysql-3.23 eventum mysql-4.0 mysql-4.1 mysql-5.0 mysql-5.2 mysql-bench The mysqldos is now in svn and there have been talk about making a public snv for it. The others are gone and I have not idea where they went. I am asking about the public repositories. Not the forums, email or other lists. Thanks, - -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 1042 East Fort Union #135, Midvale Utah 84047 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQFERaygVtBjDid73eYRApBQAKCJDh8zT72RaX0WXAi+7gALLqzehQCeNJc+ c8HSLttf+0NQ0bf1lDC3GzM= =lZgO -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: GUI Tools for administering and reporting
You could try Cacti, it can graph applications as well as poll node health and statistics e.t.c. Cacti is a complete network graphing solution designed to harness the power of RRDTool's data storage and graphing functionality. Cacti provides a fast poller, advanced graph templating, multiple data acquisition methods, and user management features out of the box. All of this is wrapped in an intuitive, easy to use interface that makes sense for LAN-sized installations up to complex networks with hundreds of devices. http://www.cacti.net/download_cacti.php hope this helps All, Is there a recommended GUI that will administer multiple MySQL 4.x databases. I need the ability to monitor connections, health, users, etc. and notify me when there is a problem with an instance. Regards, Alan L. Fisher GPI -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
GUI Tools for administering and reporting
All, Is there a recommended GUI that will administer multiple MySQL 4.x databases. I need the ability to monitor connections, health, users, etc. and notify me when there is a problem with an instance. Regards, Alan L. Fisher GPI -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: GUI Tools for administering and reporting
On 3/17/06, Alan Fisher [EMAIL PROTECTED] wrote: All, Is there a recommended GUI that will administer multiple MySQL 4.x databases. I need the ability to monitor connections, health, users, etc. and notify me when there is a problem with an instance. Regards, Alan L. Fisher GPI -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] MySQL Administrator can do that... But the notify stuff can be a little hard to obtain in a free tool, in windows you could schedule a task to see how things are running or simply parse the logs for information with another program. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: GUI Tools for administering and reporting
http://nagios.org We use that to monitor dozens of servers, over 1000 individual items (disk space, web server up/down, etc). We also do some heavy monitoring of oracle databases and some moderate mysql monitoring. It can be easily adapted to do what you want. And it's free! Dan. -Original Message- From: Daniel da Veiga [mailto:[EMAIL PROTECTED] Sent: Friday, March 17, 2006 12:56 PM To: mysql@lists.mysql.com Subject: Re: GUI Tools for administering and reporting On 3/17/06, Alan Fisher [EMAIL PROTECTED] wrote: All, Is there a recommended GUI that will administer multiple MySQL 4.x databases. I need the ability to monitor connections, health, users, etc. and notify me when there is a problem with an instance. Regards, Alan L. Fisher GPI -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] MySQL Administrator can do that... But the notify stuff can be a little hard to obtain in a free tool, in windows you could schedule a task to see how things are running or simply parse the logs for information with another program. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- This message has been scanned for viruses by TechTeam's email gateway. -- This e-mail transmission is strictly confidential and intended solely for the person or organization to whom it is addressed. It may contain privileged and confidential information and if you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this e-mail in error, please notify the sender as soon as possible and delete the e-mail message and any attachment(s). This message has been scanned for viruses by TechTeam's email gateway. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
data entry GUI
Just as there's MySQL Query Browser for queries and table design, is there a similar GUI front end for data entry? I'm not building anything complex, just a simple database to muck with. Is it easier to do data entry on a spreadsheet, then import the spreadsheet? Seems a bit silly, but it seems to be either that or mysql insert into A (one, two, three) values (1 , 2, 3); Either option seems a bit much. Perhaps there's something akin to Access's form builder? -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: data entry GUI
On 2/1/06, THUFIR HAWAT [EMAIL PROTECTED] wrote: Just as there's MySQL Query Browser for queries and table design, is there a similar GUI front end for data entry? I'm not building anything complex, just a simple database to muck with. Is it easier to do data entry on a spreadsheet, then import the spreadsheet? Seems a bit silly, but it seems to be either that or I can't recommend a GUI data entry tool but the way I would do it is to use a spreadsheet and save out as Tab-delimited format. Depending on the data I might also rustle up a Perl program to create the data automatically. I would then use LOAD DATA INFILE statement or mysqlimport to get the data into my tables. These methods are extremely quick for inserts and will disable key updating etc. Regards, Imran -- http://www.ImranChaudhry.info MySQL Database Management Design Services -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: data entry GUI
You can also install MyODBC and then hook an Excel spreadsheet into your database. Editing the spreadsheet will update data in your database. This isn't a good solution if you are going to be creating new tables often. But for manipulating data in a known set of tables it's great. -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: data entry GUI
I have just caught the end of this topic, so hope I'm not repeating something already mentioned. What I do is enter my data into a plain text file, like this; The questions are a bit dumb, just for testing purposes of course! /* file: general-quizdata.sql */ /* data to populate general knowledge quiz tables */ use web_app_tester; insert into question set question_text = 'What is the Capital of England?'; select @questionID := last_insert_id(); insert into answer set answer_text = 'London', status = 'right', questionID = @questionID; insert into answer set answer_text = 'Paris', questionID = @questionID; insert into answer set answer_text = 'Edinburgh', questionID = @questionID; insert into question set question_text = 'How many yards are there in a mile?'; select @questionID := last_insert_id(); insert into answer set answer_text = '5000', questionID = @questionID; insert into answer set answer_text = '1760', status = 'right', questionID = @questionID; insert into answer set answer_text = '2500', questionID = @questionID; insert into question set question_text = 'What are the 3 primary colors?'; select @questionID := last_insert_id(); insert into answer set answer_text = 'Red, Grey, Black', questionID = @questionID; insert into answer set answer_text = 'Yellow, White, Blue', questionID = @questionID; insert into answer set answer_text = 'Green, Blue, Red', status = 'right', questionID = @questionID; insert into question set question_text = 'RAM is an acronym for?'; select @questionID := last_insert_id(); insert into answer set answer_text = 'Random Access Memory', status = 'right', questionID = @questionID; insert into answer set answer_text = 'Read Access Memory', questionID = @questionID; insert into answer set answer_text = 'Read And Memorise', questionID = @questionID; /* data truncated here for brevity */ /* end of data */ and then load it into mysql from the mysql command prompt with: mysql \. general-quizdata.sql This may seem like the long-winded version of LOAD DATA, but it does make the syntax easier to understand, plus you can put any other mysql commands in the file. Also you have the data and commands available in a file, in case you have to reload the table from scratch again. HTH Keith In theory, theory and practice are the same; In practice they are not. On Wed, 1 Feb 2006, Ryan Stille wrote: To: mysql@lists.mysql.com From: Ryan Stille [EMAIL PROTECTED] Subject: RE: data entry GUI You can also install MyODBC and then hook an Excel spreadsheet into your database. Editing the spreadsheet will update data in your database. This isn't a good solution if you are going to be creating new tables often. But for manipulating data in a known set of tables it's great. -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Alternative Mysql gui than Navicat for OSX
What is it you are looking for in the application? I use DBVisualizer free version for most of my mysql and oracle use. You can give it a try and see if you like it or not. On 1/2/06, Dan Rossi [EMAIL PROTECTED] wrote: Hi there i am looking for an alternative gui app than navicat for osx. Ive used CocoaMysql in the past and is limited in terms of administration, however has more working features than navicat ever does. I assumed this product was pretty good, however after purchasing boy was i wrong. I wished SqlYog had an osx version as it is a very good application. These people have extremely poor support and have features missing out of it which should be in there in the first place, like advanced dump options like adding bloody drop table statements LOL, they claimed its a feature request. Im really peeved now so i am telling people not to buy this product they are ignoring all my tickets now. The application systematically crashes just doing something simple , i cannot find any crash logs in the normal places osx apps usually use, and ive just found thats its storing saved queries and saved views in a folder called osx in my /Applications root folder not in the Navicat folder or a preference folder ! I had no idea what it is and like to clean my machine up alot and kept trashing it and couldnt work out why the saved queries went missing, this is extremely poor programming. So dont buy navicat , stick with the terminal client :D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- http://chatter.mirislam.com/
Alternative Mysql gui than Navicat for OSX
Hi there i am looking for an alternative gui app than navicat for osx. Ive used CocoaMysql in the past and is limited in terms of administration, however has more working features than navicat ever does. I assumed this product was pretty good, however after purchasing boy was i wrong. I wished SqlYog had an osx version as it is a very good application. These people have extremely poor support and have features missing out of it which should be in there in the first place, like advanced dump options like adding bloody drop table statements LOL, they claimed its a feature request. Im really peeved now so i am telling people not to buy this product they are ignoring all my tickets now. The application systematically crashes just doing something simple , i cannot find any crash logs in the normal places osx apps usually use, and ive just found thats its storing saved queries and saved views in a folder called osx in my /Applications root folder not in the Navicat folder or a preference folder ! I had no idea what it is and like to clean my machine up alot and kept trashing it and couldnt work out why the saved queries went missing, this is extremely poor programming. So dont buy navicat , stick with the terminal client :D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: GUI (linux X based or web based) for mysql
On 12/31/05, Mechtilde Stehmann [EMAIL PROTECTED] wrote: Hello, Dotan Cohen schrieb: I keep a lot of personal information in a MySQL database. I have a few querys premade for the wife to use, but we have gotten to the point where we need a solution for her to be able to run her own queries. She is NOT about to learn SQL, and myPHPadmin is a little too compicated. I looked at an Access installation the other day and it seemed to be just what we need- a GUI for non-programmers to use a database. Is there any such beast for MySQL? Anthing that will run on Fedora Core 4 would be great. Or even a web-based solution would be fine- I do have apache on localhost. You can use OpenOffice.org 2.0 via ODBC or JDBC and you can use a GUI nearly like Access under Linux. Mechtilde Thanks. I was directed earlier to Base as an option. While it works, it is very complicated for the non-techie, so what I did was write a few simple php scripts for common queries and we run that in firefox. As I already run apache on the machine, this was not much trouble. Another plus is that the querys are available on the other machine on the home network- we just surf to the machine's IP address. Dotan Cohen http://technology-sleuth.com/question/why_are_internet_greeting_cards_dangerous.html *-
Re: GUI (linux X based or web based) for mysql
Hello, Dotan Cohen schrieb: I keep a lot of personal information in a MySQL database. I have a few querys premade for the wife to use, but we have gotten to the point where we need a solution for her to be able to run her own queries. She is NOT about to learn SQL, and myPHPadmin is a little too compicated. I looked at an Access installation the other day and it seemed to be just what we need- a GUI for non-programmers to use a database. Is there any such beast for MySQL? Anthing that will run on Fedora Core 4 would be great. Or even a web-based solution would be fine- I do have apache on localhost. You can use OpenOffice.org 2.0 via ODBC or JDBC and you can use a GUI nearly like Access under Linux. Mechtilde -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: GUI (linux X based or web based) for mysql
Dotan Cohen wrote: I keep a lot of personal information in a MySQL database. I have a few querys premade for the wife to use, but we have gotten to the point where we need a solution for her to be able to run her own queries. She is NOT about to learn SQL, and myPHPadmin is a little too compicated. I looked at an Access installation the other day and it seemed to be just what we need- a GUI for non-programmers to use a database. Is there any such beast for MySQL? Anthing that will run on Fedora Core 4 would be great. Or even a web-based solution would be fine- I do have apache on localhost. I have a number of open-source Perl projects that may help you out, at: http://entropy.homelinux.org/axis_not_evil They're more targetted at developers than end-users at the moment ... I have plans ... Anyway, with minimal effort you can get a very nice looking Gtk2-based GUI going with the help of Glade to make your interface, and a couple of lines of Perl code to connect your database to your GUI. The current release of Gtk2::Ex::DBI ( you just motivated me to make the next release, which I'd been procrastinating over for ages ) has a built-in search dialog, that you can trigger in 2 ways - by right-clicking in a field in the GUI and selecting 'find' from the context-sensitive menu, or by putting a button on your form and connecting it to the find_dialog() method of Gtk2::Ex::DBI. This will give you a dialog that lets you add criteria that gets appended to the 'where' clause of the query ... ie it doesn't do a slow search on every record ( like Access ), but lets you send your criteria to the database for rapid results. Admittedly, the documentation is a little sparse, but I'm working on a nice demo application that shows off all the features of the 3 modules. Hopefully over Christmas I'll get time to finish it off. Oh yeah ... did I mention that it's all cross-platform goodness? :) I've tested on Linux, Windows 2000 and OS-X. You will of course need to install Gtk2 for the last 2, but it's not that hard - at least on Windows. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: GUI (linux X based or web based) for mysql
On 12/18/05, Daniel Kasak [EMAIL PROTECTED] wrote: Dotan Cohen wrote: I keep a lot of personal information in a MySQL database. I have a few querys premade for the wife to use, but we have gotten to the point where we need a solution for her to be able to run her own queries. She is NOT about to learn SQL, and myPHPadmin is a little too compicated. I looked at an Access installation the other day and it seemed to be just what we need- a GUI for non-programmers to use a database. Is there any such beast for MySQL? Anthing that will run on Fedora Core 4 would be great. Or even a web-based solution would be fine- I do have apache on localhost. I have a number of open-source Perl projects that may help you out, at: http://entropy.homelinux.org/axis_not_evil They're more targetted at developers than end-users at the moment ... I have plans ... Anyway, with minimal effort you can get a very nice looking Gtk2-based GUI going with the help of Glade to make your interface, and a couple of lines of Perl code to connect your database to your GUI. The current release of Gtk2::Ex::DBI ( you just motivated me to make the next release, which I'd been procrastinating over for ages ) has a built-in search dialog, that you can trigger in 2 ways - by right-clicking in a field in the GUI and selecting 'find' from the context-sensitive menu, or by putting a button on your form and connecting it to the find_dialog() method of Gtk2::Ex::DBI. This will give you a dialog that lets you add criteria that gets appended to the 'where' clause of the query ... ie it doesn't do a slow search on every record ( like Access ), but lets you send your criteria to the database for rapid results. Admittedly, the documentation is a little sparse, but I'm working on a nice demo application that shows off all the features of the 3 modules. Hopefully over Christmas I'll get time to finish it off. Oh yeah ... did I mention that it's all cross-platform goodness? :) I've tested on Linux, Windows 2000 and OS-X. You will of course need to install Gtk2 for the last 2, but it's not that hard - at least on Windows. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au Thanks. I'll probably take a look at that soon. I don't know any perl, so I'll probably go with the Base solution, but this does look good. Dotan Cohen http://technology-sleuth.com/technical_answer/what_are_the_advantages_of_lcd_monitors.html +
GUI (linux X based or web based) for mysql
I keep a lot of personal information in a MySQL database. I have a few querys premade for the wife to use, but we have gotten to the point where we need a solution for her to be able to run her own queries. She is NOT about to learn SQL, and myPHPadmin is a little too compicated. I looked at an Access installation the other day and it seemed to be just what we need- a GUI for non-programmers to use a database. Is there any such beast for MySQL? Anthing that will run on Fedora Core 4 would be great. Or even a web-based solution would be fine- I do have apache on localhost. Thank you. Dotan Cohen http://technology-sleuth.com/question/why_are_internet_greeting_cards_dangerous.html
Re: GUI (linux X based or web based) for mysql
Dotan Cohen wrote: I keep a lot of personal information in a MySQL database. I have a few querys premade for the wife to use, but we have gotten to the point where we need a solution for her to be able to run her own queries. She is NOT about to learn SQL, and myPHPadmin is a little too compicated. I looked at an Access installation the other day and it seemed to be just what we need- a GUI for non-programmers to use a database. Is there any such beast for MySQL? Anthing that will run on Fedora Core 4 would be great. Or even a web-based solution would be fine- I do have apache on localhost. Check out Open Office 2.0 and its Base app, available in windows and *nix versions. I think it can use MySQL through either ODBC or JDBC connectors, though I haven't played with it much (yet) to evaluate it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: GUI (linux X based or web based) for mysql
On 12/16/05, Greg Maruszeczka [EMAIL PROTECTED] wrote: Dotan Cohen wrote: I keep a lot of personal information in a MySQL database. I have a few querys premade for the wife to use, but we have gotten to the point where we need a solution for her to be able to run her own queries. She is NOT about to learn SQL, and myPHPadmin is a little too compicated. I looked at an Access installation the other day and it seemed to be just what we need- a GUI for non-programmers to use a database. Is there any such beast for MySQL? Anthing that will run on Fedora Core 4 would be great. Or even a web-based solution would be fine- I do have apache on localhost. Check out Open Office 2.0 and its Base app, available in windows and *nix versions. I think it can use MySQL through either ODBC or JDBC connectors, though I haven't played with it much (yet) to evaluate it. Thanks, I will take a look at it. I thought that Base uses it's own database backend- otherwise whoever wants to install a complete OO package must then also install mysql. We already use OO apps (Writer and Calc), so this is not a problem. Dotan http://technology-sleuth.com/technical_answer/what_are_the_advantages_of_lcd_monitors.html :
Re: simple data GUI editor?
I have been using and would highly recommend SQLyog from http://www.webyog.com Regards, Ritesh --- D_C [EMAIL PROTECTED] wrote: i was wondering if people can recommend a simple Excel like tool for editing data? MySql control center - seems to have limitations (unicode, not in dev anymore) Query browser - have to type raw sql to show/hide columns... ideally i want something with a few more features than either of these, eg list data in a vertical table rather than just horizontal... lookups to other tables but more oriented to lots of interactive editing of the DB data than DB admin. I guess more like an Access GUI... (puts on flame pants) + ideally not very expensive :-) thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: simple data GUI editor?
Have you tried SQLyog? Somehow I prefer it more then MySQL-Front. Regards, Karam --- Carl [EMAIL PROTECTED] wrote: We use MySQL-Front from Star-Tools GmbH (www.mysqlfront.de)... works pretty much like you have asked. Thanks, Car - Original Message - From: Berman, Mikhail [EMAIL PROTECTED] To: mysql@lists.mysql.com Cc: D_C [EMAIL PROTECTED] Sent: Friday, June 17, 2005 4:36 PM Subject: RE: simple data GUI editor? Well, Actually MS-Access through ODBC should work for you -Original Message- From: D_C [mailto:[EMAIL PROTECTED] Sent: Friday, June 17, 2005 4:28 PM To: mysql@lists.mysql.com Subject: simple data GUI editor? i was wondering if people can recommend a simple Excel like tool for editing data? MySql control center - seems to have limitations (unicode, not in dev anymore) Query browser - have to type raw sql to show/hide columns... ideally i want something with a few more features than either of these, eg list data in a vertical table rather than just horizontal... lookups to other tables but more oriented to lots of interactive editing of the DB data than DB admin. I guess more like an Access GUI... (puts on flame pants) + ideally not very expensive :-) thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.5/18 - Release Date: 6/15/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.5/18 - Release Date: 6/15/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
simple data GUI editor?
i was wondering if people can recommend a simple Excel like tool for editing data? MySql control center - seems to have limitations (unicode, not in dev anymore) Query browser - have to type raw sql to show/hide columns... ideally i want something with a few more features than either of these, eg list data in a vertical table rather than just horizontal... lookups to other tables but more oriented to lots of interactive editing of the DB data than DB admin. I guess more like an Access GUI... (puts on flame pants) + ideally not very expensive :-) thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: simple data GUI editor?
Well, Actually MS-Access through ODBC should work for you -Original Message- From: D_C [mailto:[EMAIL PROTECTED] Sent: Friday, June 17, 2005 4:28 PM To: mysql@lists.mysql.com Subject: simple data GUI editor? i was wondering if people can recommend a simple Excel like tool for editing data? MySql control center - seems to have limitations (unicode, not in dev anymore) Query browser - have to type raw sql to show/hide columns... ideally i want something with a few more features than either of these, eg list data in a vertical table rather than just horizontal... lookups to other tables but more oriented to lots of interactive editing of the DB data than DB admin. I guess more like an Access GUI... (puts on flame pants) + ideally not very expensive :-) thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: simple data GUI editor?
We use MySQL-Front from Star-Tools GmbH (www.mysqlfront.de)... works pretty much like you have asked. Thanks, Car - Original Message - From: Berman, Mikhail [EMAIL PROTECTED] To: mysql@lists.mysql.com Cc: D_C [EMAIL PROTECTED] Sent: Friday, June 17, 2005 4:36 PM Subject: RE: simple data GUI editor? Well, Actually MS-Access through ODBC should work for you -Original Message- From: D_C [mailto:[EMAIL PROTECTED] Sent: Friday, June 17, 2005 4:28 PM To: mysql@lists.mysql.com Subject: simple data GUI editor? i was wondering if people can recommend a simple Excel like tool for editing data? MySql control center - seems to have limitations (unicode, not in dev anymore) Query browser - have to type raw sql to show/hide columns... ideally i want something with a few more features than either of these, eg list data in a vertical table rather than just horizontal... lookups to other tables but more oriented to lots of interactive editing of the DB data than DB admin. I guess more like an Access GUI... (puts on flame pants) + ideally not very expensive :-) thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.5/18 - Release Date: 6/15/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.5/18 - Release Date: 6/15/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OS X Gui?
I haven't used Maestro, but I like SQL Grinder. It gives you a reasonable GUI. www.advenio.com/sqlgrinder The WebObjects EOF package has better Entity modelling, but you have to buy it! : } --s On Apr 6, 2005, at 10:44 PM, Vic Cekvenich wrote: I am looking for a nice OS X GUI client, can be java for osx that works w/ mysql 5.x. (these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work, but I want a bit more, like Maestro for OS X). what should I use? tia, .V -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OS X Gui?
Vic Cekvenich schrieb: I am looking for a nice OS X GUI client, can be java for osx that works w/ mysql 5.x. (these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work, but I want a bit more, like Maestro for OS X). AFAIK is the stuff from Navicat available for OS X. Regards, A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OS X Gui?
Navicat does not work w/ OSX-Tiger-java1.5 /MySQL 5 remote, nor does SQL Grinder(screens look nice). Jetware site is down so I can't try that. thanks for suggestions. DataBrowser does seem to work (and one that comes w/ mySQL - admin; but I do not like that one) Any more plz? tia, .V . Scott Franks wrote: I haven't used Maestro, but I like SQL Grinder. It gives you a reasonable GUI. www.advenio.com/sqlgrinder The WebObjects EOF package has better Entity modelling, but you have to buy it! : } --s On Apr 6, 2005, at 10:44 PM, Vic Cekvenich wrote: I am looking for a nice OS X GUI client, can be java for osx that works w/ mysql 5.x. (these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work, but I want a bit more, like Maestro for OS X). what should I use? tia, .V -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OS X Gui?
If you are looking for a GUI admin, MySQL has released a beta of MySQL Administrator for OSX. MySQL Query Browser is not available on OSX yet. Not sure which you may be looking for. On Apr 6, 2005, at 10:44 PM, Vic Cekvenich wrote: I am looking for a nice OS X GUI client, can be java for osx that works w/ mysql 5.x. (these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work, but I want a bit more, like Maestro for OS X). what should I use? tia, .V -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OS X Gui?
Yes, there is a MySQL beta version of the administrator, but be warned, it has many bugs that I personally believe makes it unusable. Jeff J. On Apr 7, 2005, at 8:35 AM, Brent Baisley wrote: If you are looking for a GUI admin, MySQL has released a beta of MySQL Administrator for OSX. MySQL Query Browser is not available on OSX yet. Not sure which you may be looking for. On Apr 6, 2005, at 10:44 PM, Vic Cekvenich wrote: I am looking for a nice OS X GUI client, can be java for osx that works w/ mysql 5.x. (these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work, but I want a bit more, like Maestro for OS X). what should I use? tia, .V -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OS X Gui?
Jeff Justice wrote: Yes, there is a MySQL beta version of the administrator, but be warned, it has many bugs that I personally believe makes it unusable. I would have to agree. I just tried it out and within a few seconds had it crash on me. Hopefully they'll get it fixed up. -- == Eric Gorr === http://www.ericgorr.net === The more you study, the more you know. The more you know, the more you forget. The more you forget, the less you know. So, why study? - ??? == Insults, like violence, are the last refuge of the incompetent... === -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
OS X Gui?
I am looking for a nice OS X GUI client, can be java for osx that works w/ mysql 5.x. (these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work, but I want a bit more, like Maestro for OS X). what should I use? tia, .V -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Trying to dump from GUI client
I am trying MySQL Query Browser, but I get this error... SELECT * INTO OUTFILE 'c:\temp\candidate.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n' FROM candidate; ERROR 1045: Access denied for user: 'wowdba'@'%' (Using password: YES) ...even though I am logged in via the client. -Original Message- From: Adam [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 16, 2004 7:04 PM To: [EMAIL PROTECTED]; MySQL General Subject: Re: Trying to dump from GUI client Eve, From the command line you can use `mysql`, command line tool that ships with MySQL. You would want to use the SELECT ... INTO OUTFILE 'file.txt' FROM ...; See the MySQL manual for more information on this: - http://dev.mysql.com/doc/mysql/en/SELECT.html You can use another MySQL client. Such as Toad for MySQL or MySQL query browser - see URLs below. Toad for MySQL - http://www.toadsoft.com/toadmysql/toad_mysql.htm MySQL Query Browser: - http://dev.mysql.com/downloads/query-browser/index.html Both of these tools will allow you to export a record set as a comma delimited file. Good luck! Regards, Adam Eve Atley I'm not sure how best to proceed in dumping data from 1 database and getting a copy of the export, in order to transfer it to another server. I usually use phpmyadmin to do an export, which nicely creates a .zip file of everything. I managed to get it connected with Mysql Control Center, but am not sure how to dump from this. So I figure I can: A. use a command line (in which case, what commnands should I use to dump and export to a file), Or B. try to get phpmyadmin to connect (as I'm uncertain how to edit the config file for this), Or C. learn how to dump from MySql CC (how? I saw no way of handling this from MySQL CC), Or D. use another GUI client (which one?). The server in question is mysql.loosefoot.com. Oddly, it was connecting fine until my company decided to move to a new server, and suddenly, it throws an error that Connection to database failed: Unknown MySQL Server Host 'mysql.loosefoot.com' (0). I've changed *nothing* in my connect script, and as mentioned, I can connect to the database via other means. What would you suggest as the least painful solution? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Regards, Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Trying to dump from GUI client
I'm not sure what the answer here is but check your user's permissions on the database to make sure it has the necessary items GRANTED to it. Matt Babineau Web Developer Criticalcode - http://www.criticalcode.com -Original Message- From: Eve Atley [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 12:14 PM To: 'Adam'; 'MySQL General' Subject: RE: Trying to dump from GUI client I am trying MySQL Query Browser, but I get this error... SELECT * INTO OUTFILE 'c:\temp\candidate.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n' FROM candidate; ERROR 1045: Access denied for user: 'wowdba'@'%' (Using password: YES) ...even though I am logged in via the client. -Original Message- From: Adam [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 16, 2004 7:04 PM To: [EMAIL PROTECTED]; MySQL General Subject: Re: Trying to dump from GUI client Eve, From the command line you can use `mysql`, command line tool that ships with MySQL. You would want to use the SELECT ... INTO OUTFILE 'file.txt' FROM ...; See the MySQL manual for more information on this: - http://dev.mysql.com/doc/mysql/en/SELECT.html You can use another MySQL client. Such as Toad for MySQL or MySQL query browser - see URLs below. Toad for MySQL - http://www.toadsoft.com/toadmysql/toad_mysql.htm MySQL Query Browser: - http://dev.mysql.com/downloads/query-browser/index.html Both of these tools will allow you to export a record set as a comma delimited file. Good luck! Regards, Adam Eve Atley I'm not sure how best to proceed in dumping data from 1 database and getting a copy of the export, in order to transfer it to another server. I usually use phpmyadmin to do an export, which nicely creates a .zip file of everything. I managed to get it connected with Mysql Control Center, but am not sure how to dump from this. So I figure I can: A. use a command line (in which case, what commnands should I use to dump and export to a file), Or B. try to get phpmyadmin to connect (as I'm uncertain how to edit the config file for this), Or C. learn how to dump from MySql CC (how? I saw no way of handling this from MySQL CC), Or D. use another GUI client (which one?). The server in question is mysql.loosefoot.com. Oddly, it was connecting fine until my company decided to move to a new server, and suddenly, it throws an error that Connection to database failed: Unknown MySQL Server Host 'mysql.loosefoot.com' (0). I've changed *nothing* in my connect script, and as mentioned, I can connect to the database via other means. What would you suggest as the least painful solution? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Regards, Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Trying to dump from GUI client
If I remember correctly, with select into outfile the outfile has to be on the server. -Original Message- From: Adam [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 16, 2004 4:04 PM To: [EMAIL PROTECTED]; MySQL General Subject: Re: Trying to dump from GUI client Eve, From the command line you can use `mysql`, command line tool that ships with MySQL. You would want to use the SELECT ... INTO OUTFILE 'file.txt' FROM ...; See the MySQL manual for more information on this: - http://dev.mysql.com/doc/mysql/en/SELECT.html You can use another MySQL client. Such as Toad for MySQL or MySQL query browser - see URLs below. Toad for MySQL - http://www.toadsoft.com/toadmysql/toad_mysql.htm MySQL Query Browser: - http://dev.mysql.com/downloads/query-browser/index.html Both of these tools will allow you to export a record set as a comma delimited file. Good luck! Regards, Adam Eve Atley I'm not sure how best to proceed in dumping data from 1 database and getting a copy of the export, in order to transfer it to another server. I usually use phpmyadmin to do an export, which nicely creates a .zip file of everything. I managed to get it connected with Mysql Control Center, but am not sure how to dump from this. So I figure I can: A. use a command line (in which case, what commnands should I use to dump and export to a file), Or B. try to get phpmyadmin to connect (as I'm uncertain how to edit the config file for this), Or C. learn how to dump from MySql CC (how? I saw no way of handling this from MySQL CC), Or D. use another GUI client (which one?). The server in question is mysql.loosefoot.com. Oddly, it was connecting fine until my company decided to move to a new server, and suddenly, it throws an error that Connection to database failed: Unknown MySQL Server Host 'mysql.loosefoot.com' (0). I've changed *nothing* in my connect script, and as mentioned, I can connect to the database via other means. What would you suggest as the least painful solution? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Regards, Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Trying to dump from GUI client
Alright, using TOAD, I managed to get my data into CSV. When using PHPMYADMIN to load into another database, it tells me it can't read the file! -Original Message- From: Sergei Skarupo [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 4:00 PM To: Adam; [EMAIL PROTECTED]; MySQL General Subject: RE: Trying to dump from GUI client If I remember correctly, with select into outfile the outfile has to be on the server. -Original Message- From: Adam [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 16, 2004 4:04 PM To: [EMAIL PROTECTED]; MySQL General Subject: Re: Trying to dump from GUI client Eve, From the command line you can use `mysql`, command line tool that ships with MySQL. You would want to use the SELECT ... INTO OUTFILE 'file.txt' FROM ...; See the MySQL manual for more information on this: - http://dev.mysql.com/doc/mysql/en/SELECT.html You can use another MySQL client. Such as Toad for MySQL or MySQL query browser - see URLs below. Toad for MySQL - http://www.toadsoft.com/toadmysql/toad_mysql.htm MySQL Query Browser: - http://dev.mysql.com/downloads/query-browser/index.html Both of these tools will allow you to export a record set as a comma delimited file. Good luck! Regards, Adam Eve Atley I'm not sure how best to proceed in dumping data from 1 database and getting a copy of the export, in order to transfer it to another server. I usually use phpmyadmin to do an export, which nicely creates a .zip file of everything. I managed to get it connected with Mysql Control Center, but am not sure how to dump from this. So I figure I can: A. use a command line (in which case, what commnands should I use to dump and export to a file), Or B. try to get phpmyadmin to connect (as I'm uncertain how to edit the config file for this), Or C. learn how to dump from MySql CC (how? I saw no way of handling this from MySQL CC), Or D. use another GUI client (which one?). The server in question is mysql.loosefoot.com. Oddly, it was connecting fine until my company decided to move to a new server, and suddenly, it throws an error that Connection to database failed: Unknown MySQL Server Host 'mysql.loosefoot.com' (0). I've changed *nothing* in my connect script, and as mentioned, I can connect to the database via other means. What would you suggest as the least painful solution? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Regards, Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Trying to dump from GUI client
I think for your purpose the best choice in the command line utility mysqldump, which comes with mysql. MySQL CC will also let you save the results as a TSV or CSV (this is set in the preferences somewhere). Use File - Save - Save Results from the menu. -Original Message- From: Eve Atley [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 2:13 PM To: Sergei Skarupo; 'Adam'; 'MySQL General' Subject: RE: Trying to dump from GUI client Alright, using TOAD, I managed to get my data into CSV. When using PHPMYADMIN to load into another database, it tells me it can't read the file! -Original Message- From: Sergei Skarupo [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 4:00 PM To: Adam; [EMAIL PROTECTED]; MySQL General Subject: RE: Trying to dump from GUI client If I remember correctly, with select into outfile the outfile has to be on the server. -Original Message- From: Adam [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 16, 2004 4:04 PM To: [EMAIL PROTECTED]; MySQL General Subject: Re: Trying to dump from GUI client Eve, From the command line you can use `mysql`, command line tool that ships with MySQL. You would want to use the SELECT ... INTO OUTFILE 'file.txt' FROM ...; See the MySQL manual for more information on this: - http://dev.mysql.com/doc/mysql/en/SELECT.html You can use another MySQL client. Such as Toad for MySQL or MySQL query browser - see URLs below. Toad for MySQL - http://www.toadsoft.com/toadmysql/toad_mysql.htm MySQL Query Browser: - http://dev.mysql.com/downloads/query-browser/index.html Both of these tools will allow you to export a record set as a comma delimited file. Good luck! Regards, Adam Eve Atley I'm not sure how best to proceed in dumping data from 1 database and getting a copy of the export, in order to transfer it to another server. I usually use phpmyadmin to do an export, which nicely creates a .zip file of everything. I managed to get it connected with Mysql Control Center, but am not sure how to dump from this. So I figure I can: A. use a command line (in which case, what commnands should I use to dump and export to a file), Or B. try to get phpmyadmin to connect (as I'm uncertain how to edit the config file for this), Or C. learn how to dump from MySql CC (how? I saw no way of handling this from MySQL CC), Or D. use another GUI client (which one?). The server in question is mysql.loosefoot.com. Oddly, it was connecting fine until my company decided to move to a new server, and suddenly, it throws an error that Connection to database failed: Unknown MySQL Server Host 'mysql.loosefoot.com' (0). I've changed *nothing* in my connect script, and as mentioned, I can connect to the database via other means. What would you suggest as the least painful solution? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Regards, Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Trying to dump from GUI client
I'm not sure how best to proceed in dumping data from 1 database and getting a copy of the export, in order to transfer it to another server. I usually use phpmyadmin to do an export, which nicely creates a .zip file of everything. I managed to get it connected with Mysql Control Center, but am not sure how to dump from this. So I figure I can: A. use a command line (in which case, what commnands should I use to dump and export to a file), Or B. try to get phpmyadmin to connect (as I'm uncertain how to edit the config file for this), Or C. learn how to dump from MySql CC (how? I saw no way of handling this from MySQL CC), Or D. use another GUI client (which one?). The server in question is mysql.loosefoot.com. Oddly, it was connecting fine until my company decided to move to a new server, and suddenly, it throws an error that Connection to database failed: Unknown MySQL Server Host 'mysql.loosefoot.com' (0). I've changed *nothing* in my connect script, and as mentioned, I can connect to the database via other means. What would you suggest as the least painful solution? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Trying to dump from GUI client
Eve, From the command line you can use `mysql`, command line tool that ships with MySQL. You would want to use the SELECT ... INTO OUTFILE 'file.txt' FROM ...; See the MySQL manual for more information on this: - http://dev.mysql.com/doc/mysql/en/SELECT.html You can use another MySQL client. Such as Toad for MySQL or MySQL query browser - see URLs below. Toad for MySQL - http://www.toadsoft.com/toadmysql/toad_mysql.htm MySQL Query Browser: - http://dev.mysql.com/downloads/query-browser/index.html Both of these tools will allow you to export a record set as a comma delimited file. Good luck! Regards, Adam Eve Atley I'm not sure how best to proceed in dumping data from 1 database and getting a copy of the export, in order to transfer it to another server. I usually use phpmyadmin to do an export, which nicely creates a .zip file of everything. I managed to get it connected with Mysql Control Center, but am not sure how to dump from this. So I figure I can: A. use a command line (in which case, what commnands should I use to dump and export to a file), Or B. try to get phpmyadmin to connect (as I'm uncertain how to edit the config file for this), Or C. learn how to dump from MySql CC (how? I saw no way of handling this from MySQL CC), Or D. use another GUI client (which one?). The server in question is mysql.loosefoot.com. Oddly, it was connecting fine until my company decided to move to a new server, and suddenly, it throws an error that Connection to database failed: Unknown MySQL Server Host 'mysql.loosefoot.com' (0). I've changed *nothing* in my connect script, and as mentioned, I can connect to the database via other means. What would you suggest as the least painful solution? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Regards, Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: In search of a good MySQL GUI client
Karam Chand said: I use SQLyog. It does allow you to create/delete FKs with ON UPDATE criterias. Yeah, it does not allow you to create Fks in graphical manner like MS SQL Server but does my purpose. One feature I really miss is Editing of FKs. Yeah, I also tried SQLyog. It's a very good program indeed, a very nice feature is the structure syncronization tool. However, I said every program I tried has problems, and SQLyog is no exception. I downloaded SQLyog v3.71, I'm using MySQL 4.1.4-gamma-standard. When I manage relationships (F10 key), the FK's not even show up on the list... If I now press New.. to create a relationship, I can fill in the blanks and press Create, however SQLyog didn't show the new relationship either. I ended up creating 5 (five) equal relationships since SQLyog wasn't showing them in the list. A nasty GUI bug, sure, but this renders SQLyog unuseable to me. Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: In search of a good MySQL GUI client
Probably you should put it as a bug in SQLyogs forums. Karam --- Jose_Miguel_Pérez [EMAIL PROTECTED] wrote: Karam Chand said: I use SQLyog. It does allow you to create/delete FKs with ON UPDATE criterias. Yeah, it does not allow you to create Fks in graphical manner like MS SQL Server but does my purpose. One feature I really miss is Editing of FKs. Yeah, I also tried SQLyog. It's a very good program indeed, a very nice feature is the structure syncronization tool. However, I said every program I tried has problems, and SQLyog is no exception. I downloaded SQLyog v3.71, I'm using MySQL 4.1.4-gamma-standard. When I manage relationships (F10 key), the FK's not even show up on the list... If I now press New.. to create a relationship, I can fill in the blanks and press Create, however SQLyog didn't show the new relationship either. I ended up creating 5 (five) equal relationships since SQLyog wasn't showing them in the list. A nasty GUI bug, sure, but this renders SQLyog unuseable to me. Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: In search of a good MySQL GUI client
On Thursday, September 09, 2004 - Karam Chand said: Probably you should put it as a bug in SQLyogs forums. I have put a bug request into the MySQL Query Browser bug track instead. I like this tool very much, it has some very nice features like the multithreaded results fetching. Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
In search of a good MySQL GUI client
Hi All! Why are all MySQL GUI clients so bad with foreign keys? Sorry to seem annoyed, but I have used for quite some time a few GUI clients, notably MySQL-Front, which I were relatively confortable with. Anyway, all GUI clients I used (SQLyog, MySql-Front, MySQL-CC, you name it) seemed to be some sort of shortcut to the MySQL command line. No problem with that, that's what I am looking for and not some high-level CASE tool. It's when looking for foreign keys and referential integrity where these tools fail miserably. None of them fully supports editing / creating / deleting foreign keys. If you are to reply to this message, please read again the FULLY supports statement. For example, with version 1.0.7-beta of MySQL Query Browser (Own MySQL AB tool) I'm unable to add an ON UPDATE constraint... silly, huh? This is not a strange Fails when lib-foo v1.2.3.5.7 connects throu a CISCO 90238234 router in a full moon night error, it's simply that the programmer (nor the bug-testing labs) have not tried the On Update: drop-down menu from the edit table dialog. I know foreign keys are a relatively new area in the MySQL field and maybe the programmers are slowly adding support for it, but it's quite annoying to see monumental bugs editing and changing foreign keys in ALL programs I've tried. Please, note that this message is not intended to flame anyone. I fully aknowledge the effort involved creating such a tool, I'm a programmer after all, and some of them are in beta anyway. I would appreciate if anyone knows some tool which good foreign key support. Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: In search of a good MySQL GUI client
Hello Jose, Why are all MySQL GUI clients so bad with foreign keys? Sorry to seem annoyed, but I have used for quite some time a few GUI clients, notably MySQL-Front, which I were relatively confortable with. Anyway, all GUI clients I used (SQLyog, MySql-Front, MySQL-CC, you name it) seemed to be some sort of shortcut to the MySQL command line. No problem with that, that's what I am looking for and not some high-level CASE tool. It's when looking for foreign keys and referential integrity where these tools fail miserably. None of them fully supports editing / creating / deleting foreign keys. If you are to reply to this message, please read again the FULLY supports statement. For example, with version 1.0.7-beta of MySQL Query Browser (Own MySQL AB tool) I'm unable to add an ON UPDATE constraint... silly, huh? This is not a strange Fails when lib-foo v1.2.3.5.7 connects throu a CISCO 90238234 router in a full moon night error, it's simply that the programmer (nor the bug-testing labs) have not tried the On Update: drop-down menu from the edit table dialog. I know foreign keys are a relatively new area in the MySQL field and maybe the programmers are slowly adding support for it, but it's quite annoying to see monumental bugs editing and changing foreign keys in ALL programs I've tried. Please, note that this message is not intended to flame anyone. I fully aknowledge the effort involved creating such a tool, I'm a programmer after all, and some of them are in beta anyway. I would appreciate if anyone knows some tool which good foreign key support. Well, you still need to manually create indices - but the FKs work just fine in ... Database Workbench - www.upscene.com With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: In search of a good MySQL GUI client
I use SQLyog. It does allow you to create/delete FKs with ON UPDATE criterias. Yeah, it does not allow you to create Fks in graphical manner like MS SQL Server but does my purpose. One feature I really miss is Editing of FKs. Karam --- Jose_Miguel_Pérez [EMAIL PROTECTED] wrote: Hi All! Why are all MySQL GUI clients so bad with foreign keys? Sorry to seem annoyed, but I have used for quite some time a few GUI clients, notably MySQL-Front, which I were relatively confortable with. Anyway, all GUI clients I used (SQLyog, MySql-Front, MySQL-CC, you name it) seemed to be some sort of shortcut to the MySQL command line. No problem with that, that's what I am looking for and not some high-level CASE tool. It's when looking for foreign keys and referential integrity where these tools fail miserably. None of them fully supports editing / creating / deleting foreign keys. If you are to reply to this message, please read again the FULLY supports statement. For example, with version 1.0.7-beta of MySQL Query Browser (Own MySQL AB tool) I'm unable to add an ON UPDATE constraint... silly, huh? This is not a strange Fails when lib-foo v1.2.3.5.7 connects throu a CISCO 90238234 router in a full moon night error, it's simply that the programmer (nor the bug-testing labs) have not tried the On Update: drop-down menu from the edit table dialog. I know foreign keys are a relatively new area in the MySQL field and maybe the programmers are slowly adding support for it, but it's quite annoying to see monumental bugs editing and changing foreign keys in ALL programs I've tried. Please, note that this message is not intended to flame anyone. I fully aknowledge the effort involved creating such a tool, I'm a programmer after all, and some of them are in beta anyway. I would appreciate if anyone knows some tool which good foreign key support. Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: GUI for MySQL
This is my first attempt to design and test MySQL. I have used MS SQL for number of years. I do appreciate if members of this list can recommend a good GUI application for MySQL. I want the GUI application to design DB, design Quiries, etc. Take a look at Database Workbench - www.upscene.com With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
GUI for MySQL
This is my first attempt to design and test MySQL. I have used MS SQL for number of years. I do appreciate if members of this list can recommend a good GUI application for MySQL. I want the GUI application to design DB, design Quiries, etc. Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: GUI for MySQL
Kirti Have a look at the free DBManager Pro from DBTools : http://www.dbtools.com.br/EN/dbmanagerpro.php Freddie -Ursprüngliche Nachricht- Von: Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 12. August 2004 20:09 An: '[EMAIL PROTECTED]' Betreff: GUI for MySQL This is my first attempt to design and test MySQL. I have used MS SQL for number of years. I do appreciate if members of this list can recommend a good GUI application for MySQL. I want the GUI application to design DB, design Quiries, etc. Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: GUI for MySQL
I would suggest DBDesigner available on http://www.fabforce.net/ -Mensaje original- De: Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 12 de Agosto de 2004 12:09 p.m. Para: '[EMAIL PROTECTED]' Asunto: GUI for MySQL This is my first attempt to design and test MySQL. I have used MS SQL for number of years. I do appreciate if members of this list can recommend a good GUI application for MySQL. I want the GUI application to design DB, design Quiries, etc. Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: GUI for MySQL
Hello, You can try SQLyog at http://www.webyog.com/ . Its not free but it has got some really powerful features. Regards, Karam --- Kirti S. Bajwa [EMAIL PROTECTED] wrote: This is my first attempt to design and test MySQL. I have used MS SQL for number of years. I do appreciate if members of this list can recommend a good GUI application for MySQL. I want the GUI application to design DB, design Quiries, etc. Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AM software (access dump) and GUI
Hi all, I have just installed mysql on my pc and outside hosting with a webhosting company. I have an access db that I want to convert into mysql. I tried the program http://www.intranet2internet.com/public/default.asp?PAGE=softwareDETAILS=A2M to convert a tiny access db as a test. This I did and now I have a .sql file which I have pasted below. This file I uploaded via ftp to our hosting with hostdepartment.com What do I do with this file? Upload it via ftp? Thanks a lot for any help DROP DATABASE temp_db1; CREATE DATABASE if not exists temp_db1; USE temp_db1; drop table Mailing_List; CREATE TABLE if not exists Mailing_List ( MailingListID INT AUTO_INCREMENT NOT NULL, FirstName CHAR(50), MiddleName CHAR(30), PRIMARY KEY ( MailingListID ) ); INSERT INTO Mailing_List VALUES ('1','ed','good'); INSERT INTO Mailing_List VALUES ('2','trev','wickes'); INSERT INTO Mailing_List VALUES ('3','ron','wickes'); This I uploaded to my website. phpAdmin control panel
RE: AM software (access dump) and GUI
You can load the data by using the mysql command. mysql -uuser -ppassword fileToLoad.sql ... If you are on a shared database server I do not think you will be able to issue the CREATE and DROP database commands. -Original Message- From: EWA Goodson Wickes To: [EMAIL PROTECTED] Sent: 8/9/04 3:47 PM Subject: AM software (access dump) and GUI Hi all, I have just installed mysql on my pc and outside hosting with a webhosting company. I have an access db that I want to convert into mysql. I tried the program http://www.intranet2internet.com/public/default.asp?PAGE=softwareDETAIL S=A2M to convert a tiny access db as a test. This I did and now I have a .sql file which I have pasted below. This file I uploaded via ftp to our hosting with hostdepartment.com What do I do with this file? Upload it via ftp? Thanks a lot for any help DROP DATABASE temp_db1; CREATE DATABASE if not exists temp_db1; USE temp_db1; drop table Mailing_List; CREATE TABLE if not exists Mailing_List ( MailingListID INT AUTO_INCREMENT NOT NULL, FirstName CHAR(50), MiddleName CHAR(30), PRIMARY KEY ( MailingListID ) ); INSERT INTO Mailing_List VALUES ('1','ed','good'); INSERT INTO Mailing_List VALUES ('2','trev','wickes'); INSERT INTO Mailing_List VALUES ('3','ron','wickes'); This I uploaded to my website. phpAdmin control panel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: AM software (access dump) and GUI
Can I do issue CREATE and DROP database commands with phpadmin? Our hosting paln has this Thanks a lot - Original Message - From: Victor Pendleton [EMAIL PROTECTED] To: 'EWA Goodson Wickes ' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, August 09, 2004 4:09 PM Subject: RE: AM software (access dump) and GUI You can load the data by using the mysql command. mysql -uuser -ppassword fileToLoad.sql ... If you are on a shared database server I do not think you will be able to issue the CREATE and DROP database commands. -Original Message- From: EWA Goodson Wickes To: [EMAIL PROTECTED] Sent: 8/9/04 3:47 PM Subject: AM software (access dump) and GUI Hi all, I have just installed mysql on my pc and outside hosting with a webhosting company. I have an access db that I want to convert into mysql. I tried the program http://www.intranet2internet.com/public/default.asp?PAGE=softwareDETAIL S=A2M to convert a tiny access db as a test. This I did and now I have a .sql file which I have pasted below. This file I uploaded via ftp to our hosting with hostdepartment.com What do I do with this file? Upload it via ftp? Thanks a lot for any help DROP DATABASE temp_db1; CREATE DATABASE if not exists temp_db1; USE temp_db1; drop table Mailing_List; CREATE TABLE if not exists Mailing_List ( MailingListID INT AUTO_INCREMENT NOT NULL, FirstName CHAR(50), MiddleName CHAR(30), PRIMARY KEY ( MailingListID ) ); INSERT INTO Mailing_List VALUES ('1','ed','good'); INSERT INTO Mailing_List VALUES ('2','trev','wickes'); INSERT INTO Mailing_List VALUES ('3','ron','wickes'); This I uploaded to my website. phpAdmin control panel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: AM software (access dump) and GUI
I am by no means a phpMyAdmin guru, but the version I have (2.5.7) has an option for it, accessible by clicking on the Databases link from the main page. I suspect, however, that they will give you a single database that you will not have the DROP DATABASE privilege for and that you will have to create all of your tables in a single database. It seems like I've seen that specified on more than one hosting service's description of their MySQL setup. - Dan On Aug 9, 2004, at 3:32 PM, EWA Goodson Wickes wrote: Can I do issue CREATE and DROP database commands with phpadmin? Our hosting paln has this Thanks a lot - Original Message - From: Victor Pendleton [EMAIL PROTECTED] To: 'EWA Goodson Wickes ' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, August 09, 2004 4:09 PM Subject: RE: AM software (access dump) and GUI You can load the data by using the mysql command. mysql -uuser -ppassword fileToLoad.sql ... If you are on a shared database server I do not think you will be able to issue the CREATE and DROP database commands. -Original Message- From: EWA Goodson Wickes To: [EMAIL PROTECTED] Sent: 8/9/04 3:47 PM Subject: AM software (access dump) and GUI Hi all, I have just installed mysql on my pc and outside hosting with a webhosting company. I have an access db that I want to convert into mysql. I tried the program http://www.intranet2internet.com/public/default.asp? PAGE=softwareDETAIL S=A2M to convert a tiny access db as a test. This I did and now I have a .sql file which I have pasted below. This file I uploaded via ftp to our hosting with hostdepartment.com What do I do with this file? Upload it via ftp? Thanks a lot for any help DROP DATABASE temp_db1; CREATE DATABASE if not exists temp_db1; USE temp_db1; drop table Mailing_List; CREATE TABLE if not exists Mailing_List ( MailingListID INT AUTO_INCREMENT NOT NULL, FirstName CHAR(50), MiddleName CHAR(30), PRIMARY KEY ( MailingListID ) ); INSERT INTO Mailing_List VALUES ('1','ed','good'); INSERT INTO Mailing_List VALUES ('2','trev','wickes'); INSERT INTO Mailing_List VALUES ('3','ron','wickes'); This I uploaded to my website. phpAdmin control panel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: AM software (access dump) and GUI
phpMyAdmin will display a create database box on the initial page, if you have the rights to create databases. If you don't have the right, then it wont. Often hosting plans have their own programming for creating databases because of the problems of making sure you cannot mess with other peoples databases. HTH Peter -Original Message- From: Daniel Lahey [mailto:[EMAIL PROTECTED] Sent: 10 August 2004 00:44 To: [EMAIL PROTECTED] Subject: Re: AM software (access dump) and GUI I am by no means a phpMyAdmin guru, but the version I have (2.5.7) has an option for it, accessible by clicking on the Databases link from the main page. I suspect, however, that they will give you a single database that you will not have the DROP DATABASE privilege for and that you will have to create all of your tables in a single database. It seems like I've seen that specified on more than one hosting service's description of their MySQL setup. - Dan On Aug 9, 2004, at 3:32 PM, EWA Goodson Wickes wrote: Can I do issue CREATE and DROP database commands with phpadmin? Our hosting paln has this Thanks a lot - Original Message - From: Victor Pendleton [EMAIL PROTECTED] To: 'EWA Goodson Wickes ' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, August 09, 2004 4:09 PM Subject: RE: AM software (access dump) and GUI You can load the data by using the mysql command. mysql -uuser -ppassword fileToLoad.sql ... If you are on a shared database server I do not think you will be able to issue the CREATE and DROP database commands. -Original Message- From: EWA Goodson Wickes To: [EMAIL PROTECTED] Sent: 8/9/04 3:47 PM Subject: AM software (access dump) and GUI Hi all, I have just installed mysql on my pc and outside hosting with a webhosting company. I have an access db that I want to convert into mysql. I tried the program http://www.intranet2internet.com/public/default.asp? PAGE=softwareDETAIL S=A2M to convert a tiny access db as a test. This I did and now I have a .sql file which I have pasted below. This file I uploaded via ftp to our hosting with hostdepartment.com What do I do with this file? Upload it via ftp? Thanks a lot for any help DROP DATABASE temp_db1; CREATE DATABASE if not exists temp_db1; USE temp_db1; drop table Mailing_List; CREATE TABLE if not exists Mailing_List ( MailingListID INT AUTO_INCREMENT NOT NULL, FirstName CHAR(50), MiddleName CHAR(30), PRIMARY KEY ( MailingListID ) ); INSERT INTO Mailing_List VALUES ('1','ed','good'); INSERT INTO Mailing_List VALUES ('2','trev','wickes'); INSERT INTO Mailing_List VALUES ('3','ron','wickes'); This I uploaded to my website. phpAdmin control panel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]