mysql installation problem

Hi, I am trying to install myql on redhat. mysql package used: mysql-3.23.52-unknown-freebsdelf4.6-i386.tar.gz While following the instructions in install document..when i run the follwing command.. scripts/mysql_install_db following errors appear: - scripts/mysql_install_db: ./bin/my

database query.

Hi, I have a table as shown with approx 500 lines: --- Tndr| Detail| 34 | one | 47 | two | 34

RE: database query.

hi, I appreciate the time you spared for my problem. Thanks, that helped :) Regards Anil -Original Message- From: Bruce Feist [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 2:47 PM To: Anil Garg Subject: Re: database query. There really isn't enough information for

mysqldump

Hi, I need to dump a database table in tab seperated or comma seperated format and then want to delete the entries in that table.(And then mail the dump to someone.) Can i get some pointers about this. (I was not able to use -T option in mysqldump, i am trying "./mysqldump -T awf_four false_info

command line exectution of query(newbie)

Hi, What am i doing wrong: # ./mysql -e "delete * from where id > 5;" I get the mysql help page on exectuting the above command. The mysql verison i am using is : 3.23.52. Thanks and regards anil. - Before posting, please c

RE: command line exectution of query(newbie)

Sorry, # ./mysql -e "delete from where id > 5;" The above command too doesn't work, it shows the mysql man page.:( any more ideas? thanks and regards anil. -Original Message- From: Jocelyn Fournier [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 2:3

RE: command line exectution of query(newbie)

thanks, that helped :) -Original Message- From: Jennifer Goodie [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 1:49 PM To: Anil Garg; [EMAIL PROTECTED] Subject: RE: command line exectution of query(newbie) Database name goes after options. It is showing you the help page

date query.

Hi, The date field in my database table looks as below: 07th of March 2003 10:14:29 PM I need to write a query which gets me all the rows which are entered in last to weeks. Any ideas!! Thanks and Regards Anil. - Before posti

RE: date query.

Thanks..that helped. anil :) -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 10:52 AM To: [EMAIL PROTECTED] Cc: Anil Garg Subject: Re: date query. * Anil Garg > The date field in my database table looks as below: > 07th of March 2003

oracle.

hi, m a frequent user of mysql. i was trying to use "show tables" on oracle(sql>), but it dint work :( How do list tables in oracle? Thanks anil. p.s. sorry for the out of list question. - Before posting, please check: http:

RE: oracle.

thanks, that helped anil :) -Original Message- From: Nestor Florez [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 12:51 PM To: Anil Garg Subject: Re: oracle. Anil, I do not remember correct but you need to look at the user_tables. 'desc user_tables' One of the fi

Re: STRING TO NUMBER

i think u dont need to it will automatically deal with it. - Original Message - From: "Marcel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 3:26 PM Subject: STRING TO NUMBER > Hi, > In Oracle i use TO_NUMBER to convert a String to a Number what Function Do i

errno: 145

hi when i try to read a table using query > select * from it shows following error: cant open file:'anil.MYD'.(errno: 145) y such an error can come!! earlier it was fine. thanx for help anil - Before posting, please check

changing column name

Hi Can anyone plz give me the query for chaning the column name of an existing table(which does not affect the elements of that column). I hope there is a way to do that. Any help appreciated Thanx Anil - Before posting, ple

Re: help with empty set

have u tried with \0 ?? - Original Message - From: "Chris Hohimer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 05, 2002 1:54 PM Subject: help with empty set > using PHP what is the value for a returned result from MySQL of "empty > set" > ex: > > if($result != NULL)

Re: help with empty set

- Original Message - From: "Chris Hohimer" <[EMAIL PROTECTED]> To: "Anil Garg" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, June 05, 2002 2:26 PM Subject: Re: help with empty set > yeah that kinda works... > > what i have

not able to edit table:((

Hi, I am not able to edit a table: the sql queries i tried are follows: >delete form documents where id = 134;gives the following error: error: table documents is read only repair doesnt seem to work repair table documents; Table Op Mst_typeMsg_text mydb.docume

Re: not able to edit table:((

The persmissions seems to be ok. ne other ideas!! - Original Message - From: "Kiss Dániel" <[EMAIL PROTECTED]> To: "Anil Garg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 12:59 PM Subject: Re: not able to edit table:(( >

long table scroll down

Hi, for viewing long tables. in my sql query when i say SELECT * FROM abc i miss the upper entries of the table as they scroll down. is there something by which i can view a table page by page(as | more in unix) thanx anil - B

query: restartmysql daemon

Hi, the sql process(on doing ps) shows the following process: /usr/local/bin/safe_mysqld --user=mysql when i kill this process and try to restart it with command: safe_mysqld --user=mysql it says "a mysql process already exists". can anyone tell me how to restart mysql daemon. thanx anil --

Lost Connection to mysql server during query

Hi, Here is a strange problem!! I created a table by the following qurey: CREATE TABLE 1_polls ( id int(11) unsigned NOT NULL auto_increment, question varchar(128) NOT NULL default '', active tinyint(1) unsigned NOT NULL default '1', sortorder int(11) NOT NULL default '0', module_id in

Re: Lost Connection to mysql server during query

Hi, Thanx for your mail You are rightin my case the mysqld is getting restarted. But, whey is mysqld getting restarted and giving the Lost Connection error. How can i avoid that?? Thanx anil - Original Message - From: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]> To: &qu

changing coulmn

in my table a column has enties my_1 my_4 my_5 i wnat to change it to my_file_1 my_file_4 my_file_5 can someone please tell me the query for that. thanx anil - Before posting, please check: http://www.mysql.com/manual

Re: changing coulmn

thanx for ur mail, m sorry in dint mention that infact its a big table... Is there a way i can do it in all the columns using only one query ?? thanx anil - Original Message - From: "nellA hciR" <[EMAIL PROTECTED]> To: "Anil Garg" <[EMAIL PROTECTED]> Cc: &

replace query

Hi, i have a table with 2000 rows. One column (name answer)has a string ("ok --") in all the rows.(e.g "ok -- yes we support this."). now i want to remove all these 'ok --' in this column..leaving(e.g yes we support this) I tried to do it with the replace query but being a newbie to mysql i couldn

' giving problem while inserting in table.

Hi, I am making a faq maintenance system using mysql and php. To insert a entry in to a faq table i am using the following query: - INSERT INTO faq_table_netvd (id,question, answer,netvcr,netdetector,add_date,mod_date,keyword,category,display,attach_ id) VALUES ('0','$frm[question]', '$fr

Re: UPDATE command..

update set id = replace(id, '1', '2'); hope this helps anil - Original Message - From: "Patrick J Okui" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 16, 2002 9:47 AM Subject: UPDATE command.. > > > I have two collumns in my mysql database like this > > +

mysql upgrade

hi, I cant use some characters in my full text search (like * , "" , etc.) I found out that it was due to the old version of the mysql i am using. Now the problem is i want to switch from the older version(3.23.49) to 4.0.2 so that my full text search can be more efficient. Can some one tell me w

mysql upgrade

hi, I cant use some characters in my full text search (like * , "" , etc.) I found out that it was due to the old version of the mysql i am using. Now the problem is i want to switch from the older version(3.23.49) to 4.0.2 so that my full text search can be more efficient. Can some one tell me w

Re: Lost root password

c if this helps: 1.. Cold Reboot the machine and hit the SPACE bar to stop loading when this message appears: Hit[ENTER] to boot immediately or any other key for cmd prompt. Booting kernel in 9,8,7? 2.. Type: boot -s (machine now in single user mode.) You will see the following message

Supplied argument is not a valid MySQL result resource!!

Hi, in the piece of code given below --- $qid = mysql_query(" SELECT * FROM 1_nodedata WHERE id = $edit_id "); $frm = mysql_fetch_array($qid); --- i get the follownig error: Warning: Supplied argument is not a valid MySQL result resource in /z/mercury/www/niksun/admin/add_doc

Re: Supplied argument is not a valid MySQL result resource!!

hi, m sorry i dint mention that its just a part of code. i am able to delete entries from the database .so i think mysql_connect is not the reason. please tell if u have some more ideas regards anil - Original Message - From: "SteveH" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thur

Re: Supplied argument is not a valid MySQL result resource!!

yes..it echos $edit_id fine. i am also feeling strange why its not working! regards anil - Original Message - From: "Jocelyn Fournier" <[EMAIL PROTECTED]> To: "Anil Garg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 5:4

Re: Supplied argument is not a valid MySQL result resource!!

can u plz tell me how can i check that? regards anil - Original Message - From: "Dan Nelson" <[EMAIL PROTECTED]> To: "Anil Garg" <[EMAIL PROTECTED]> Cc: "SteveH" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002

which version to use?

hi What version combinations of mysql and php should be used? regards anil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request th

cant connect to mysql

hi i am facing a very strange problem.. when i say "apachectl restart" my web site works fine.. but, when i say #apachectl stop #apachectl start the web user is not able to connect to the mysql database. Now, when i reboot the machine, the things become fine agian. I would reaaly appreciat

users who can access a database

hi, Is there some place where i can define the users who can access the database. If yes..plz help thanx and regards anil sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://l