Problems

To The Mysql Support Team, We are stuck in a problem while installing mysql in linux.This is exactly what the error shows : 021109 12:59:10 mysqld started 021109 12:59:10 /usr/local/src/mysql/bin/mysqld: Can't create/write to file '/usr/local/src/mysql/data/localhost.localdomain.pid' (Errcode: 13

Problems

To The Mysql Support Team, We are stuck in a problem while installing mysql in linux.This is exactly what the error shows : 021109 12:59:10 mysqld started 021109 12:59:10 /usr/local/src/mysql/bin/mysqld: Can't create/write to file '/usr/local/src/mysql/data/localhost.localdomain.pid' (Errcode: 13

Optimize InnoDB table...

I've heard that I should periodically alter innodb table to MyISAM and back to InnoDB to optimize table structure. I guess only dropping index and recreating it is enough, but should I change table type? query. -- Chung Ha-nyung Sayclub NeoWiz

4 billion record + 6 Gigabytes text fie

My company is currently upgrade our company'database from PICK, an old database system to mysql.. Our company database got 1 table where the record is more than 40 million records, and the other table also got about i million record each.. what i found is i only can use the simple sql query t

Re: Update NOT NULL Field with NULL!

Hello. On Thu 2002-12-26 at 00:09:55 +0100, [EMAIL PROTECTED] wrote: > Hi there, > > I'm using MySql 3.23.?? with Connector/J on Win32. > My Problem is that the database lets me UPDATE NOT NULL Fields with > NULL-Values. > This is not a special Java Problem! > > For example: > The Field "Name" i

Update NOT NULL Field with NULL!

Hi there, I'm using MySql 3.23.?? with Connector/J on Win32. My Problem is that the database lets me UPDATE NOT NULL Fields with NULL-Values. This is not a special Java Problem! For example: The Field "Name" in tbl_Names is declared NOT NULL. UPDATE tbl_Names SET Name = NULL WHERE ID = 23; ...wo

Unable to establish database connection via PHP3

Hi Gerald, PWS is the Personal Web Server -- a little web server provided by microsoft supposedly good enough to host pages over an intranet. Thanks to the input of everyone, I managed to make a little progress in my problem. This is what I did: I edited the php3.ini file as follows. 1. chan

Re: problem: mysql locks up under freebsd

Hi, > [snip] > I am having problems with my php+mysql driven site, running on a freebsd > box. Mysql tends to lock up once-twice a day (or even more) and stop > responding to queries. Standard FreeBSD installation is not the happiest MySQL environment. If your problem is really MySQL related, h

Bug with Connector/J on Linux?

I may have encountered a bug with Connector/J on Linux. Using the latest Connector/J (mysql-connector-java-2.0.14-bin.jar) with MySQL 3.23.41 (all on RedHat Linux 7.3 with upgrades), I have encountered an sql exception. This sql exception is not reproducable under the same conditions on Windows 2

Re: Unable to establish database connection via PHP3

Don't know anything about PWS ... - Original Message - From: "Mohammed Fouwaaz" <[EMAIL PROTECTED]> To: "Gerald R. Jensen" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, December 25, 2002 12:36 PM Subject: Re: Unable to establish database connection via PHP3 It is Personal

Re: Unable to establish database connection via PHP3

This is a PHP issue. I don't recall the version when MySQL support became standard, but PHP3 is too old to be of much use. Especially with the new features for security introduced in PHP 4.2.0. Your best bet is to upgrade to a current release of PHP. That way you'll have MySQL support built-in

Re: Hiding the password

Hello. On Wed 2002-12-25 at 13:15:58 +0200, [EMAIL PROTECTED] wrote: > Hi all, > > I want to make a CGI program in Perl that queries a MySQL database, and the > problem is that I need to write the password for the database in the program > and this password can be seen by any user that has an acc

Re: Unable to establish database connection via PHP3

It is Personal Web Server -- but I am not sure whether any special configuration is necessary for MySQL and PHP3. I installed PWS first and then MySQL and lastly PHP3. Thanks & Regards Fouwaaz [EMAIL PROTECTED] wrote: Did you configure your web server (Apache?) for MySQL and PHP? - Origi

Re: Unable to establish database connection via PHP3

Did you configure your web server (Apache?) for MySQL and PHP? - Original Message - From: "Mohammed Fouwaaz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 25, 2002 11:59 AM Subject: Unable to establish database connection via PHP3 Hello mysql gurus I am fairly ne

Re: Is this a MySQL error?

Hello. On Wed 2002-12-25 at 11:47:22 +0200, [EMAIL PROTECTED] wrote: > Hi all, > > I gave the following command in the default MySQL client: > > select from_days(365); > > The result is -00-00 instead of 0001-00-00. > > If I gave the following command: > > select from_days(366); > > It g

Unable to establish database connection via PHP3

Hello mysql gurus I am fairly new to mysql and php3. mysql server is running ok and I created a table and inserted a few records. php3 is also working ok and I am able to run a regular 'Hello World' script. BUT when I include a phpinfo() and call that -- I don't see an entry with the extension

Re: SOLVED! (was: Re: What is wrong with this query?)

This is getting a little bit away from mysql but the easy way to do this is: use Proc::Daemon;# Available at a CPAN near you :-) ... Proc::Daemon::Init; which takes care of all the details of daemonizing your program. But this still doesn't explain (at least to me) the lost connection.

re: Starting MySQL with Redhat 8.0

On Tuesday 24 December 2002 19:34, Andrew Schaefer wrote: > I had the same problem. I fixed it by realizing that when the program was > installed it put the mysql.sock file in the /var/libs/mysql dir however > when it starts it looks for the file in /tmp You can either change the > folder it loo

