MySQL installation on HP-UX 10.20

2004-01-17 Thread Gagneet Singh
Hi! Can anybody guide me to the link for MySQL on a HP-UX 10.20 system. I have found the binaries for HP-UX 11 and 11.11, but nothing for 10.20. Thanx for the help in advance, Gagneet -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: MySQL 5 problem with select and stored procs

2004-01-17 Thread matthew.darby
It's just a simple select: select * from mytable but run from within the control center The error returned: [RM_SERVER] ERROR 1146: Table 'rm_development.1' doesn't exist where RM_SERVER is the server I created and rm_development is the database. I did see someone else has posted with the

Re: Memory leaks using MySQL C Api

2004-01-17 Thread Chris Nolan
Hi! You're looking for the function my_free(). Enjoy! Regards, Chris John McCaskey wrote: I have the following code: //try the mysql connection mysql_init(mysql_connection); if(!mysql_real_connect(mysql_connection, db_host, db_user, db_pass, db_db, 0, NULL, 0)) {

Tallkoz a kvetkezvel: 'MySQL List'

2004-01-17 Thread Tth Zsolt
BEGIN:VCALENDAR PRODID:-//Microsoft Corporation//Outlook 11.0 MIMEDIR//EN VERSION:2.0 METHOD:REQUEST BEGIN:VEVENT ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=TRUE:MAILTO:[EMAIL PROTECTED] ORGANIZER:MAILTO:[EMAIL PROTECTED] DTSTART:20040117T11Z DTEND:20040117T113000Z TRANSP:OPAQUE SEQUENCE:0

Re: Do I need Innodb?

2004-01-17 Thread Batara Kesuma
On Fri, 16 Jan 2004 13:43:55 -0800 Ron McKeever [EMAIL PROTECTED] wrote: Scenario 1: I have noticed that if two users open a record to edit it in two different browsers and they edit the same field and then click update, the last user/browser gets written to the db, where the first users

table info

2004-01-17 Thread Mike Mapsnac
Is it possible to find out when the table was created? How to get information about the table? Thanks

Re: MySQL and Perl DBI Persistent Connection

2004-01-17 Thread Batara Kesuma
On Fri, 16 Jan 2004 17:54:06 -0500 Syed Ali [EMAIL PROTECTED] wrote: I have a Perl CGI script which uses DBI to access MySQL. I noticed that each query through the Perl CGI script using DBI has a connect, query and then quit. I was wondering if there is a way of keeping the connection

RE: Do I need Innodb?

2004-01-17 Thread Ron McKeever
hi, Thanks for the response. I thought update is for existing records and insert is to add new records? My Scenario is if two users open an existing record with data already in the fields. They then add some information to the end of a field with data. Now when they click update the last

MySQL Server startup Problem

2004-01-17 Thread Nicholas
Hello Everyone, I downloaded and installed the mysql-standard-4.0.17-apple-darwin6.8-powerpc.dmg file from the mysql web site to my ibook running Mac OSX Version 10.1.5 on it. I read the documentation on the mysql site and it said to do the following next: shell cd /usr/local/mysql shell

Re: Memory leaks using MySQL C Api

2004-01-17 Thread Aftab Jahan Subedar
Hey wait a minute. Where did you get the my_free(), may be you are trying to say mysql_free(), but then that is used only if result set is used/called. But the code does not show any result set call. ie. mysql_use_result() or mysql_store_result(). So, the question now, how come there is a

Can't Set SQL_MODE?!

2004-01-17 Thread mattb
Howdy all, I've tried to search for an answer to this on the lists (and on google), but I haven't been able to come up with anything, so I apologize in advance if this question is redundant. According to the docs (http://www.mysql.com/doc/en/SQL_mode.html): The MySQL server can operate in

Re: Can't Set SQL_MODE?!

2004-01-17 Thread mattb
By the way, I should point out that I *can* get it to work by adding: [mysqld] ansi Or: [mysqld] sql_mode=PIPES_AS_CONCAT But this is not what I want, since I'm going to be hosting this app where I won't have access to the server config. I need to be able to set it on a per

Re: Can't Set SQL_MODE?!

2004-01-17 Thread Jeremy March
Try this: mysql set @@session.sql_mode = 'ansi'; Query OK, 0 rows affected (0.00 sec) mysql select @@session.sql_mode; ++ | @@session.sql_mode |

Mysql Installation on Linux: ERROR 2002: Can't connect to local MySQL server th

2004-01-17 Thread Mike Mapsnac
I just install MYSQL on Linux (Red Hat 9) using this manual:http://www.mysql.com/doc/en/Installing_binary.html Have no idea what's wrong. I looked on the mysql.log file and the file is empty. ERROR MESSAGE: [EMAIL PROTECTED] bin]# ./mysql ERROR 2002: Can't connect to local MySQL server through

RE: Mysql Installation on Linux: ERROR 2002: Can't connect to local MySQL server th

2004-01-17 Thread Nicholas
Hi Mike, You have to start the mysql server before you can run the client. Try running mysqld_safe --user=mysql from /usr/bin or /usr/local/bin, depending on where you installed it. To see if it is running currently on your machine, try this: ps -ef | grep mysqld Hope this helps...

server/client problem with 5.0.0-alpha

2004-01-17 Thread jank
Description: when compiled and started, mysqld_safe and mysql work fine from console, but hen used with apache and php, i get the error Client does not support authentication protocol requested by server; consider upgrading MySQL client How-To-Repeat just compile

Authentication screw up

2004-01-17 Thread Nicholas Fitzgerald
I'm running 3.23.58 on a Red Hat Fedora Core 1 box with the latest updates, (as of a couple days ago). I was using webmin to change the permissions on the database so I could access it from another box. Now, no matter who or what I log in as I can't access anything. If I try to go to the

Re: Authentication screw up

2004-01-17 Thread Chuck Gadd
Nicholas Fitzgerald wrote: go to the command prompt and use mysql or mysqladmin I get access deniged for user @localhost. No root or anything like that. I don't know where I screwed up, but I obviously screwed up something. Any ideas out there on how I can get back in control of this

Validate date

2004-01-17 Thread Hassan Shaikh
Quote from MySQL documentation ... MySQL allows you to store some wrong date values into DATE and DATETIME columns (like 2000-02-31 or 2000-02-00). The idea is that it's not the SQL server job to validate date. If MySQL can store a date and retrieve exactly the same date, then MySQL will store