RE: MySQL running out of date

2003-08-21 Thread Brian Austin
As per the manual that is correct. The only correct date will be 1996-02-31. what is the problem? -Original Message- From: Hans van Harten [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 4:09 PM To: [EMAIL PROTECTED] Subject: MySQL running out of date Some make the laughing st

RE: Oracle DBA here looking for advice on MySQL ....

2003-08-19 Thread Brian Austin
Just look at amazon. There are more books popping up all the time. The manual with user comments is the best. http://www.mysql.com/doc/en/ Paul DuBois wrote a good book that helped me get started on a few things. This one is a newer one I think. http://www.amazon.com/exec/obidos/tg/detail/-/0735

RE: max clients

2003-08-01 Thread Brian Austin
http://www.mysql.com/doc/en/Linux.html If you are using Linux, you need to read this section. You can get up to 4096 connections minus a few for the server admin threads. Did this a while back and works well. I don't know if any of these issues have been resolved in the Kernel or LinuxThreads y

RE: store video file into MySQL database server

2003-07-22 Thread Brian Austin
Why not change VIDEO -> VIDEO_PATH and just use the directory path as a varchar() field to point you to the file stored on your computer. That way you don't have to worry about it. Whenever I need to use images or large files of some type, I just put it in a directory and reference the path to i

RE: mysql.sock doesn't exist

2003-06-27 Thread Brian Austin
OK. I sent to you once on the list, and to the original poster, but it was returned from his email server (who knows). Here it goes. The most probable reason reason that file is not there is permissions. When mysqld starts (under user mysql or mysqld) it writes the file in the directory spe

RE: mysql.sock doesn't exist

2003-06-24 Thread Brian Austin
check that the permissions in the data directory are correct. If mysqld does not have write perms in that directory, it will not start. ls -l /var/lib/mysql mysql_install_db "used" to set the permissions to the user that ran the script (usually root). -Original Message- From: John Nich

Re: Install PHP with MySQL

2002-12-05 Thread Brian Austin
yes... it seems that you do not have mysql in the PHP module. you can use --with-mysql in the php configure, but you should use --with-mysql=/your/mysql/directory PHP has included code for the default mysql build. try to use your own libs and headers. HTH brian sql, query, mysql On Th

RE: RE: thread compile error on MySQL 4.0

2001-07-23 Thread Brian Austin
s that the thread library is not included correctly some where. any help would be appreciated thank you brian austin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists