no deamon

hi i installed mysql server4.0.15 and client on redhat8.0 usning rpm -i command. when i tried to start it using the command /etc/init.d/mysqld start redhat did not recognize myqld (no such file or dir) when i went to init.d i did not find mysqld then i went to /var/lib/mysql/mysql and searched

dameon ended fast

hi i was trying to execute /etc/init.d/mysql start i get starting mysqld with database /var/lib/myql 030927 7:1 mysql-ended it seems to me the daemon started and ended at the same monent. so how can i let daemon continue? i am using redhat 8 and mysql 4.0.15 server and client

How much data can mysql support?

Hi, How large data that i can store in Mysql and how much data can Mysql support? Thank you very much. regards, florence Yahoo! Photos - A free party for the most shiok photo. Join now!

Re: 2,000,000 rows in FULLTEXT

Hi! On Sep 24, Steven Roussey wrote: * MATCH ... AGAINST() in natural language mode now treats words that are present in more than 2,000,000 rows as stopwords. Arg! Is this really true only for natural mode? It seems to be doing it for boolean mode too. No, it is true ONLY in natural

Selecting a date

Using a select statement, how does one select all records that have a date one day less than the current date? Searching the archives and I can't seem to find the answer.. Our database has these fields: EMAIL, AMOUNT, ID, DATE The date is in format 00/00/ Thanks -- Bruce Therrien

Re: Selecting a date

Bruce Therrien wrote: Using a select statement, how does one select all records that have a date one day less than the current date? Our database has these fields: EMAIL, AMOUNT, ID, DATE The date is in format 00/00/ Gack. I'm guessing 00/00/ is a string? 1) DATE is a MySQL reserved

mysql log

i was checking the system log file i found no mysqlpid file found.looked for /var/lib/mysql/localhot.locatdomain.pid so how can i deal with a problem like that since mysql does not start? thanks __ Do you Yahoo!? The New Yahoo! Shopping

Re: Selecting a date

At 11:02 -0400 9/27/03, Bruce Therrien wrote: Using a select statement, how does one select all records that have a date one day less than the current date? Searching the archives and I can't seem to find the answer.. Our database has these fields: EMAIL, AMOUNT, ID, DATE The date is in

Re: Can't open privilege tables: Out of memory error

At 11:14 -0700 9/25/03, [EMAIL PROTECTED] wrote: Description: bin/mysqld_safe --user=mysql fails with the following error (from data/host.err file) 030925 10:58:58 mysqld started 030925 10:58:59 InnoDB: Started 030925 10:58:59 Fatal error: Can't open

1051: Unknown table on running drop database

I'm getting this error: ERROR 1051: Unknown table '#sql-279_28,#sql-333c_1' after trying to drop a database. I found nothing in the docs or the archives about how to sort it out. Can anybody tell me what steps I should take to remedy this? I'm using 4.1.0 Thanks, Adam -- MySQL General

Re: How much data can mysql support?

In the last episode (Sep 27), florence florence said: How large data that i can store in Mysql and how much data can Mysql support? A longblob field type can store 4gb of data. The only limit on table size is your OS'es limits. This is explained in the manual.

complex, to me, insert question

I have an insert that I have to get to work from the following tables here is my query: Select distinct t1.id, t3.id, t2.id, g.description, g.price, g.qty, g.comments from cp.Category t1, Gifts g, cp.Manufacturer t2, cp.Pattern t3 where t1.name = g.Category and t2.name = g.Manfacturer and

reinstall package

hi i can locate my.cnf on my redhat8. should i uninstall the mysql package and reinstalled to have my.cnf in etc directory? i remember i get flag erros when i was installing it? thanks __ Do you Yahoo!? The New Yahoo! Shopping -

Re: complex, to me, insert question

You need to substitute t1_id, t3_id ... etc, for the appropriate field names in the other_table you are wanting to insert the values into. The missing fields will be filled in with their default values: INSERT INTO other_table (t1_id, t3_id, t2_id, g_description, g_price, g_qty, g_comments)

'IF NOT EXISTS' ignored?

