FW: regarding mysql sever startup...

2002-04-16 Thread Chetan Lavti
-Original Message- From: Chetan Lavti Sent: Monday, April 15, 2002 10:01 AM To: [EMAIL PROTECTED] Subject: regarding mysql sever startup... hi, I am starting my Mysql Serevr like this.. cd /bin/sbin mysqld-max --user=root Is there any another method which doesn't require starting

regarding mysql sever startup...

2002-04-14 Thread Chetan Lavti
hi, I am starting my Mysql Serevr like this.. cd /bin/sbin mysqld-max --user=root Is there any another method which doesn't require starting the server by Root..(root privileges) please, help me out in this direction. Thanks and regards, Chetan Lavti

FW: To run MySQL Server from the remote machine

2002-04-01 Thread Chetan Lavti
-Original Message- From: Chetan Lavti Sent: Thursday, March 28, 2002 11:39 AM Subject: RE: To run MySQL Server from the remote machine hi, Is it possible to Start the MySQL Server from the remote machine..?? Mysql provides a Api's for shut down the server from the remote place

RE: To run MySQL Server from the remote machine

2002-03-27 Thread Chetan Lavti
time when I have to run the server it will be done manually... Please, if anybody knows about this..?? do help me.. I have to do this as soon as possible...?? Thanks and regards, Chetan Lavti - Before posting

RE: C API question

2002-03-27 Thread Chetan Lavti
hi, I think u don't need to convert it in to string... all the column values comes out in string only... or even u need to use atoi() Function for getting the Int ot unsigned int... I have used it... Chetan Lavti -Original Message- From: Federico Halperin [mailto:[EMAIL PROTECTED

RE: C API question

2002-03-27 Thread Chetan Lavti
hi, I think u don't need to convert it in to string... all the column values comes out in string only... I have used it... Chetan Lavti -Original Message- From: Federico Halperin [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 10:40 AM Subject: C API question In a table, I

RE: mysqldump : help needed very urgent

2002-03-24 Thread Chetan Lavti
who can suggest me any idea.. I have also tried for the Alter table Add but it is not working. Thanks and regards. Chetan Lavti -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 24, 2002 4:33 PM To: Chetan Lavti Cc: [EMAIL PROTECTED] Subject

mysqldump : help needed very urgent

2002-03-22 Thread Chetan Lavti
can suggest me alternative method for doing the same then it will be very usful for me. Waiting for response. Thanks and Regards, Chetan Lavti - Before posting, please check: http://www.mysql.com/manual.php

about mysqldump

2002-03-21 Thread Chetan Lavti
Hi, I want to know, whether the recovery from the file created using mysqldump, will also recover the foreign key between the tables. because when I am doing this it doesn't seems like that.. when I am doing recovery I am loosing all the foreign keys of by database tables. please, tell me it is

FW: mysqldump and foreign keys (possible Bug ??)

2002-03-20 Thread Chetan Lavti
has experience with the same problem and is it really the true.. if it is true then what's the use of mysqldump ..( which makes someone's database scattered.) Help me also !! it is urgent .. Thanks and regards, Chetan Lavti -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: mysqldump and foreign keys

2002-03-19 Thread Chetan Lavti
the mysqldesc tablename (at mysql command prompt) it shows the foreign keys.. am i right..?? Actually, I also wanted to know !! I am telling u what i have done and seen. Please, u also try for the same and see if it works fine. please, tell me also regarding this... Thanks and regards, Chetan Lavti

about Innodb table : backup and recovery..

2002-03-18 Thread Chetan Lavti
and regards, Chetan Lavti - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e

RE: running script through C program

2002-03-14 Thread Chetan Lavti
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 1:00 PM To: Chetan Lavti Subject: Re: running script through C program Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass

RE: mysql, query :running script through C program

2002-03-14 Thread Chetan Lavti
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 2:22 PM To: Chetan Lavti Subject: Re: mysql, query :running script through C program Your message cannot be posted because it appears to be either spam or simply off topic to our

mysql problem ( innodb server startup)

2002-03-14 Thread Chetan Lavti
=root ./mysqld-max: File '/path-to-dedicated-directory/hostname.1' not found (Errcode: 2) 020315 9:39:23 Could not use /path-to-dedicated-directory/hostname for logging (error 2) 020315 9:39:24 InnoDB: Started ./mysqld-max: ready for connections Thanks and regards, Chetan Lavti

