Re: MySQL 5.0 - What is really available?

2004-03-30 Thread Gerald Jensen
I would not recommend MySQL-Front ... the version they are selling is not from the same developer that did MySQL-Front 2.5 (and earlier). I bought a license (took a month to get a license key), complained about missing features (OPTIMIZE and REPAIR MyISAM tables) and was basically told I could sho

Re: MYSQL 5 Stored Procedure

2004-01-07 Thread Gerald Jensen
Do a search on this list ... this has been covered within the last two weeks several times. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 07, 2004 5:40 AM Subject: MYSQL 5 Stored Procedure > Hello > I've installed Mysql 5 and have create

Re: My SQL setup issue

2003-12-15 Thread Gerald Jensen
More information please ... what Operating System, where are the MySQL binaries and data directories on your machine, did you create a my.ini, is MySQL installed as a service - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, December 14, 2003 1:51 P

Re: MySQL on Win32 vs Linux ?

2003-11-17 Thread Gerald Jensen
you might sleect. IMHO, any instability is not related to MySQL, but rather to the O/S platform itself. Gerald Jensen - Original Message - From: "Paul Fine" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 7:45 AM Subject: M

Re: Configuration File Creation - Automatic or manual?

2003-09-10 Thread Gerald Jensen
Adam: You create the configuration files ... the MySQL distribution has samples (my-huge.cnf, my-large.cnf, etc.) which you should edit to make sure settings are appropriate for your needs. Gerald Jensen - Original Message - From: "Fortuno, Adam" <[EMAIL PROTECTED]

Re: Is there trigger function in MySQL ?

2003-08-11 Thread Gerald Jensen
ion server. Gerald Jensen - Original Message - From: "Steven Wu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 08, 2003 12:49 PM Subject: Is there trigger function in MySQL ? Hi: It seems to me that there is no trigger function in MySQL but I

Re: inserting images to mysql - is it possible?

2003-06-30 Thread Gerald Jensen
Bob: This question comes up over and over on the list ... do a search for 'images' of the list archive and you can read the accumulated pros and cons. Gerald Jensen - Original Message - From: "Bob Ostermann" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>

Re: mySQL on Windows 2000 Server

2003-03-28 Thread Gerald Jensen
never had a burp that was traceable to MySQL. If we encounter any problems (which occurs seldom), it is almost always traceable to poor network administration, lack of proper network security, or failure to follow instructions. Gerald Jensen - Original Message - From: "Neil Tom

Re: restart or not?

