RE: How to get MySQL to list current db's ?

2002-12-10 Thread Brian P. Austin
show databases. -Original Message- From: Will Standley [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 10:36 AM To: MySQL List Subject: How to get MySQL to list current db's ? I have two sample MySQL db's running on a local Linux box w/Apache... Once I enter "mysql" from the

RE: E-Commerce, db-clustering and MySQL?

2002-12-08 Thread Brian P. Austin
There is no clustering in MySQL. Replication features allow something similar. In my opinion, the reason I prefer MySQL is the fact that the basics are there to do what ever you need to. You are responsible for making the solution, not the vendor. Multiple MySQL slave servers, and multiple webse

RE: mysql port number

2002-12-06 Thread Brian P. Austin
show variables that will show you what you need. you can use a like statement, because there is a lot of stuff hope that helps brian -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 9:51 AM To: [EMAIL PROTECTED] Subject: RE: mysql port numbe

RE: undefined function: mysql_connect()

2002-04-26 Thread Brian P Austin
Are you using MySQL 4.x sumthing? I thought that function was taken out and replaced with mysql_real_connect()? I may be wrong. -Original Message- From: Julie Meloni [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 10:35 AM To: Tewfic Kidess Cc: [EMAIL PROTECTED] Subject: Re: u

Re: mysql on redhat instalation problem

2002-02-26 Thread Brian P. Austin
Hello, You probably need to check the permissions for the directory that mysql is trying to create the databases in. Make sure mysql has write permissions in the directory. then run mysql_install_db again and you should be ready to go. - Original Message - From: "jake williamson 28" <

RE: RPMS for Development Branch

2002-02-18 Thread Brian P. Austin
http://www.linuxmonsters.com sorry about that -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 3:41 PM To: 'Brian P. Austin' Cc: mysql Subject: RE: RPMS for Development Branch and the URL is??? it's not www.codemonst

RPMS for Development Branch

2002-02-18 Thread Brian P. Austin
requests should be sent to [EMAIL PROTECTED] I did this in hopes of making things easier for people (and myself) who want to try the new stuff out without downloading and compiling themselves. Have fun. Brian P. Austin

RE: Using password: _No_

2002-02-13 Thread Brian P. Austin
what command are you issuing. is it mysql? If so, what arguments are you sending it? It should look like this mysql -u user -p prompt: password -Original Message- From: Cliff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 9:18 PM To: [EMAIL PROTECTED] Subject: Using pas

RE: Request for help in testing new replication code in 4.0.2

2002-02-13 Thread Brian P. Austin
I have finished a script that takes the bit keeper sources and makes MySQL-4.0.2 RPMS for Redhat 6.x and apparently 7.X as well. I can put these up on our site for download if you want. They might get others trying the code out. I use the spec file included with the source code. I'll put it up

Compile failure with dev branch

2002-01-22 Thread Brian P. Austin
When using the BUILD/compile-pentium and BUILD/compile-pentium-pgcc I get the following errors.. /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparenthe

RE: How does one put images into a MySql database

2002-01-22 Thread Brian P. Austin
You can put images in the DB, but the easiest way is to put the path to the images in a text field, and rely on the disk to send the images. hope that helps, Brian -Original Message- From: Rochester, Dean [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 7:50 AM To: MySQL (E-ma

Re: MySQL, Red Hat Linux and php

2001-11-30 Thread Brian P. Austin
If you are using the MySQL RPMS for RedHat, They install in the /usr directory. (Redhat dows things differently) So it would be ./configure --with-mysql=/usr for PHP compilation. as far as upgrading... I have used RedHat for a long time, and have found that in their newest distos, it is extreme

Re: MySQL, Red Hat Linux and php

2001-11-29 Thread Brian P. Austin
The RPMS that are available from the MySQL WebSite are OK to use on 6.2. I personnaly prefer to use the source or .src RPMS. But the RPMS work fine on my 6.2 box. [EMAIL PROTECTED] wrote: > Hello, > > Which version of MySQL ( RPM packages ) is good for work with php 4.0.6 > and Linux Red Hat 6.

Re: Installing Calendar 0.9.33 on Mac OS X

2001-11-02 Thread Brian P. Austin
query, mysql server Try this mysqladmin -u root -p create intranet mysql -u root -p intranet < tables-mysql.sql next time tell us what the error is and it is a lot easier to fix the problem :) Quentin Bennett wrote: > First pointer - what errors are you getting! > > -Original Message-

Re: mysql.sock deletes itself on Solaris

2001-11-02 Thread Brian P. Austin
mysql, query, server there is probably a cron job or sumptin that is deleting your sock file. Try putting it in a different place. [EMAIL PROTECTED] wrote: > >Description: > /tmp/mysql.sock is there and then apparently randomly its removed without > warning.. mysql still accepts TCP connecti

Re: mysql.sock ???

2001-10-29 Thread Brian P. Austin
Or you could add path-to-unix-socket= somewhere else than /tmp Sometimes your machine will delete things in the /tmp directory without you knowing. I put it in /var/lib/mysql (linux). Ed Carp wrote: > Riccardi Moreno ([EMAIL PROTECTED]) writes: > > > Hi all, > > I've installed mysql 3.23.42 o

Re: Embedding MySQL in an application

2001-08-09 Thread Brian P. Austin
You need to download the MySQL-4.0 source and compile for embedded-server. This is a library that you link your programs to. It is used for small devices, like what we are doing here. I haven't found any docs on it yet, but the header files give plenty or explaination. Hope that helped Brian A

Re: RE : WELCOME to mysql@lists.mysql.com

2001-08-05 Thread Brian P. Austin
On Sun, 5 Aug 2001, SOHM Philippe wrote: > Hi, > I'd like to add a function MD5() to mysql with CREATE FUNCTION > Someone can help me ? I know nothing in C > > Philippe > That might be a problem if you wnat to compile in your own function. You might want to try a UDF instead. I don't use the

mysqld as a library in 4.0

2001-07-06 Thread Brian P Austin
Has anyone seen any documentation for using mysqld as a library. I am building an "embedded device" on a machZ chipset, and I would really like to be able to use mysql for some internal querying of our data collection. I can get it to run (barely) as is, but need more room and memory for other

Error in Config .33

2001-03-01 Thread Brian P. Austin
Dual PIII half gig ram. VaLinux 6.2.3 When running configure, It checks size of char and says 0. it fails and says that a static libm.a is not found. It is in /usr/lib, but it says to install a static version. Is there any other workaround for this. -

Configure with pgcc

2001-02-12 Thread Brian P. Austin
Has anyone had success compiling .32 mysql on linux using pgcc. I export the variables correctly, but it fails in configure when trying to run the test program. Right after test return of sprintf(). anybody have success with pgcc? ---

Hidden characters

2001-01-16 Thread Brian P. Austin
Is there any way to find out if there are hidden (non-printing) characters in a field? is there a strlen() function in MySQL? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mys

Re: Please read the manual

2001-01-10 Thread Brian P. Austin
OK enough said. Lets get back to using the best database out there. -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a mes