mysql problem ( innodb server startup)

2002-03-14 Thread Chetan Lavti
=root ./mysqld-max: File '/path-to-dedicated-directory/hostname.1' not found (Errcode: 2) 020315 9:39:23 Could not use /path-to-dedicated-directory/hostname for logging (error 2) 020315 9:39:24 InnoDB: Started ./mysqld-max: ready for connections Thanks and regards, Chetan Lavti

Script for Data base backup and recovery : Very essential

2002-03-12 Thread Chetan Lavti
hi, Can anybody tell me how can I write script for MySQL backup and recovery.( i am newbie as per script is cencern) I am using Innodb table type and using all the default parameters specified in the my.cnf file (my-large.cnf) Looking for kind response.. Thanks and regards, Chetan Lavti

RE: RE: MySQL Backup and Recovery

2002-03-03 Thread Chetan Lavti
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 03, 2002 1:53 PM To: Chetan Lavti Subject: Re: RE: MySQL Backup and Recovery Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass

Again regarding MySQL Backup and Recovery

2002-03-03 Thread Chetan Lavti
other alternative procedure for that ..?? Which procedure I should follow..?? please, help me !! Thanks and Regards, Chetan Lavti -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 03, 2002 8:01 AM To: Chetan Lavti Cc: [EMAIL PROTECTED] Subject: Re

RE: Again regarding MySQL Backup and Recovery

2002-03-03 Thread Chetan Lavti
, Chetan Lavti -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 10:19 AM To: Chetan Lavti Cc: [EMAIL PROTECTED] Subject: Re: Again regarding MySQL Backup and Recovery On Mon, Mar 04, 2002 at 10:05:50AM +0530, Chetan Lavti wrote: I am using

MySQL Backup and Recovery

2002-03-01 Thread Chetan Lavti
Hi, I am planning to have MySQL database backup and recovery from the web interface. Is it possible to do this. If yes, then what procedure I should follow. If anybody have any idea about this then please, do help me. It's our requirement. Thanks and regards, Chetan Lavti

Row affected from Mysql Command line and api's

2002-03-01 Thread Chetan Lavti
of mysql_affected_rows(Mysql *) it returns 0 , Actually I am doing something based on it's return value but Instead of Rows matched: 1 what can I do ..? Please, anybody can help me out..?? Thanks and regards, Chetan Lavti - Before

RE: Row affected from Mysql Command line and api's

2002-03-01 Thread Chetan Lavti
( flag_test).. So, there is no question of returning boolean value..I think you interpreted it wrongly. isn't it ?? By the way, thanks for your suggestion. Thanks and regards, Chetan Lavti -Original Message- From: John Dean [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 5:25 PM

MySQL Backup and Recovery

2002-02-28 Thread Chetan Lavti
Hi, I am planning to have MySQL database backup and recovery from the web interface. Is it possible to do this. If yes, then what procedure I should follow. If anybody have any idea about this then please, do help me. It's our requirement. Thanks and regards, Chetan Lavti

auto increment problem

2002-02-25 Thread Chetan Lavti
hi, I creating a table where I am using one field as Auto Increment. I want to know two things or rather I want to do to thinks for the same column 1. When I am inserting the values and the Query fails, the increment should not took place and 2. When I delete a particular row from the table

table creation

2002-02-24 Thread Chetan Lavti
'), - NONCE VARCHAR(50), - FOREIGN KEY (USERID) REFERENCES USER(USERID)) TYPE=InnoDB; ERROR 1064: You have an error in your SQL syntax near 'USER(USERID)) TYPE=InnoDB' at line 8 Thanks and regards, Chetan Lavti

Script (Linux 7.1)

2002-02-22 Thread Chetan Lavti
hi, I have written a script for database creation and table creation. Now I want to run this script from the MySQL prompt. How can I do this..? Please , anybody know about this , so that I can create my database by simply running that script. Thanks and regards, Chetan Lavti

Script for database creation

2002-02-22 Thread Chetan Lavti
hi, I have written a script for database creation and table creation. Now I want to run this script from the MySQL prompt. How can I do this..? Please , anybody know about this , so that I can create my database by simply running that script. Thanks and regards, Chetan Lavti

