Replication in MySQL of InnoDb Tables
Hello, when setting up replication in MySQL, do we need to take the tar of the data dir. of the master and save it onto the slave.or when the slave comes up for the first time, it automatically loads the specified databases and tables from the master.??? And for InnoDB tables, we convert the Tables to MyIsam and then after loading, back to InnoDB but then wot abt the tables in slave...??? are they converted to InnoDB automatically using binlog or have to be done manually giving appropriate commands??? Thanx in advance, Ritu Singla - 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
mysqld --flush
Hello, Starting mysqld with --flush, flushes tables to database or disk log?? Thanx in advance, Ritu Singla sql,query - 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: Error in shared libraries
Hi, try including this path i.e. /usr/lib/mysql/ in LD_LIBRARY_PATH in .cshrc file...i guess, it'll do... Ritu On Fri, 7 Jun 2002, Charitha wrote: Hello all, I am having one application in which i am using mysql as database. When i run my application it gives following error. error:loading shared libraries libmysqlclient.so.10 (No such file or directory) I am having that library in /usr/lib/mysql/ Still it gives this error.Why is it so..? How to solve this problem? Thanks and regards, Charitha C. -- - 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
mysqld --flush
Hello, (i had already posted this ques, got a reply but that character format was unreadable..so i'm sorry for posting it again..) Starting mysqld with --flush, flushes tables to database or disk log?? Pls. help!! Thanx in advance, Ritu Singla sql,query Everything you always wanted to know about cars and bikes,now at: http://in.autos.yahoo.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: processlist
Hi, Is this mysqld.log file created automatically or we need to do some settings in my.cnf to enable this logging of mysqld? Thanx in advance.. Ritu On Wed, 5 Jun 2002, Eivind A. Sivertsen wrote: You can also tail -f the logfile of mysqld... tail -f /var/log/mysqld.log ...or something like that... Eivind sql, query - 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: innodb_flush_log_at_trx_commit
Jeremy, do we have the control as to WHEN to update the actual tables??? Thanx.. Ritu Singla --- Jeremy Zawodny [EMAIL PROTECTED] wrote: On Mon, Jun 03, 2002 at 07:07:29AM +0100, ritu singla wrote: Hello, in InnoDB tables in MySQL, if innodb_flush_log_at_trx_commit is set to 1, then on COMMIT, the buffer log is flushed to disk log... Right. or the changes are reflected in the disk copy of the database??? i mean what is flushed, the buffer-pool that contains data and indexes or the log-buffer?? Log buffer. Once the transaction is in the on-disk log, it's durable. InnoDB can choose to update the actual tables later. 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.51: up 4 days, processed 97,368,631 queries (264/sec. avg) Everything you always wanted to know about cars and bikes,now at: http://in.autos.yahoo.com/cricket/tracker.html - 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_flush_log_at_trx_commit
Hello, in InnoDB tables in MySQL, if innodb_flush_log_at_trx_commit is set to 1, then on COMMIT, the buffer log is flushed to disk log...or the changes are reflected in the disk copy of the database??? i mean what is flushed, the buffer-pool that contains data and indexes or the log-buffer?? Thanx in advance, Ritu Everything you always wanted to know about cars and bikes,now at: http://in.autos.yahoo.com/cricket/tracker.html - 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
Index on unique/primary key
Hello! specifying a column as unique or primary in MySQL creates indices automatically or do we need to do it explicitly using INDEX(unique/primary_colname) in CREATE TABLE command of MySQL?? Thanx in advance.. Ritu Singla Everything you always wanted to know about cars and bikes,now at: http://in.autos.yahoo.com/cricket/tracker.html Everything you always wanted to know about cars and bikes,now at: http://in.autos.yahoo.com/cricket/tracker.html - 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: How see InnoDB messages at startup mysql server?
u can see the InnoDB messages in 'hostname.err' file in the data dir. On Wed, 29 May 2002, Iago Sineiro wrote: Hi all. Anybody knows how to see innodb messages at startup or shutdown of mysql server? Is there any log of messages? Thanks in advance. Iago. - 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: Log Files in InnoDB
Hello, i could not understand what is the content of log files in InnoDB in MySQL...is it the log of the database,i mean, the data, or the transaction log?? Thanx in advance.. Ritu Singla Everything you always wanted to know about cars and bikes,now at: http://in.autos.yahoo.com/cricket/tracker.html Everything you always wanted to know about cars and bikes,now at: http://in.autos.yahoo.com/cricket/tracker.html - 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
mysqld-max ver 3.23.49
Hello, i'm running mysqld-max ver 3.23.49. When i see the process status (ps), there are 10 processes running of mysqld. is this fine or something wrong??? Thanks! Ritu Singla Everything you always wanted to know about cars and bikes,now at: http://in.autos.yahoo.com/cricket/tracker.html - 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
Binary Installation of mysql-max
hello, i'm trying to install mysql-max...using binaryver 3.23.49 i change the [mysqld] options in /etc/my.cnf as foollows to enable InnoDB table options:: innodb_data_file_path innodb_data_home_dir but after changing the options, mysqld starts but ends immediately... Pls. let me know the reason and also how to install mysql-max to use InnoDB.. Thanks Ritu - 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 database files
they r the binary log files... Ritu On Tue, 14 May 2002, Augey Mikus wrote: what are the host-bin.001 002 003 etc.. files in the mysql_dir/var directory? On my system they range in size from bytes to gigs. What are they and can they be cleaned? Augey - 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: Can't RESTORE TABLE...
i'm using Mysql ver. 3.23.49... Ritu On Fri, 10 May 2002, Jeremy Zawodny wrote: On Fri, May 10, 2002 at 10:12:15AM +0100, ritu singla wrote: Hi!! I used BACKUP TABLE command to take the backup of a table...but when i say RESTORE TABLE, i get the following :: mysql restore table rs from '/tmp'; +---+-+--+--+ | Table | Op | Msg_type | Msg_text | +---+-+--+--+ | rs| restore | error| Failed copying .frm file | +---+-+--+--+ 1 row in set (0.00 sec) The output after BACKUP TABLE was :: mysql backup table abc to '/tmp'; +--++--+--+ | Table| Op | Msg_type | Msg_text | +--++--+--+ | ritu.abc | backup | status | OK | +--++--+--+ 1 row in set (0.00 sec) Pls. tell me where i went wrongi locked the table before backup... What version of MySQL are you using? I've reproduced the bug in 3.23.47, but found that it works just fine in 4.0.2. You might check the change logs to see if it was fixed in a release after the one you're using. 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 92 days, processed 2,398,838,413 queries (301/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 - 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: Can't RESTORE TABLE...
i'm taking the backup of PERSON table in /tmp dirafter the backup PERSON.frm and PERSON.MYD are present in /tmp...but when i try to restore them with the name RS, the error comes up Ritu On Mon, 13 May 2002, Victoria Reznichenko wrote: ritu, Friday, May 10, 2002, 12:12:15 PM, you wrote: rs I used BACKUP TABLE command to take the backup of a rs table...but when i say rs RESTORE TABLE, i get the following :: rs mysql restore table rs from '/tmp'; rs +---+-+--+--+ rs | Table | Op | Msg_type | Msg_text rs | rs +---+-+--+--+ rs | rs| restore | error| Failed copying .frm rs file | rs +---+-+--+--+ rs 1 row in set (0.00 sec) Do you have rs.* files in /tmp dir? rs Thanks... rs Regards, rs Ritu Singla -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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 - 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
O2 to MySQL.....
Hi!! I want to convert all the data in o2 database to mysql...pls. can anyone guide me on that?? Thanx... Regards, Ritu Singla For live cricket scores download Yahoo! Score Tracker at: http://in.sports.yahoo.com/cricket/tracker.html - 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
Can't RESTORE TABLE...
Hi!! I used BACKUP TABLE command to take the backup of a table...but when i say RESTORE TABLE, i get the following :: mysql restore table rs from '/tmp'; +---+-+--+--+ | Table | Op | Msg_type | Msg_text | +---+-+--+--+ | rs| restore | error| Failed copying .frm file | +---+-+--+--+ 1 row in set (0.00 sec) The output after BACKUP TABLE was :: mysql backup table abc to '/tmp'; +--++--+--+ | Table| Op | Msg_type | Msg_text | +--++--+--+ | ritu.abc | backup | status | OK | +--++--+--+ 1 row in set (0.00 sec) Pls. tell me where i went wrongi locked the table before backup... Thanks... Regards, Ritu Singla For live cricket scores download Yahoo! Score Tracker at: http://in.sports.yahoo.com/cricket/tracker.html - 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
Can't RESTORE...
Hi!! I used BACKUP TABLE command to take the backup of a table...but when i say RESTORE TABLE, i get the following :: mysql restore table rs from '/tmp'; +---+-+--+--+ | Table | Op | Msg_type | Msg_text | +---+-+--+--+ | rs| restore | error| Failed copying .frm file | +---+-+--+--+ 1 row in set (0.00 sec) The output after BACKUP TABLE was :: mysql backup table abc to '/tmp'; +--++--+--+ | Table| Op | Msg_type | Msg_text | +--++--+--+ | ritu.abc | backup | status | OK | +--++--+--+ 1 row in set (0.00 sec) Pls. tell me where i went wrongi locked the table before backup... Thanks... Regards, Ritu - 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: compiler mes examples
Hi!! try this :: gcc -I/usr/local/mysql/include custom1.cc -I is used to specify the path of include files Regards, Ritu On Mon, 29 Apr 2002, adelpfe wrote: hi every body i have installed mysql++ for linux. when i try to compile examples , i get this message: gcc custom1.cc i obtain ... /usr/local/include/mysql.h :no file or directory with this name. should i put some option or what?? help me please - 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
In fact, i'm trying to read data from a binary file and want to insert that into the database. I guess, it would be easier and more efficient if i use some data structure like we have vectors in C++ API. Thanks, Ritu Singla On Thu, 18 Apr 2002, Robert Cross wrote: you wrote: I want to know if there is any datatype in MySQL C API which is similar to a structure in C??? Why? The purpose of the API is to permit use of MySQL as a backend or datasource for user-written programs. That said, if your table consists of columns of differing types, then any the results of any query will be similar to a C struct. In which case the mysql_row type is probably the closest. The easiest answer is to refer to section 8.4.1 of the manual at http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#C_API_datatypes (amongst others) Hope this helps. Robert Cross. - 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
C API
Hi!! I want to know if there is any datatype in MySQL C API which is similar to a structure in C??? Thanks, Ritu Singla - 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
Question
Hello, i read the MySQL Reference Manual for version 3.23.49. I tried some C API's, but was stuck up when trying to insert data from a file into the MySQL database. Please help me out as i could not find any material on FILE HANDLING in MySQL C API. Looking forward to read from your side as early as possible... Thanking You in anticipation... Ritu Singla Research Engineer, C-DOT, New Delhi. - 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
Query regarding FILE HANDLING
Hello, I read the MySQL Reference Manual for version 3.23.49. I tried some C API's, but was stuck up trying to insert data from a file into the MySQL database. Please help me out as i could not find any material on FILE HANDLING in MySQL C API. Thanking You in anticipation... Ritu Singla Research Engineer, C-DOT, New Delhi __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.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