Is there a problem with 'IF NOT EXISTS' in the following scenario? This statement creates the table as expected ... CREATE TEMPORARY TABLE IF NOT EXISTS showcase ( PRIMARY KEY (product) ) SELECT product FROM productList .. but re-running it (from the

Re: some connector/j tests fail

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ray Tayek wrote: hi, just donwloaded mysql and connector/j. the driver seems to work fine for simple stuff. but i can not get all of the tests to run (please see typescript below). ant test give ms a :Overriding previous definition of reference

RE: # processes vs. #threads, and memory usage (Revisited for thread cache)

Bringing this back up again, because the number of extra 'threads' mysql is using seems to vary widely, from I've noticed sometimes, from 5 more than the threads I'm using to more than 50! My memory usage also seems to differ accordingly. It seems to be because my thread cache is set to 40, so

php and mysql

hi i want to use php with mysql. However, i do not know if i should install another package from mysql that incluse shared library between php and mysql?. i already installed mysql client and server package. if there more package i should install,can you please tell the name and where can i find

Re: # processes vs. #threads, and memory usage (Revisited for thread cache)

In the last episode (Sep 27), Kevin said: Bringing this back up again, because the number of extra 'threads' mysql is using seems to vary widely, from I've noticed sometimes, from 5 more than the threads I'm using to more than 50! My memory usage also seems to differ accordingly. It seems

Re: some connector/j tests fail

At 07:31 PM 9/27/03 -0500, Mark Matthews wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ray Tayek wrote: hi, just donwloaded mysql and connector/j. the driver seems to work fine for simple stuff. but i can not get all of the tests to run ... I actually get all of the tests to run (on

Slow Deletes

I just ran the following on a table with ln_cash having about 190,000 records and cash_exceptions having about 6,000: mysql delete ln_cash from ln_cash,cash_exceptions where ln_cash.docunid=cash_exceptions.docunid; Query OK, 6103 rows affected (3 min 10.21 sec) Both tables have unique indexes

Selecting on timestamp(14)

I have a timestamp(14) column, I need to expire/decay certain records over time, can I use NOW() and INTERVAL on a timestamp(14) column Looking to expire a record that is x hours old For example Update table set active = '0' where updated = --

RE: php and mysql

There shouldn't be anything else required (besides PHP). PHP has built in functions to access MySQL. See: http://www.php.net/manual/en/ref.mysql.php Adam Clauss [EMAIL PROTECTED] -Original Message- From: gamalt tant [mailto:[EMAIL PROTECTED] Sent: Saturday, September 27, 2003 8:48

Re: Selecting on timestamp(14)

Hi, I dont think so - the timestamp is a system-field, set by the system and can not be modifyed by users. You probably have to make an additional datetime-field for You purpose - if You can do CONCAT(timestamp + NOW()) when it is INSERT, I dont know - try. best regards Peter - Original

Re: Selecting on timestamp(14)

on 9/27/03 7:55 PM, PeterWR at [EMAIL PROTECTED] wrote: Hi, I dont think so - the timestamp is a system-field, set by the system and can not be modifyed by users. You probably have to make an additional datetime-field for You purpose - if You can do CONCAT(timestamp + NOW()) when it is

Re: Can someone explain the difference between these two queries?

Please don't hijack threads. Sorry - did a reply-all to get the address set up; changed the subject but was working on a few emails at the same time (also posting to the Postgres newsgroup - their version of the query, on the same machine (with MySQL stopped) takes 19 seconds with incorrect

Re: Selecting on timestamp(14)

UPDATE table SET active = 0 WHERE updated DATE_SUB(NOW(),INTERVAL 48 HOUR) see the manual for more info http://www.mysql.com/doc/en/Date_and_time_functions.html#IDX1322 olinux --- Scott Haneda [EMAIL PROTECTED] wrote: I have a timestamp(14) column, I need to expire/decay certain records

is php in?

how do i check that my redhat8.0 contains php? is there some command inform me if php is included? thanks __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- MySQL General Mailing List For list

help about MySql

Dear Sir, I am working at a project developed by using MySql to store various information. The program is written on VC++6.0 paltform. I met with a problem that the program using mysql_init function to call mysql can't be interrupted by ctrl - C. The program can only be

Re: is php in?

I assume you're not installing from source, so do a rpm -qa | grep php* You should see php-4.x.x-x and to use MySQL with php, you should see... php-mysql4.x.x-x gamalt tant wrote: how do i check that my redhat8.0 contains php? is there some command inform me if php is included?