for fetching particular colum

2002-02-14 Thread Chetan Lavti
hi, I am querying from the C api's,i am getting some result-set from which I want to display particular colum?? Is there any C api by which I can directly point to the particular colum and print it.. Thanks and regards, Chetan Lavti

MySQL RE: insertion problem !!

2002-02-12 Thread Chetan Lavti
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 2:22 PM To: Chetan Lavti Subject: Re: insertion problem !!=20 Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass

FW: MySQL RE: insertion problem !!

2002-02-11 Thread Chetan Lavti
have made sure that the value I am inserting for the 'domain_id' exists in the ls_domain table.) please tell me what could be the problem... INSERT INTO ls_user(ls_user,domain_id,user_name,user_flag,user_passwd,user_addr,user _email,created_by, created_date) VALUES(1,1,'Chetan Lavti','y

Error codes

2002-02-11 Thread Chetan Lavti
: here I want it's return type as 'int' { fprintf(stderr, %s\n, mysql_error(mysql) ); //mysql api exit(exitcode ); } please, if anyone can help me... Thanks and regards, Chetan Lavti - Before posting, please

Error codes..

2002-02-11 Thread Chetan Lavti
: here I want it's return type as 'int' { fprintf(stderr, %s\n, mysql_error(mysql) ); //mysql api exit(exitcode ); } please, if anyone can help me... Thanks and regards, Chetan Lavti - Before posting, please

MySQL RE: insertion problem !!

2002-02-07 Thread Chetan Lavti
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 2:22 PM To: Chetan Lavti Subject: Re: insertion problem !! Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass

FW: MySQL RE: insertion problem !!

2002-02-07 Thread Chetan Lavti
made sure that the value I am inserting for the 'domain_id' exists in the ls_domain table.) please tell me what could be the problem... INSERT INTO ls_user(ls_user,domain_id,user_name,user_flag,user_passwd,user_addr,user _email,created_by, created_date) VALUES(1,1,'Chetan Lavti','y

RE: InnoDB help !! OS: Linux 7.1

2002-01-30 Thread Chetan Lavti
| +---+---+ 1 row in set (0.00 sec) so, do you think I have done the write procedure for doing this...and is it ensuring the enabling of innodb feature; Thanks and regards, Chetan Lavti -Original Message- From: Arjen Lentz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 11:18 AM

RE: InnoDB help !!

2002-01-29 Thread Chetan Lavti
it ?? Please, help me as much you can !! I have been stuck at this place. Thanks and regards, Chetan Lavti -Original Message- From: Arjen Lentz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 10:42 AM To: Chetan Lavti Cc: [EMAIL PROTECTED] Subject: Re: InnoDB help !! Hi

about the stable version of MySQL-Max-3.23

2002-01-27 Thread Chetan Lavti
have also referred www.InnoDB.com for the same. If anybody can tell me when it's stable version is going to be declared. Thanks and regards, Chetan Lavti - Before posting, please check: http://www.mysql.com/manual.php

RE: Help needed !!!

2002-01-25 Thread Chetan Lavti
hi, Yes, I was really thinking about the InnoDB Tables, Thank you very much for such a systematic and accurate reply, Thanks and regards, Chetan -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 1:10 PM To: Chetan Lavti Cc: [EMAIL

Help needed !!!

2002-01-24 Thread Chetan Lavti
by which I can achieve the same. Thanks and regards, Chetan Lavti - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

regarding the MySQL's server Chaching feature

2002-01-21 Thread Chetan Lavti
hi, I am using (open source) MySQL-3.23.47, I wanted to know, is the feature of caching of the data in RAM is available in this version ?If yes , then what is the limit of that in terms of size. What I have Understood is that this feature will be available with the version 4.0 and if so, how

RE: regarding the MySQL's server Caching feature

2002-01-21 Thread Chetan Lavti
Lavti Cc: [EMAIL PROTECTED] Subject: Re: regarding the MySQL's server Caching feature On Tue, Jan 22, 2002 at 12:57:12PM +0530, Chetan Lavti wrote: Is there any other way (except query cache) using which the database can be made memory resident. Actually I want a database which is to be used