2003-01-29 Thread Gerald Jensen
Jon: Reload the permissions tables. It looks like your permissions for Joseph are on the money ... are other people able to access the database remotely? Gerald Jensen - Original Message - From: "Jon Miller" <[EMAIL PROTECTED]> To: "MySQL List" <[EM

Re: Can MySQL handle 120 million records?

2002-12-18 Thread Gerald Jensen
Joe is right ... we switched from another SQL server to MySQL in 1999, and have never looked back. MySQL has been rock solid for our applications, the MySQL development team is great to work with, and our customers like it. Gerald Jensen - Original Message - From: "Joe Stump&quo

Need query to determine TABLE TYPE

2002-10-10 Thread Gerald Jensen
ich tables are still ISAM, then ALTER them. Gerald Jensen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-ma

MySQL-Front Discontinued

2002-09-11 Thread Gerald Jensen
I went to http://www.anse.de/mysqlfront/ today ... the notice posted on the site says "MySQL-Front - This project has been discontinued". Too bad ... Ansgar Becker developed a truly useful, powerful MySQL database management tool for us Windoze users. ---

RE: dos trouble

2002-08-01 Thread Gerald Jensen
Home or Pro? I have no experience with WinXP Home, but with WinXP Pro you need to installed MySQL as a service, then start the service. After that, the console will start with c:\mysql\bin\mysql Instructions for installing as a service are in the MySQL Manual. -Original Message- From: S

RE: Stored procedures

2002-06-27 Thread Gerald Jensen
I noticed ... but he was somehow able to get on the list to post his message! -Original Message- From: Roma Gupta [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 9:13 AM To: 'Gerald Jensen'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Stored procedures I think

Re: MYSQL 4.0

2002-06-27 Thread Gerald Jensen
Sad ... we gave MySQL a try almost three years ago, wound up replacing M$'s SQL Server with MySQL, and now have 80+ very happy customers with a stable, powerful, and very cost-effective database solution. - Original Message - From: "Arul" <[EMAIL PROTECTED]> To: "Thomas Spahni" <[EMAIL PR

Re: Stored procedures

2002-06-27 Thread Gerald Jensen
Yes ... we all know that stored procedures have not been implemented in MySQL. Sorry to be so terse, but this is about the umpteenth posting of this same question this week ... doesn't anybody read the list or search the archive before they post stuff? - Original Message - From: "andy th

RE: MySQL PHP Development IDE

2002-02-21 Thread Gerald Jensen
Thanks for the advice ... I'll take a look at dbg2 ... if I get stuck, I'll shoot you a plea for help! Gerald Jensen -Original Message- From: BD [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 9:38 AM To: Gerald R. Jensen Cc: [EMAIL PROTECTED] Subject: Re:

Re: Error 1058 Win2K Server with MySQL

2002-02-19 Thread Gerald Jensen
to those who responded! - Original Message - From: "Miguel Angel Solorzano" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 19, 2002 12:05 PM Subject: Re: Error 1058 Win2K Server with MySQL > At 07:49 19/02/2002 -

Error 1058 Win2K Server with MySQL

2002-02-19 Thread Gerald Jensen
rror: System error 1058 has occurred. The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. Anyone had this problem ... found a fix ... have any idea what is wrong??? Any feedback will be appreciated.

Error 1058 on Windows 2000 Server

2002-02-18 Thread Gerald Jensen
System error 1058 has occurred. The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. Anyone had this problem ... found a fix ... have any idea what is wrong??? Any feedback will be appreciated.

RE: replication implementation.

2001-09-27 Thread Gerald Jensen
EMAIL PROTECTED] Subject: Re: replication implementation. > I just installed my first Master/Slave setup Tuesday ... followed the > instructions in the Manual > (http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Ad > ministration.html#Replication). > > It

Re: M$ SQL Export to Mysql Help

2001-08-30 Thread Gerald Jensen
Curtis ... Do you have the database/table created on the MySQL server? If so, you can use MSAccess (need ODBC connections to both servers) to Link Tables and move the data acros that way. We did it that way until our programmers wrote a C++ app that replicates server-to-server. Gerald Jensen

RE: Use of the MySQL logo - licensing agreement

2001-08-29 Thread Gerald Jensen
ROTECTED]] Sent: Wednesday, August 29, 2001 7:52 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Use of the MySQL logo - licensing agreement Gerald Jensen writes: > Ed: > > I would hope that someone from MySQL AB will address this. It is > particularly important t

RE: Use of the MySQL logo - licensing agreement

2001-08-29 Thread Gerald Jensen
, but grants us specific rights to use their logo and trademark. Compliance is easy, and we don't have to check with anybody. Gerald Jensen -Original Message- From: Ed Carp [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 6:38 AM To: Gerald R. Jensen; [EMAIL PROTECTED] Subject:

Re: Formatting Price Field in my Table so 0.20 does not become 0.2....

2001-08-17 Thread Gerald Jensen
Steve: This is most likely in the server-side scripting language ... I've never seen MySQL round off numbers. If you are using PHP, you want to do something like: $price = round($price, 2); To get fancy, and show it as currency: $price = "$".$price; Gerald Jensen

Re: Proper Case NOT lower case

2001-08-16 Thread Gerald Jensen
Keith: You want to RENAME tables where applicable, and ALTER the respective columns to the desired case. Both are done through queries. The MySQL Manual has detailed info on using these commands. Gerald Jensen - Original Message - From: "Keith Spiller" <[EMAIL PROTECTED]

Re: html

2001-08-16 Thread Gerald Jensen
Theo: Yes ... MySQL doesn't really care much what the data is you are storing. The best source for info is the MySQL manual (link below) ... you probably want top look at storing data in either TEXT or BLOB fields. Gerald Jensen - Original Message - From: "Theo Riche

Re: local MySQL server authenticating users by machine username

2001-08-08 Thread Gerald Jensen
Bennett: Regardless of the login username / password, you have to GRANT user rights to create, alter, etc. in MySQL. By default, the root user has those rights, but not other users. Gerald Jensen - Original Message - From: "Bennett Haselton" <[EMAIL PROTECTED]> To: &

Re: MySql and PHP

2001-08-07 Thread Gerald Jensen
and PHP. I have local versions installed on both WinNT and Linux machines on the network ... everything gets tested on both platforms before it goes live. Gerald Jensen - Original Message - From: "Matt Gaskin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday,

RE: mysql.org

2001-07-13 Thread Gerald Jensen
Justin: Thanks ... but I couldn't care less. I have neither the time nor inclination to examine NuSphere's motives. I am a business man, and I made a business decision. Gerald Jensen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Justin

Re: logs on nt4

2001-06-28 Thread Gerald Jensen
Pete: Check the config file (C:\MY.CNF or C:\WINNT\MY.INI) ... you should see a line like: log=d:/mysql/mysql.log If the line if commented out (# log=d:/mysql/mysql.log), then logging is off. Remove the #, shutdown and restart the mysqld server. Gerald Jensen - Original Message

Re: I need to convert an ms access database file to a mysql compatible pipe delimited database file

2001-06-06 Thread Gerald Jensen
Can you can connect to MySQL with PHPMyAdmin or DBTools? What application are you trying to use when you get the failure-to-connect message? Is the server physically located in your place, or out on the net? If you don't have administrative access (telnet, PHPAdmin, MySQLFront, etc.), you have no

Re: convert an ms access database file

2001-06-06 Thread Gerald Jensen
seful! Gerald Jensen - Original Message - From: "Terrell Johnson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, June 06, 2001 7:41 AM Subject: convert an ms access database file > I need to convert an ms access data

Re: inserting a colum into a existing table

2001-05-30 Thread Gerald Jensen
Marco: You want to use the ALTER TABLE command (http://www.mysql.com/doc/A/L/ALTER_TABLE.html) G Jensen - Original Message - From: "Marco Kammerer" <[EMAIL PROTECTED]> To: "MYSQL" <[EMAIL PROTECTED]> Sent: Wednesday, May 30, 2001 6:34 AM Subject: inserting a colum into a existing table

Re: MYSQL on Windows 2k

2001-03-22 Thread Gerald Jensen
Daniel ... Make sure the path to C:\MYSQL\BIN (or wherever it is installed) is in the PATH environment variable (Settings -> Control -> System -> Environment). Login as Administrator and edit the value for the path variable, set and apply ... your problems should be over! G. Jensen - Origin

Re: ODBC

2001-03-09 Thread Gerald Jensen
Dave: Not sure I follow the question ... we have 50+ systems (WinNT Server or WinNT Workstation) running MySQL using the MyODBC drivers. G. Jensen - Original Message - From: "Dave Loisel" <[EMAIL PROTECTED]> To: "MySql" <[EMAIL PROTECTED]> Sent: Friday, March 09, 2001 8:13 AM Subject: O

Re: windows 2000

2001-02-28 Thread Gerald Jensen
We run MySQL (3.22.32) on Windows 2000 servers, and have found that if we issue the NET STOP MYSQL command from the DOS Prompt, it does in fact shutdown the service ... it just takes much longer than on the WinNT platform. Patience is the key. Same with removing the installed service. In every in

Re: Printed MySQL manual

2001-02-21 Thread Gerald Jensen
Denis: I'm not sure you really want a printed MySQL manual ... the software is dynamic, and is constantly being upgraded. The online manual is updated frequently, and is closer to the software you may be using. As an alternative, I would suggest one of the fine books on MySQL. Our developers eac

Re: MyODBC - Long varchar

2001-01-30 Thread Gerald Jensen
We have a rather complex C++ app that uses MySQL, as well as MSSQL7 and Oracle in conjunction with Microsoft's Transaction Server. After considerable trial and error, we have foudn we need to use four of the options which effect the behaviour of MyODBC ... - Don't optimize column width - Return