FW: regarding mysql sever startup...
-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 the server by Root..(root privileges) please, help me out in this direction. 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 this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 the server by Root..(root privileges) please, help me out in this direction. 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 this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: To run MySQL Server from the remote machine
-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 i.e. ( mysql_shutdown(mysqlhadler)) > but I can't see any api for starting the Mysql server from the remote > machine. > > Does it mean that every 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, 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: C API question
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 declared a column which is an integer unsigned. After calling mysql_fetch_row, I need to convert the value of the column (i.e. row[0]) to a string. I tried to solve it doing this: char var[11]; sprintf (var, "%u", row[0]); , but it doesn't work. Is *row[0] an unsigned int? Can anybody help me??? _ Con MSN Hotmail súmese al servicio de correo electrónico más grande del mundo. http://www.hotmail.com/ES - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: C API question
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]] Sent: Thursday, March 28, 2002 10:40 AM Subject: C API question In a table, I declared a column which is an integer unsigned. After calling mysql_fetch_row, I need to convert the value of the column (i.e. row[0]) to a string. I tried to solve it doing this: char var[11]; sprintf (var, "%u", row[0]); , but it doesn't work. Is *row[0] an unsigned int? Can anybody help me??? _ Con MSN Hotmail súmese al servicio de correo electrónico más grande del mundo. http://www.hotmail.com/ES - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: To run MySQL Server from the remote machine
> hi, > > Is it possible to run the MySQL Server from the remote machine..?? > Mysql provides a Api's for shutting down the server from the remote > place i.e. ( mysql_shutdown(mysqlhadler)) > but I can't see any api for starting the Mysql server from the remote > machine. > > Does it mean that every 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, 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysqldump : help needed very urgent
thank u very much... but I am planning for one approach is it right .. as by mysqldump we can take back up of Table structure and Insert values separately.. As my database will remain constant through out for the application I can insert the foreign key lines in the dumped file once and as the insert values are in the separate file, when ever I will do backup first I will use the Table structure file which will be constant(will not be backup every time) and then the backup data file. This way I am able to make get the Foreign key even my using the mysqldump.. What do u say ..?? anybody 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 Hi! >>>>> "Chetan" == Chetan Lavti <[EMAIL PROTECTED]> writes: Chetan> Hi, Chetan> I am using Mysql version 3.23.47-Max client and server and using Innodb Chetan> table type. Chetan> I am doing my database backup using the mysqldump utility. Chetan> Once I have done with database backup, I am deleting all my database and Chetan> again recovering(creating) the database using the dumped file. Chetan> Now, the question is after recovery of the database, I am not getting Chetan> the foreign key relationship between the tables. Chetan> Why this happens...? is it the problem with mysqldump...?? and if it Chetan> really the case then how can i re-create my whole database and keep all Chetan> my database retaining the foreign keys. Chetan> If anyone can suggest me alternative method for doing the same then it Chetan> will be very usful for me. Chetan> Waiting for response. The problem here is that in MySQL 3.23 FOREIGN KEY definitions is not part of the mysqldump output. This will be fixed in MySQL 3.23.50 and 4.0.2, both which will be available shortly. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump : help needed very urgent
Hi, I am using Mysql version 3.23.47-Max client and server and using Innodb table type. I am doing my database backup using the mysqldump utility. Once I have done with database backup, I am deleting all my database and again recovering(creating) the database using the dumped file. Now, the question is after recovery of the database, I am not getting the foreign key relationship between the tables. Why this happens...? is it the problem with mysqldump...?? and if it really the case then how can i re-create my whole database and keep all my database retaining the foreign keys. If anyone 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 (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
about mysql C api's
hi, I am using InnoDB table type.. I have done almost all the operation through the api's as connect,insert,delete, update, close connection etc, Now, I have one problem, I know that there is one api for Shutting down the MySQL Server i.e. int mysql_shutdown(*mysql) I want to know whether there is any api for starting the mysql Server or not ..?? I gone through the MySQL Manual ..Could not find anything regarding this.. Anybody, who knows about this..or knows any other method other then manually doing it?/ Please, help me. 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 this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
about mysqldump
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 affecting my database backup and recovery... Thanks and regards, Chetan - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: mysqldump and foreign keys (possible Bug ??)
hi, I think u r right.. because after recovering from the dumped database, when insert a value in the foreign key column which is not present in the primary key, it accepts the row inserted. which is not true when I do the same think from the mysql command prompt,( before dumping) Anybody who 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 PROTECTED]] Sent: Wednesday, March 20, 2002 9:35 PM To: Chetan Lavti Subject: Re: mysqldump and foreign keys (possible Bug ??) No, not working, When I run the command SHOW TABLE STATUS FROM yourdatabasename LIKE 'T'; shown in the manual (7.5.4.2 Foreign Key Constraints) I will see the foreign key (in the comments collumn). But if I dump and then reload the dump into mySQL the foreign key is gone. Experts, is this a BUG Adib. Chetan Lavti wrote: > hi, > I am also using the Innodb table type for my database. when I am using > the mysqldump for dumping the tables it really doesn't shows the > foreign key in the table structure. > but if after deleting my previous database I again create my database > using the same dumped file and executes the > > mysql>desc > > (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 > > > - > 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-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- WIGE DATA GmbH Wiesenring 11, D-04159 Leipzig, Germany Adib Taraben Electronic Engineer PHONE +49 (0)341 - 46 21 100 FAX +49 (0)341 - 46 21 400 E-MAIL [EMAIL PROTECTED] INTERNETwww.wige-data.de A company of WIGE MEDIA AG - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysqldump and foreign keys
hi, I am also using the Innodb table type for my database. when I am using the mysqldump for dumping the tables it really doesn't shows the foreign key in the table structure. but if after deleting my previous database I again create my database using the same dumped file and executes the mysql>desc (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 - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
about Innodb table : backup and recovery..
hi, We can take backup for the subject above by two ways, One way is by mysqldump ( Which I am using ..) Now, I the second method 1. Shut down your MySQL database and make sure it shuts down without errors. 2. Copy all your data files into a safe place. 3. Copy all your InnoDB log files to a safe place. 4. Copy your `my.cnf' configuration file(s) to a safe place. 5. Copy all the `.frm' files for your InnoDB tables into a safe place. How to know which are the data files and InnoDB log files, can we distinguish these file simply by name. I mean to say that if I want to list out log file and data files one time at a time!! can I do it simply by name !! ( I know the path for this specified in the my.cnf file ) Which is the procedure of backup in which I don't need to shutdown the MySQL Server. 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 this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql problem ( innodb server startup)
hi, When I am starting the mysqld-max daemon there appears two errors !! I have intalled it on the another machine !! At this machine only, i am facing this problem, previously it was running O.K. anybody who can tell me how to resolve this problem...?? [root@dev1 sbin]# ./mysqld-max --user=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 - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql problem ( innodb server startup)
hi, When I am starting the mysqld-max daemon there appears two errors !! I have intalled it on the another machine !! At this machine only, i am facing this problem, previously it was running O.K. anybody who can tell me how to resolve this problem...?? [root@dev1 sbin]# ./mysqld-max --user=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 - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql, query :running script through C program
-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 filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hi, I have written one script for backup .. now, I want to run this script from the C program,,, How can I do this ...?? please, help me !!=3D20 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 this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: running script through C program
-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 the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hi, I have written one script for backup .. now, I want to run this script from the C program,,, How can I do this ...?? please, help me !!=20 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 this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Script for Data base backup and recovery : Very essential
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 - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Again regarding MySQL Backup and Recovery
Thank you very much !! I have a management screen, where I have two button namely "BACKUP" and "RECOVERY". I am not able to find out, how this will be done(both BACKUP and RECOVERY)?, when I click on the corresponding buttons and while doing this if error occurs, how I will handle them?. Moreover, between these two methods which one to use (keeping in mind the advantages and disadvantages of both the methods). Basically, how to link the "BACKUP" and "RECOVERY" procedure with the management screen(HTML page, web) and how to handle the errors occurred during this procedure. Thanks and regards, 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 3.23.47 and InnoDB table type on Linux7.1 platform. > Now,for this database backup and recovery procedures are given as : > > 1.Taking 'binary' backup of the database. > 2.Using the mysqldump utility > > In the first method we do the following things : > > · Shut down your MySQL database and make sure it shuts down > without errors. > · Copy all your data files into a safe place. > · Copy all your InnoDB log files to a safe place. > · Copy your `my.cnf' configuration file(s) to a safe place. > · Copy all the `.frm' files for your InnoDB tables into a safe > place Yes, in fact, it looks like you grabbed that right out of the InnoDB docs. :-) > And the second method is just a utility which is to run without > shutting down the server.(with the disadvantage of slower speed of > the Backup and recovery) > > Am I right ?? Yes. > Actually I am new to this field and I want that this is to be done > through the Web. How should I do that.?? What does "through the web" mean? You want to initiate the backups via a web page? You want to be able download the backup files that way? Something else? Tell us what you're trying to do and we'll try to help. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 24 days, processed 812,615,871 queries (382/sec. avg) - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Again regarding MySQL Backup and Recovery
hi, I am using MySQL 3.23.47 and InnoDB table type on Linux7.1 platform. Now,for this database backup and recovery procedures are given as : 1. Taking 'binary' backup of the database. 2. Using the mysqldump utility In the first method we do the following things : · Shut down your MySQL database and make sure it shuts down without errors. · Copy all your data files into a safe place. · Copy all your InnoDB log files to a safe place. · Copy your `my.cnf' configuration file(s) to a safe place. · Copy all the `.frm' files for your InnoDB tables into a safe place And the second method is just a utility which is to run without shutting down the server.(with the disadvantage of slower speed of the Backup and recovery) Am I right ?? Actually I am new to this field and I want that this is to be done through the Web. How should I do that.?? Any 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: MySQL Backup and Recovery On Fri, Mar 01, 2002 at 09:26:36AM +0530, Chetan Lavti wrote: > > 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. Backup and recovery is a common topic on this list. Have you scanned the archives yet? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 23 days, processed 764,260,032 queries (376/sec. avg) - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: RE: MySQL Backup and Recovery
-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 the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hi, Thank u very much for positive reply !! Actually, what I am wanting to do is that instead of manual backup and recovery, there should be two buttons at the page as 'BACKUP' and 'RECOVERY'. As I click on the 'BACKUP' button the script for taking backup should run and similarly, in case of DB crash the recovery script should run when, I click on the 'RECOVERY' button. Will it be feasible..? =20 So, is it possible, then what is the correct way to do this??( Any reference material for doing the same..??) and if error occurs while doing this then what can be done ?? ( How to handle them..?? ) please, give me detailed information or links for this.( If it is possible for you!) 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 this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Row affected from Mysql Command line and api's
Nope, Sorry, but nowhere I was thinking about the boolean value. I was only talking about the return value of mysql_affected_rows(Mysql *)and it's return type is (unsigned int), which depends upon the no of rows affected by the last query. I have just ask you based upon a very rough table( 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 To: DL Neil; Chetan Lavti; [EMAIL PROTECTED] Subject: Re: Row affected from Mysql Command line and api's Hi I think you need to read a book on C since C has no notion of a boolean value At 11:40 01/03/2002 +, DL Neil wrote: >Hi Chetan, > >Suppose I have a table : > >mysql> select * from flag_test; >++--+ >| name | flag | >++--+ >| Chetan | Y| >++--+ >1 row in set (0.00 sec) > >I am setting/unsetting the flag field from the api's ; > >Now if the flag is already set and I executes the Query from the Mysql >Command prompt it shows : >MySQL> update flag_test set flag='Y' where name='chetan'; >Query OK, 0 rows affected (0.00 sec) >Rows matched: 1 Changed: 0 Warnings: 0 > >but if the same Query I run from the C program and if I check the return >value 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 > > >=The function only returns the number of rows "affected"/updated, not >the number of rows "matched" (in the WHERE clause). In this case, if the >flat was already "Y" (your interaction from the MySQL client), then the >C program will not have had a change to make - and not counted it as >"affected". > >=Change the flag to non-Y, and then re-run the C prog. > >=Regards, >=dn > > > >- >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-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards John, Former MySQL Developer - [EMAIL PROTECTED] http://www.rygannon.com - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Row affected from Mysql Command line and api's
Hi, If anyone can help me !! Suppose I have a table : mysql> select * from flag_test; ++--+ | name | flag | ++--+ | Chetan | Y| ++--+ 1 row in set (0.00 sec) I am setting/unsetting the flag field from the api's ; Now if the flag is already set and I executes the Query from the Mysql Command prompt it shows : MySQL> update flag_test set flag='Y' where name='chetan'; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 but if the same Query I run from the C program and if I check the return value 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 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Backup and Recovery
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 - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Backup and Recovery
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 - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
auto increment problem
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 there should not be any gap in the auto increment sequence. Is it possible..?? I am not much enthusiastic about the second one because I don't think that I will use it. Anyone who can help me out for this.?? Thanks and regards, Cretan Latvia - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
table creation
hi,
I am not able to create the third table i.e. AUTHENTICATE, In the first
two tables I have no problem ( i.e. DOMAIN and USER), I am giving you
the structure of all the three table along with the error i am getting..
I am not able to find out the mistake have done, please, help me..
---
mysql> Create table DOMAIN
-> (
-> DOMAINIDINT(4) UNSIGNEDAUTO_INCREMENT ,
-> DOMAIN_ADDR VARCHAR(80),
-> DOMAIN_NAME CHAR(50) UNIQUE KEY,
-> DOMAIN_PORT INT(6) UNSIGNED,
-> DOMAIN_IP CHAR(12),
-> CREATED_BY VARCHAR(40),
-> CREATED_DATEDATE,
-> PRIMARY KEY (DOMAINID)) TYPE=InnoDB;
Query OK, 0 rows affected (0.05 sec)
--
mysql> Create table USER
-> (
-> USERID INT(4) UNSIGNED AUTO_INCREMENT ,
-> DOMAINIDINT(4) ,
-> INDEX DOID (DOMAINID),
-> USERNAMEVARCHAR(30) UNIQUE KEY,
-> USERFLAGCHAR(1) ,
-> USERPASSWD VARCHAR(8) ,
-> USERADDRVARCHAR(120),
-> USEREMAIL VARCHAR(50),
-> CREATED_BY VARCHAR(30),
-> CREATED_DATEDATE,
-> FOREIGN KEY (DOMAINID) REFERENCES DOMAIN(DOMAINID),
-> PRIMARY KEY (USERID)) TYPE=InnoDB;
Query OK, 0 rows affected (0.00 sec)
---
mysql> Create table AUTHENTICATE
-> (
-> USERID INT(4) UNSIGNED,
-> INDEX USID(USERID),
-> AUTH_TYPE ENUM('BASIC','DIGEST'),
-> ALGO_USED ENUM('MD5','SESSION'),
-> 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
-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Script for database creation
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 - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Script (Linux 7.1)
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 - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
for fetching particular colum
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 - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL RE: insertion problem !!
-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 the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: hi, I have two tables as:=3D20 please concentrate on domain_id and INDEX=3D20 Create table ls_domain ( domain_id INT(4) UNSIGNED AUTO_INCREMENT , domain_addr VARCHAR(80), domain_name CHAR(50) UNIQUE KEY, domain_port INT(6) UNSIGNED, domain_ip VARCHAR(15), created_by VARCHAR(40), created_date DATE, PRIMARY KEY (domain_id) ) TYPE=3D3DInnoDB; I have created and inserted values in it then.. Create table ls_user ( user_id INT(4) UNSIGNED AUTO_INCREMENT , domain_id INT(4), INDEX do_id (domain_id), user_name VARCHAR(30) UNIQUE KEY, user_flag CHAR(1) , user_passwd VARCHAR(8) , user_addr VARCHAR(100), user_email VARCHAR(50), created_by VARCHAR(30), created_date DATE, FOREIGN KEY (domain_id) REFERENCES ls_domain(domain_id), PRIMARY KEY (user_id) ) TYPE=3D3DInnoDB; It has also been created. Now when I am inserting values in ls_user it is giving error as mentioned below..( I 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','chetan','116-C,Mayur Vihar','[EMAIL PROTECTED]','Chetan Lavti','2002-02-07'); ERROR 1216: Cannot add a child row: a foreign key constraint fails Please, help me for 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 this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error codes..
hi,
I am using C api's for accessing the MySQL server, I want to make use of
the mysql api's inside the functions I have made. I do not want to print
the description of the error, instead, I want to display out the error
code corresponding to that message.
Is there any description about this in this.I know about the perror by
which one can get the message corresponding to error, but i want to make
the return type of my api as int ( which is the error code),
I am using my api and inside this I am using mysql's api's e.g.
sip_server_display_error(int exitcode) //my function :
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 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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error codes
hi,
I am using C api's for accessing the MySQL server, I want to make use of
the mysql api's inside the functions I have made. I do not want to print
the description of the error, instead, I want to display out the error
code corresponding to that message.
Is there any description about this in this.I know about the perror by
which one can get the message corresponding to error, but i want to make
the return type of my api as int ( which is the error code),
I am using my api and inside this I am using mysql's api's e.g.
sip_server_display_error(int exitcode) //my function :
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 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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: MySQL RE: insertion problem !!
hi, I have two tables as : please concentrate on domain_id and INDEX Create table ls_domain ( domain_id INT(4) UNSIGNED AUTO_INCREMENT , domain_addr VARCHAR(80), domain_name CHAR(50) UNIQUE KEY, domain_port INT(6) UNSIGNED, domain_ip VARCHAR(15), created_by VARCHAR(40), created_date DATE, PRIMARY KEY (domain_id) ) TYPE=3DInnoDB; I have created and inserted values in it then.. Create table ls_user ( user_id INT(4) UNSIGNED AUTO_INCREMENT , domain_id INT(4), INDEX do_id (domain_id), user_name VARCHAR(30) UNIQUE KEY, user_flag CHAR(1) , user_passwd VARCHAR(8) , user_addr VARCHAR(100), user_email VARCHAR(50), created_by VARCHAR(30), created_date DATE, FOREIGN KEY (domain_id) REFERENCES ls_domain(domain_id), PRIMARY KEY (user_id) ) TYPE=3DInnoDB; It has also been created. Now when I am inserting values in ls_user it is giving error as mentioned below..( I 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','chetan','116-C,Mayur Vihar','[EMAIL PROTECTED]','Chetan Lavti','2002-02-07'); ERROR 1216: Cannot add a child row: a foreign key constraint fails Please, help me for 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 this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: MySQL RE: insertion problem !!
hi, I have two tables as : please concentrate on domain_id and INDEX Create table ls_domain ( domain_id INT(4) UNSIGNED AUTO_INCREMENT , domain_addr VARCHAR(80), domain_name CHAR(50) UNIQUE KEY, domain_port INT(6) UNSIGNED, domain_ip VARCHAR(15), created_by VARCHAR(40), created_date DATE, PRIMARY KEY (domain_id) ) TYPE=InnoDB; I have created and inserted values in it then.. Create table ls_user ( user_id INT(4) UNSIGNED AUTO_INCREMENT , domain_id INT(4), INDEX do_id (domain_id), user_name VARCHAR(30) UNIQUE KEY, user_flag CHAR(1) , user_passwd VARCHAR(8) , user_addr VARCHAR(100), user_email VARCHAR(50), created_by VARCHAR(30), created_date DATE, FOREIGN KEY (domain_id) REFERENCES ls_domain(domain_id), PRIMARY KEY (user_id) ) TYPE=InnoDB; It has also been created. Now when I am inserting values in ls_user it is giving error as mentioned below..( I 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','chetan','116-C,Mayur Vihar','[EMAIL PROTECTED]','Chetan Lavti','2002-02-07'); ERROR 1216: Cannot add a child row: a foreign key constraint fails Please, help me for 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 this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL RE: insertion problem !!
-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 the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: hi, I have two tables as:=20 please concentrate on domain_id and INDEX=20 Create table ls_domain ( domain_id INT(4) UNSIGNED AUTO_INCREMENT , domain_addr VARCHAR(80), domain_name CHAR(50) UNIQUE KEY, domain_port INT(6) UNSIGNED, domain_ip VARCHAR(15), created_by VARCHAR(40), created_date DATE, PRIMARY KEY (domain_id) ) TYPE=3DInnoDB; I have created and inserted values in it then.. Create table ls_user ( user_id INT(4) UNSIGNED AUTO_INCREMENT , domain_id INT(4), INDEX do_id (domain_id), user_name VARCHAR(30) UNIQUE KEY, user_flag CHAR(1) , user_passwd VARCHAR(8) , user_addr VARCHAR(100), user_email VARCHAR(50), created_by VARCHAR(30), created_date DATE, FOREIGN KEY (domain_id) REFERENCES ls_domain(domain_id), PRIMARY KEY (user_id) ) TYPE=3DInnoDB; It has also been created. Now when I am inserting values in ls_user it is giving error as mentioned below..( I 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','chetan','116-C,Mayur Vihar','[EMAIL PROTECTED]','Chetan Lavti','2002-02-07'); ERROR 1216: Cannot add a child row: a foreign key constraint fails Please, help me for 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 this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: InnoDB help !! OS: Linux 7.1
hi, I have run the script mysql_install_db --with-innodb. then I am getting the mysql>show variables like "have_innodb"; +---+---+ | Variable_name | Value | +---+---+ | have_innodb | YES | +---+---+ 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 To: Chetan Lavti Cc: [EMAIL PROTECTED] Subject: RE: InnoDB help !! Hi, On Wed, 2002-01-30 at 15:19, Chetan Lavti wrote: > It seems, you suggesting that after setting changes in the configuration > file the "Show variable." will list out the 'YES' in front of > 'have_innodb' (in table below). right ?? Indeed. > The second thing is that, how do I test for the innoDB support ? In exactly the same way. You can run the above query from your application too, no prob. For instance: SHOW VARIABLES LIKE "have_innodb" If the result set contains at least 1 row and the "Value" (2nd) column of the result set is "YES", then you know that InnoDB is enabled in the server. > specifically whether it is making the my database memory-resident or > not. What do you mean? Regards, Arjen. -- Get MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: InnoDB help !! OS: Linux
hi, I am referring "Innodb startup options" and "my.cnf file options" as in the manual. Till this I have installed the MyQSL-Max-3.23.47 and mysql-max daemon is running. I can go to mysql command prompt. mysql> show variables like "have_innodb"; +---+--+ | Variable_name | Value| +---+--+ | have_innodb | DISABLED | +---+--+ 1 row in set (0.00 sec) I am wanting to enable have_innodb feature. I am in trouble because whatever given in the manual to set the configuration file my.cnf for enabling innodb is not like it is appearing. I am going to give you more details as in some of the outputs..so please help me out. I have to configure it very urgently. 1. I have found the files my-.cnf at /usr/doc/MySQL-3.23.47 ( and at . I have uncommented the variable (please, see the file o/p below) innodb_data_file_path = ibdata1:1000M ( what is ibdata1 ? do I need to create this.?? ) innodb_data_home_dir = /var/lib/mysql/ then, I have renamed one of the my-.cnf file to my.cnf and copied it to the /etc/ . butif I do this and try to go to mysql command prompt still I am getting mysql> show variables like "have_innodb"; +---+--+ | Variable_name | Value| +---+--+ | have_innodb | DISABLED | +---+--+ 1 row in set (0.00 sec) What does it shows !! still innodb not enabled ? How do I ensure the innoDB that it has been enabled ? do I need to do more changes in the my.cnf file ? or I have to place it at more the one directories? Please, do the needful..? Thanks and regards, Chetan Lavti -Original Message- From: Arjen Lentz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 11:18 AM To: Chetan Lavti Cc: [EMAIL PROTECTED] Subject: RE: InnoDB help !! Hi, On Wed, 2002-01-30 at 15:19, Chetan Lavti wrote: > It seems, you suggesting that after setting changes in the configuration > file the "Show variable." will list out the 'YES' in front of > 'have_innodb' (in table below). right ?? Indeed. > The second thing is that, how do I test for the innoDB support ? In exactly the same way. You can run the above query from your application too, no prob. For instance: SHOW VARIABLES LIKE "have_innodb" If the result set contains at least 1 row and the "Value" (2nd) column of the result set is "YES", then you know that InnoDB is enabled in the server. > specifically whether it is making the my database memory-resident or > not. What do you mean? Regards, Arjen. -- Get MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: InnoDB help !!
thanks again, It seems, you suggesting that after setting changes in the configuration file the "Show variable." will list out the 'YES' in front of 'have_innodb' (in table below). right ?? The second thing is that, how do I test for the innoDB support ? specifically whether it is making the my database memory-resident or not. Thank u very much once again. regards, Chetan Lavti -Original Message- From: Arjen Lentz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 3:11 AM To: Chetan Lavti Cc: [EMAIL PROTECTED] Subject: RE: InnoDB help !! Hi, On Wed, 2002-01-30 at 00:06, Chetan Lavti wrote: > thanks for your quick reply !! > > that's fine !! I have done the max.RPM installation part. > but what is "fix up the startup scripts so that > binary will be the one started." > > When I am trying "show variables like "have_%"; > +---+---+ > | Variable_name | Value | > +---+---+ > | have_bdb | NO| > | have_gemini | NO| > | have_innodb | NO| > | have_isam | YES | > | have_raid | NO| > | have_openssl | NO| > +---+---+ > 6 rows in set (0.00 sec) > > It's not showing innoDB support. Ideally it should show after installing > the max.RPM. shouldn't it ?? No. In any 3.23 version, the default for all alternate table types is off. You have to explicitly enable them by specifying their configuration parameters. See http://www.mysql.com/doc/I/n/InnoDB_start.html and the rest of the InnoDB chapter in the online manual for configuration details. Regards, Arjen. -- Get MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: InnoDB help !!
thanks for your quick reply !! that's fine !! I have done the max.RPM installation part. but what is "fix up the startup scripts so that binary will be the one started." When I am trying "show variables like "have_%"; +---+---+ | Variable_name | Value | +---+---+ | have_bdb | NO| | have_gemini | NO| | have_innodb | NO| | have_isam | YES | | have_raid | NO| | have_openssl | NO| +---+---+ 6 rows in set (0.00 sec) It's not showing innoDB support. Ideally it should show after installing the max.RPM. shouldn't 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, On Tue, 2002-01-29 at 14:10, Chetan Lavti wrote: > I have downloaded and installed MySQL ( rpm's). Now, I want to configure > it with InnoDB option, as given in the manual, > but can't see the below configure file anywhere. > // cd /path/to/source/of/mysql-3.23.37 >./configure --with-innodb > can anybody help me about this.. The info you mention is used when compiling from the source. You do not need to do this. Download the -Max .RPMs for your 3.23.xx version, and install those (keep the normal RPM you have already installed). This will set up a binary with InnoDB support, and fix up the startup scripts so that binary will be the one started. Regards, Arjen. -- Get MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: InnoDB help !!
thanks for reply, but I have installed MySQL on Linux using the RPM files and while using RPM files should I have to give the option while installing? As while using the RPM files there is no compilation. It is no where mentioned in the manual with the RPM files. can you please, help me out in details. Thanks and regards, Chetan Lavti -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 10:08 AM To: Chetan Lavti; [EMAIL PROTECTED] Subject: RE: InnoDB help !! You can only do this while compiling it from source. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Chetan Lavti [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 9:11 PM To: [EMAIL PROTECTED] Subject: InnoDB help !! hi, I have downloaded and installed MySQL ( rpm's). Now, I want to configure it with InnoDB option, as given in the manual, but can't see the below configure file anywhere. // cd /path/to/source/of/mysql-3.23.37 ./configure --with-innodb can anybody help me about this.. 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 this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB help !!
hi, I have downloaded and installed MySQL ( rpm's). Now, I want to configure it with InnoDB option, as given in the manual, but can't see the below configure file anywhere. // cd /path/to/source/of/mysql-3.23.37 ./configure --with-innodb can anybody help me about this.. 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 this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
about the stable version of MySQL-Max-3.23
hi, I am wanting to use MySQL with InnoDB support and it is available with the extended version of MySQL (i.e. Max) or unstable version of MySQL-4.0. As, the stability of version MySQL-Max-3.23 was to declare by Innobase Oy in January 2002, I don't no whether it has been declared stable or not. I 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 (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help needed !!!
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 PROTECTED] Subject: Re: Help needed !!! On Fri, Jan 25, 2002 at 01:05:12PM +0530, Chetan Lavti wrote: > > I am going to use the MySQL version 3.23.47 for as our database. > The issue is which table type to use. > > I want that the database should be (memory-resident). I have tried > with the MyISAM tables which doesn't solves my purpose as in this > case the data are stored in the files. Right. > I have also tried with the HEAP tables that uses a hashed index and > are stored in memory. This makes them very fast, but if MySQL > crashes I am loosing all data stored in that. As, I have created one > table as a heap type but when I make my server down and start it > again all rows created nowhere exists. Correct. It sounds like you might want to look at InnoDB tables. They are disk based, but the InnoDB table handler can use a significant amount of RAM (if you allow it to) to cache index *and* record data. MyISAM only caches index data in memory. The InnoDB buffer pool is where this cached data is stored. > So, if anybody can suggest me any process by which I can populated > HEAP table(es) from a duplicate table(es) (which is on secondary > storage) at the time of startup. Also, any runtime modifications in > the tables will need to be updated in both the tables (one in memory > and another one on disk). If any other method by which I can > achieve the same. There was talk last year of implementing a hybrid HEAP/MyISAM table type (originally motived by the DBA at Slashdot). Upon startup, the MyISAM table would be loaded into a RAM-based HEAP-table. Any changes to the HEAP table would get written to the underlying MyISAM table as well. Read-only queries, of course, would be run against the RAM-based HEAP table. I suspect that will never be implemented, since InnoDB and it's buffer pool go a long way toward solving the same problem. Hope that helps, Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 22 days, processed 513,100,530 queries (265/sec. avg) - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help needed !!!
hi, I am going to use the MySQL version 3.23.47 for as our database. The issue is which table type to use. I want that the database should be (memory-resident). I have tried with the MyISAM tables which doesn't solves my purpose as in this case the data are stored in the files. I have also tried with the HEAP tables that uses a hashed index and are stored in memory. This makes them very fast, but if MySQL crashes I am loosing all data stored in that. As, I have created one table as a heap type but when I make my server down and start it again all rows created nowhere exists. So, if anybody can suggest me any process by which I can populated HEAP table(es) from a duplicate table(es) (which is on secondary storage) at the time of startup. Also, any runtime modifications in the tables will need to be updated in both the tables (one in memory and another one on disk). If any other method 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 this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: regarding the MySQL's server Caching feature
thanks again , yes, I have seen that but isn't it MySQL's default feature.. I will explore it more and talk to you for further queries.. Thanks and regards, Chetan -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:58 PM To: Chetan 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 by a lookup server(something like a dns server). The > database lookup delay can become a bottleneck in the performance of > the server. Do you know of any techniques used to speedup frequent > database lookups for databases which are mostly static in nature. Ah, sure. Have a look at HEAP tables in the MySQL manual. They sould like just what you need. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 19 days, processed 441,748,474 queries (264/sec. avg) - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: regarding the MySQL's server Caching feature
Thanks for the quick reply. I need some further inputs from you. 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 by a lookup server(something like a dns server). The database lookup delay can become a bottleneck in the performance of the server. Do you know of any techniques used to speedup frequent database lookups for databases which are mostly static in nature. thanks and regards, Chetan -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:41 PM To: Chetan Lavti Cc: [EMAIL PROTECTED] Subject: Re: regarding the MySQL's server Chaching feature On Tue, Jan 22, 2002 at 12:30:56PM +0530, Chetan Lavti wrote: > > 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 this is implemented in the version 4.0 > ?how to configure this ? It sounds like you're referring to the new Query Cache. If so, no. That's in verison 4.0 only. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 19 days, processed 440,853,176 queries (264/sec. avg) - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
regarding the MySQL's server Chaching feature
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 this is implemented in the version 4.0 ?how to configure this ? Please, give me detail, as much as possible. Thanks and regards, Chetan - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