re: Do I have to modify mysql-bin.index when purging old binary logs?

On Tuesday 24 December 2002 17:12, Christian Hammers wrote: > Subject says all, is everything fine when I just flush-logs every > morning and remove every logfile that is older than 30 days? > Or do I have to delete the corresponding line from the index file as > well? Whatfor is it needed, btw?

re: "connect by" clause...

On Tuesday 24 December 2002 16:52, Gabriele Carioli wrote: > It's Christmas and I'm sending my wish list to Santa Claus... > ;o) > > 1. hierarchical queries [skip] > it is possible to execute a query like: > > SELECT * FROM data CONNECT BY id PRIOR pnt START WITH id=0; [skip] It's in the TODO

re: Mysql versions, disks, speed, FTS, and EXPLAIN feature request (SELECT [CALC_RESOURCES])

On Saturday 21 December 2002 00:06, Steven Roussey wrote: > I wanted to thank the MySQL team for making such a great product! We > moved from 3.23 to 4.0.x a couple of months ago and everything works > great. Just upgraded to 4.0.6 and glad to see it work out of the box > without a rev 4.0.6a. Tho

re: MySQL password confusion.

On Sunday 22 December 2002 06:29, William Bradley wrote: > At the present time I am using Mandrake 9.0 and installed the MySql > programmes that con the three disks: > > MySQL-3.23.52-1mdk.i586.rpm* > MySQL-bench-3.23.52-1mdk.i586.rpm* > MySQL-client-3.23.52-1mdk.i586.rpm* > MySQL-Max-3.23.52-1mdk

Hiding the password

Hi all, I want to make a CGI program in Perl that queries a MySQL database, and the problem is that I need to write the password for the database in the program and this password can be seen by any user that has an account on that server. I need to gave 755 permissions to CGI scripts because they

Is this a MySQL error?

Hi all, I gave the following command in the default MySQL client: select from_days(365); The result is -00-00 instead of 0001-00-00. If I gave the following command: select from_days(366); It gives the result 0001-01-01. If I give numbers less than 356, the result is 0 for the year, the

Re: entering Chr(13) & Chr(10) in insert & update

Kayamboo, (B (B>Is there any way I can insert Chr(13) & Chr(10) along with string (B> characters in a blob field using *insert* or *update* statements. (B (BYou can insert these values (CR/LF) just like any other character, but (Byou have to make sure they have been escaped properly. If

Re: syntax

Samuel, > select sld_vlprov,hist_lanc from sld_lanc,lanc > where sld_lanc.sld_user *= lanc.user_usuario In MySQL, this could simply be: select sld_vlprov,hist_lanc from sld_lanc,lanc where sld_lanc.sld_user = lanc.user_usuario But you can write it like you did, as well: > select * from sld_lan

Re: multiple database connection

On Tuesday 24 December 2002 17:47, Lalit Chandwani wrote: > multiple database connection > on windows 98 , mysqld running with pws > > here is some confusion with the multiple database > connection variables > i am executing the same code in three different ways > it gives me diffrent output > all

mysql xpcom wrapper available for Mozilla

Hi all. Check out http://mysqlxpcom.mozdev.org/ Quick intro: Allows to write MySQL interfaces in pure JavaScript, XUL or HTML. Multiplatform. Usable right now. Enjoy and Happy Xmas ! -- Deem0N** [EMAIL PROTECTED] ** Natural born YASPer http://www.yasp.com/ Just Anoth

Ïð½º

ÄãºÃ£º ÎÒ¹«Ë¾ÊÇÒÔ¾­ÓªÌØÖÖÏ𽺡¢ÏðËÜ¡¢Ä¦²Á²ÄÁÏ¡¢Èó»¬ÓÍÌí¼Ó¼Á¡¢µçÀ²ÄÁÏ¡¢ÂÖÌ¥²ÄÁÏ¡¢Õ³ºÏ¼ÁΪÖ÷£¬ÏàÓ¦¼¼Êõ·þÎñΪ¸¨µÄ¶àÔª»¯¹«Ë¾¡£ÏÖÖ÷Òª¾­ÓªÆ·ÅÆ£¨¶¡ëæ¡¢·ÛÄ©¶¡ëæ¡¢ÒºÌ嶡ëæ¡¢ÈýÔªÒÒ±û¡¢¹è½º¡¢·ú½º¡¢±ûÏ©Ëáõ¥¡¢ ÈÈËÜÐÔµ¯ÐÔÌå¡¢ÏðËܺϽ𡢸߱½ÒÒÏ©¡¢¶¡»ùµÈ£©¼°¸¨ÁÏ¡£Æ·ÖÖ·±¶à£¬¼Û¸ñ¹«µÀ¡£ÈçÓÐÐèÒª£¬ÇëÀ´ÈËÀ´µçÓëÎÒÁªÏ

Re: maximum record size query

--- [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to > be either spam or > simply off topic to our filter. To bypass the filter > you must include > one of the following words in your message: > > sql,query,queries,smallint > > If you just reply to this message, and

Re: Compile/Install problems, NetBSD 1.6

Hi, have you tried the mysql-server from the pkg collection of netbsd? Lars On Dienstag, Dezember 24, 2002, at 09:44 Uhr, Bruce Lane wrote: Fellow MySQL'ers, I've been trying to install MySQL ver. 3.23.54a on NetBSD 1.6 on an i386 platform. The difficulty I've been running into is that

Re: SOLVED! (was: Re: What is wrong with this query?)

- Original Message - From: "Rick Robinson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 24, 2002 12:03 PM Subject: RE: SOLVED! (was: Re: What is wrong with this query?) > It's not a true daemon ... No. It is only called a zombie if the child was brutally cut off fro