Reg my.cnf entry
Hello mysql, Just let me know whether we can create seperate binary files for seperate DBs used. And how to.. also Thanx Regards, Charitha -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Reg my.cnf entry
Hello mysql, Just let me know whether we can create seperate binary files for seperate DBs used. And how to.. also Thanx Regards, Charitha -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Reg: Myisamchk
Hello all, In mysql tables if i want to exclude some tables to do myisamchk how can i do that. As if i use myisamchk *.MYI it is taking too much time to check all the tables. For that i can exclude some previous days dynamic tables and i can execute this How to do that??? Thanx in advance. -- Regards, Charitha - 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
Reg. Transaction support
Hello All, I would like to know the some details regarding the transaction support in Mysql Version 4. May i know where can i find the related stuffs. Thanx in advance -- You feel a whole lot more like you do now than you did when you used to. Regards, Charitha - 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
Reg: InnoDB
Hello All, I would like to know whether MySQL-Max or MySQL 4 with InnoDB is freely available or InnoDB is available in free of cost and where can I download it Regards, Charitha - 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
usage of mysql command
Hello all, How to use mysql command in perl script? I want to lock the db thru a perl(or shell)script. Thanx in advance. -- Charitha - 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
usage of mysql command
Actually i want to lock a db in mysql with the flush command should i go thru CPAN for that purpose or i can do it with a single command like mysql -u -p DBNAME --execute flush tables with read only i have tried this but it is not working for me that is why i put that mail Is there anyone to correct this??? thank you. On Mon, 22 Jul 2002, Barnali wrote: download mysql module of perl from cpan.org. Barnali -Original Message- From: Charitha [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 12:08 PM To: [EMAIL PROTECTED] Subject: usage of mysql command Hello all, How to use mysql command in perl script? I want to lock the db thru a perl(or shell)script. Thanx in advance. -- Charitha - 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 -- People don't usually make the same mistake twice -- they make it three times, four time, five times... Regards, Charitha - 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
Restoring DB
Hello all, Is there any way in mysql to restore the data back after flushing off all the data already present using a single command. I am having backup of the db and i want to restore the data back in the database by flushing off all the data already present. Thanx in advance Regards, Charitha - 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 db - rsync
Hello all, Can i do rsync with the mysql db as a whole from one machine to other. If i can do then will there be any loss of data while doing rsync. Thanks in advance. -- Regards, Charitha - 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
Remote entry
Hello all, Yeah i have worked with this replication to the core but i faced some minor problem with that as i have to do it in two way hence i dropped that idea and hunting for some other way to do that so i put those words like remote entry any way thanks a lot for your response - Actually i am doing some work related to redundancy so i am having two machines and at a time one is active and another is passive so when the active state the mysql will be keep on updating and the other passive server will be continuously updating its mysql with the active server at some time when the active server goes down that related entry will be not sent to the remote i do it as two-way replication for that i am facing some problem hope u r getting me thanx Charitha, Friday, July 12, 2002, 7:49:03 AM, you wrote: C Can i make mysql to put enteries in two different machines C If there is an entry made in mysql in local machine, is there any options C so that the same entry is made in the remote machine mysql db C If there is any option pls. let me know C Thanx in advance If I fully appreciate, you want all changes with data on your local box will be applied with data on your remote box? If so, take a look at replication: http://www.mysql.com/doc/R/e/Replication.html -- Regards, Charitha - 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
Remote entry
Hello all, Can i make mysql to put enteries in two different machines If there is an entry made in mysql in local machine, is there any options so that the same entry is made in the remote machine mysql db If there is any option pls. let me know Thanx in advance -- Regards, Charitha - 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 in shared libraries
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
Usage of client-server in mysql
Hello all, How to implement client and server in mysql The actual thing which i need is that. I am having the server and the client in single machine and also having client in some other machine. Can i have the data from the server to the client that is placed in some remote machine with out server in that. -- Regards, Charitha - 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
Select records from remote machine.
Hello all, In mysql how can i select or execute any command in the remote machine Thanx i advance. -- Regards, Charitha. - 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
Select records from remote machine.
Hello all, In mysql how can i select or execute any command in the remote machine Thanx i advance. -- Regards, Charitha. - 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
Copying records b/w diff databases.
In mysql i have to copy selected records from one database table to another database table. How to do that? thanx in advance. -- Regards, Charitha - 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.sock missing
Hello all, I am facing very strange problem I am not having mysql.sock in /var/lib/mysql But it is showing its status to be running. How could it be? Clearance needed. -- Regards, Charitha. - 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.sock missing
The entry in my.cnf file is /var/lib/mysql/mysql.sock only I am having two machines. In one thing it is working fine And in another one i stop it manually and trying to start it through my script It is starting i suppose and the status showing is running but due to the socked file missing i am facing some other problem. How could it be? On Tue, 23 Apr 2002, Me wrote: Heya! Perhaps because its mysqld.sock ? Check your my.cnf file to see how your configuration is configured (what file and what path the socket file is) [mysqld] socket = /var/run/mysqld/mysqld.sock EG Hello all, I am facing very strange problem I am not having mysql.sock in /var/lib/mysql But it is showing its status to be running. How could it be? Clearance needed. -- Regards, Charitha. - 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, CC - 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
Restoring log file enteries.
Hello all, I am having the mysql log file which is having all the queries which affects the data base. I have to restore those queries in the table in some remote server. Is that possible. Any ideas are welcome. Thanks in advance -- Regards, Charitha - 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 i use rsync instead of Replication
Hello all, Can i use rsync instead of replicating two servers for mysql( particular database db). If yes Then just clear off my doubt whether it will lead to any data loss as while doing rsync. Thanx in advance. Regards, Charitha. C. -- Regards, CC - 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
Replication problem
Hello all, I am trying to replicate the database in two machines with one master and one slave. I was having the my.cnf entry in the master with the following lines: log-bin= /var/lib/mysql/replication1.log server-id=1 It was working very fine until yesterday evening. But suddenly there was an error and i found in the mysqld.log file with the error 020201 16:06:32 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'replication1.log' at position 24655608 020201 16:06:32 Error reading packet from server: Could not find first log (read_errno 0,server_errno=65535) 020201 16:06:32 Slave: Failed reading log event, reconnecting to retry, log 'replication1.log' position 24655608 020201 16:06:32 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'replication1.log' at position 24655608 020201 16:06:32 Error reading packet from server: Could not find first log (read_errno 0,server_errno=65535) I thought that the error was due to the replication file name and i changed the entry in my.cnf file as follows. log-bin= /var/lib/mysql/replication4.log server-id=1 And now it is again started working. Well! I want to know whethere there is some bound that replication could not be continued after that. Please immediate reply is wanted ... Thank you one and all. -- 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
Regarding mysql.sock file
Hello all, I am working with the replication of mysql with selected db. While i was trying to do that suddenly slave machine's mysql.sock file was deleted. So i am not able to enter into mysql. May i know whether there is any other way to get it(mysql.sock) back as i restarted mysql quite ample number of times. Or reinstalling is the only way for getting the file back. Thank you. -- Regards, Charitha. - 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
How to get connected with mysql using perl scripts
Hi all, Please guide me to get the connection with mysql through perl scripts and through the scripts i have to insert some lot of data in the existing tables. Thank you. Regards, Charitha. - 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 me to create a table with autoincrementing field
Hi all there, I am a fresher to mysql. I want to know how to create a table with an autoincrement field in that along with a name field with the varchar datatype. Thank you. Regards, Charitha. - 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
Replication of selected DB
Hi, It is said that if the connection is lost then there will be an entry of the .err file. But nothing of that sort is happening here. Connection is not lost, and replication is also not taking place. Can any one help to get the solution. On Tue, 29 Jan 2002, Jai Kumar Shinde wrote: Hi, Check the error, not in mysqld.log ..its in hostname.err Jai -Original Message- From: Charitha [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 9:52 AM To: Girish Nath Cc: [EMAIL PROTECTED] Subject: Replication of selected DB Hi, I have to replicate the selected Database. I have followed all the steps given in the manual page. But i am not getting the result as i need. There is no error message in the mysqld.log. The message in the log file is replication is started. But the replication is not happening. Can you help me to solve this. Thank you. - 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
Replication of selected DB
Hi, I got the solution for the replication of the selected db. I typed only the database name in the replicate-do-db column. And this line is followed by the data dir line. Hope it is taking the path starting from the data dir column itself. Thanks a lot for your response for this mail. Regards, Charitha. On Tue, 29 Jan 2002, Jai Kumar Shinde wrote: Hi, Check the error, not in mysqld.log ..its in hostname.err Jai -Original Message- From: Charitha [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 9:52 AM To: Girish Nath Cc: [EMAIL PROTECTED] Subject: Replication of selected DB Hi, I have to replicate the selected Database. I have followed all the steps given in the manual page. But i am not getting the result as i need. There is no error message in the mysqld.log. The message in the log file is replication is started. But the replication is not happening. Can you help me to solve this. Thank you. - 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
Largest datatype
Hi all, I want to know data type which will have a size greater than or equal to 10kb in mysql. Just anybody response to this mail and let me know. Thank u. - 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: Largest datatype
I am not getting the requirement fulfilled from that manual page. I want some other data type as one of the field and with that i have to check the replication in two servers. that data type should have large size about 10kb. Is there any data type like that. Please let me know and its usage also. Actually i want to check the performance of replication. On Tue, 29 Jan 2002, Paul DuBois wrote: At 9:48 +0530 1/30/02, Charitha wrote: Hi all, I want to know data type which will have a size greater than or equal to 10kb in mysql. Just anybody response to this mail and let me know. You can check this for yourself in the MySQL manual: http://www.mysql.com/doc/S/t/Storage_requirements.html More than one type fits the bill, so you'll need to decide for yourself which you prefer. Thank u. - 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
Replication of selected DB
Hi, I have to replicate the selected Database. I have followed all the steps given in the manual page. But i am not getting the result as i need. There is no error message in the mysqld.log. The message in the log file is replication is started. But the replication is not happening. Can you help me to solve this. Thank you. - 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