Disk Space Full

2007-01-30 Thread Nishant Gupta
g a table can I tell the server to stop accepting queries once the DB reaches a threshold (in terms of size/queries) Or any other alternative so that the at least the control returns to my code where i can handle this situation! -- Bye for now, Nishant God Gave Me Nothing I Wanted, He Gave

mysql server has gone away

2007-01-15 Thread Nishant Gupta
e database even though it returns an error!!! But thereafter, no query even gets logged and all return the same error. do u knw any othr circumstances in which such an error occurs? n whts the best poss soln here- to do a reconnect -- Bye for now, Nishant God Gave Me Nothing I Wanted, He Gave Me Everything I Needed !

mysqld_safe failing

2007-01-05 Thread Nishant Gupta
sedir=/usr --datadir=/var/lib/mysql --user=root --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock >> /var/log/mysqld.log 2>&1' ++ nohup /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=root --pid-file=/var/run/mysqld/mysqld.pid

Core dump in mysql_real_connect( )

2006-12-18 Thread Nishant Gupta
ompile it without Purify, the whole code works absolutely fine. Any idea what might be triggering this crash? -- Bye for now, Nishant God Gave Me Nothing I Wanted, He Gave Me Everything I Needed !

Re: MySSQL on HP-UX

2006-12-13 Thread Nishant Gupta
<[EMAIL PROTECTED]> wrote: Hi, Nishant Gupta wrote: > [/usr/local/mysql-5.1.12-beta-hpux11.11-hppa2.0w ]scripts/mysql_install_db > --user=mysql > chown: unknown user id mysql > Installing all prepared tables > 061212 19:39:30 [ERROR] Fatal error: Can't change to run as

Definition of mysql_server_init

2006-12-13 Thread Nishant Gupta
?? -- Bye for now, Nishant God Gave Me Nothing I Wanted, He Gave Me Everything I Needed !

MySSQL on HP-UX

2006-12-12 Thread Nishant Gupta
*Any idea what to do* Regards, Nishant Gupta Aricent (Flextronics Software Systems) Ph No- 0124-245 Extn -5256

Header Files

2006-12-04 Thread Nishant Gupta
Hello all I know its a very small thing to ask, but since am kinda stuck over this, plz consider this is as imp. Kindly let me know which header file do we need to include in order to use NOW( ) fn while using MySQL in C/C++. Thanks in advance... -- Bye for now, Nishant God Gave Me Nothing I

Sample program

2006-11-27 Thread Nishant Gupta
Hello all Sorry to disturb you, but am trying to start using MySql on Linux using C/C++. All the sample programs I found are merely compilable but crash while running. Can anyone post a simple program to insert a record in a table in a database? One more thing i needed to know that do we need to

Re: TABLE - OR

2003-09-01 Thread Nishant
wow. yeah it works. Thanks a lot. -N. > On Mon, 01 Sep 2003 17:13:20 +0900 > Nishant <[EMAIL PROTECTED]> wrote: > > > I dont know why my brain stopped working :) > > > > I have two tables T1 an

TABLE - OR

2003-09-01 Thread Nishant
I dont know why my brain stopped working :) I have two tables T1 and T2, both of which have a column : SerialNo Now I want to select those rows from T1 whose SerialNo is not present in T2. This dont work: select T1.* from table1 as T1 straight_join table2 as T2 where

sql Query problem?

2003-06-12 Thread Nishant
NICKNAME_48 262 NICKNAME_56 260 NICKNAME_44 260 NICKNAME_51 260 NICKNAME_47 256 NICKNAME_50 250 NICKNAME_58 246 NICKNAME_43 226 NICKNAME_60 140 NICKNAME_53 Nishant <[EMAIL PROTEC

request: mysql install question

2002-03-14 Thread Subbiah Nishant
After I went through the following steps successfully, (The previous problem I had regarding inability to untar files was solved by downloading stuff on that computer where it was untarred. Before that I was trying to untar stuff downloaded on to a samba share !!!) shell> groupadd mysql shell> u