Re: A tool
Hi Krishna Chandra Prajapati, How can i customize, to make it work on debian OS After months of search finally yesterday i got debian - Lastnight i tested giis binary with debian -- yes running binary version gave me an Error as Floating Exception Then i tried to compile it from source it worked well.Please refer INSTALL file on how to compile from source (it has only 5 steps) I will fix this giis binary issue - till then debian user can try it from source. Anyway debian looks cool. :) Cheers, Lakshmipathi.G On Wed, Nov 19, 2008 at 11:48 AM, Krishna Chandra Prajapati prajapat...@gmail.com wrote: Thanks, I will be waiting for your reply. On Wed, Nov 19, 2008 at 10:22 AM, lakshmi pathi lakshmipath...@gmail.com wrote: Thanks for your comments :) How can i customize, to make it work on debian OS. It should work for all ext3 Linux distros giis tested with Fedroa ,Redhat and Ubuntu ... I haven't tried it with debianso right now,i don't how to customize it for debian...I'll try and check with debian and let you know in few days time. Cheers, Lakshmipathi.G On Tue, Nov 18, 2008 at 1:55 PM, Krishna Chandra Prajapati prajapat...@gmail.com wrote: Hi, It's a nice tool. Working for fedora. But not for debian. How can i customize, to make it work on debian OS. On Mon, Nov 17, 2008 at 12:25 PM, lakshmi pathi lakshmipath...@gmail.com wrote: Hi all, If you are using mysql in linux with ext3 file system,then this might help. I have written a undelete tool. [Short functionality is ,once installed files can be recovered using the tool but files deleted before installation can't be recovered. It acts as a fail-safe.] I tried it with mysql,for screenshots check here, http://www.giis.co.in/giis_mysql_screenshots.html You can download it from http://sourceforge.net/projects/giis or from here www.giis.co.in I have recovered only tables and not yet started with complete databases, based on your comments i hope to decided on futher enhancements. (If you have already such functionality available ,please let me know - as there is no point in reinventing the wheel :) ) (ps:I posted the similar message few days back on the forum ..but didn't received any comments/info..so i'm here :) ) Cheers, Lakshmipathi.G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com -- Krishna Chandra Prajapati MySQL DBA, Mob: 9912924044 Email-id: prajapat...@gmail.com -- Cheers, Lakshmipathi.G -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Mob: 9912924044 Email-id: prajapat...@gmail.com -- Cheers, Lakshmipathi.G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: A tool
Thanks for your comments :) How can i customize, to make it work on debian OS. It should work for all ext3 Linux distros giis tested with Fedroa ,Redhat and Ubuntu ... I haven't tried it with debianso right now,i don't how to customize it for debian...I'll try and check with debian and let you know in few days time. Cheers, Lakshmipathi.G On Tue, Nov 18, 2008 at 1:55 PM, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi, It's a nice tool. Working for fedora. But not for debian. How can i customize, to make it work on debian OS. On Mon, Nov 17, 2008 at 12:25 PM, lakshmi pathi [EMAIL PROTECTED] wrote: Hi all, If you are using mysql in linux with ext3 file system,then this might help. I have written a undelete tool. [Short functionality is ,once installed files can be recovered using the tool but files deleted before installation can't be recovered. It acts as a fail-safe.] I tried it with mysql,for screenshots check here, http://www.giis.co.in/giis_mysql_screenshots.html You can download it from http://sourceforge.net/projects/giis or from here www.giis.co.in I have recovered only tables and not yet started with complete databases, based on your comments i hope to decided on futher enhancements. (If you have already such functionality available ,please let me know - as there is no point in reinventing the wheel :) ) (ps:I posted the similar message few days back on the forum ..but didn't received any comments/info..so i'm here :) ) Cheers, Lakshmipathi.G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Krishna Chandra Prajapati MySQL DBA, Mob: 9912924044 Email-id: [EMAIL PROTECTED] -- Cheers, Lakshmipathi.G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A tool
Hi all, If you are using mysql in linux with ext3 file system,then this might help. I have written a undelete tool. [Short functionality is ,once installed files can be recovered using the tool but files deleted before installation can't be recovered. It acts as a fail-safe.] I tried it with mysql,for screenshots check here, http://www.giis.co.in/giis_mysql_screenshots.html You can download it from http://sourceforge.net/projects/giis or from here www.giis.co.in I have recovered only tables and not yet started with complete databases, based on your comments i hope to decided on futher enhancements. (If you have already such functionality available ,please let me know - as there is no point in reinventing the wheel :) ) (ps:I posted the similar message few days back on the forum ..but didn't received any comments/info..so i'm here :) ) Cheers, Lakshmipathi.G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Strange table problem
I dont think product_beta.test is a table...It seems to be a view.. what is the create statement for it.. show create table product_beta.test; ??? -Lakshmi Ruan wrote: Hi everybody, I have a very strange table problem - a table was created in one of our databases, but I can't seem to drop it. I tried with phpmyadmin and with mysql from command-line. If I try to view it I receive this error: View 'product_beta.test' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them And when I try to repair it: | product_beta.test | repair | error| 'product_beta.test' is not BASE TABLE | I am logged in as root so I don't think it is a rights problem. Any ideas on how to get rid of it? Regards Ruan Fourie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
myisam primary key with innodb primary key..
Hi, I want to know is there any difference between myisam primary index vs innodb primary index... -- Regards, Lakshmi.M.P. DBA Support Sify Limited. Extn:4134 ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Watch the latest updates on Mumbai, with video coverage of news, events, Bollywood, live darshan from Siddhivinayak temple and more, only on www.mumbailive.in Watch the hottest videos from Bollywood, Fashion, News and more only on www.sifymax.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: *****SPAM***** Re: Aborted clients status variable seems increasing -how to tune the server to reduce the same
Thanks Brent. I increased my wait_timeout.But now also my aborted clients seems increasing than connections.As u said most of my front end code use mysql persistent connect only.Can u clarify my one more doubt that when to use persistent connect and when to use mysql_connect and their advantages and disadvantages. Now my connections is 1509317 and my aborted clients is 1747365.Is it a problem?Please let me know. -Lakshmi.M.P. Brent Baisley wrote: You have your wait_timeout set to 5 seconds. Which means a client connection will be aborted after 5 seconds of inactivity. Since your aborted connects is 0, you don't seem to having a problem connecting, just staying connected. 5 seconds is kind of low (default is 28800 I think), but is fine if you have a reason for setting it so low. Your threads_created number is fairly low, so you're not having a problem of constantly creating threads to handle connections, which can really hurt. I don't know what your front end is written in. But you may want to increase the wait_timeout or call mysql_close when you are done with your database connection. I'm guessing that since your aborted clients number is higher than the number of connections, you're using persistant connections. Which means connections are reused if still available. - Original Message - From: Lakshmi [EMAIL PROTECTED] To: mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Sent: Thursday, June 15, 2006 3:42 AM Subject: Aborted clients status variable seems increasing -how to tune the server to reduce the same Hi, The aborted clients seems to be increasing than the connections made. Any solution Aborted_clients 67529 where as the connection made is 60462 . Here is my server details, Server : Red Hat Enterprise Linux AS release 4 (Nahant) Mysql Server version : 4.1.15-log *my.cnf variables:* key_buffer=350M max_allowed_packet=32M table_cache=1024 thread_cache_size=400 sort_buffer=64K net_buffer_length=64K read_buffer_size = 64K thread_stack=96K query_cache_size=64M max_connections=1000 max_connect_errors=100 max_user_connections=900 wait_timeout=5 record_buffer=5M thread_concurrency=8 myisam_sort_buffer_size=64M set-variable = innodb_buffer_pool_size=200M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 *Status Variables: *Aborted_clients 67529 Aborted_connects0 Connections 60462 Key_blocks_unused 275836 Key_blocks_used 42002 Key_read_requests 1836872 Key_reads 42002 Key_write_requests 3704 Key_writes 3701 Max_used_connections205 Open_tables 84 Opened_tables 90 Qcache_free_blocks 4451 Qcache_free_memory 54838840 Qcache_hits 18034 Qcache_inserts 66383 Qcache_lowmem_prunes0 Qcache_not_cached 11320 Qcache_queries_in_cache 11792 Questions 269605 Threads_cached 81 Threads_connected 124 Threads_created 205 Threads_running 4* -Lakshmi.M.P. MYSQL DBA, Sify Limited. ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. www.sifymax.com Get to see what's happening in your favourite City on Bangalore Live! www.bangalorelive.in -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Aborted clients status variable seems increasing -how to tune the server to reduce the same
Hi, The aborted clients seems to be increasing than the connections made. Any solution Aborted_clients 67529 where as the connection made is 60462 . Here is my server details, Server : Red Hat Enterprise Linux AS release 4 (Nahant) Mysql Server version : 4.1.15-log *my.cnf variables:* key_buffer=350M max_allowed_packet=32M table_cache=1024 thread_cache_size=400 sort_buffer=64K net_buffer_length=64K read_buffer_size = 64K thread_stack=96K query_cache_size=64M max_connections=1000 max_connect_errors=100 max_user_connections=900 wait_timeout=5 record_buffer=5M thread_concurrency=8 myisam_sort_buffer_size=64M set-variable = innodb_buffer_pool_size=200M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 *Status Variables: *Aborted_clients 67529 Aborted_connects0 Connections 60462 Key_blocks_unused 275836 Key_blocks_used 42002 Key_read_requests 1836872 Key_reads 42002 Key_write_requests 3704 Key_writes 3701 Max_used_connections205 Open_tables 84 Opened_tables 90 Qcache_free_blocks 4451 Qcache_free_memory 54838840 Qcache_hits 18034 Qcache_inserts 66383 Qcache_lowmem_prunes0 Qcache_not_cached 11320 Qcache_queries_in_cache 11792 Questions 269605 Threads_cached 81 Threads_connected 124 Threads_created 205 Threads_running 4* -Lakshmi.M.P. MYSQL DBA, Sify Limited. ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. www.sifymax.com Get to see what's happening in your favourite City on Bangalore Live! www.bangalorelive.in -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Reading Date from a csv file
I am new to mySQL. I am trying to import data from a csv file, using the following code LOAD DATA LOCAL INFILE 'D:/foldername/file1.csv' INTO TABLE database_name.tbl_name FIELDS TERMINATED BY ',' ( field1, field6_date, field9 ); The data is getting imported, but the dates are wrong. In the original data file the dates are mm/dd/yy format. How do I specify the date formats, in the code? Thanks in advance for any help, Lakshmi
Error 46
To install MySQL :: I downloaded mysql-3.23.39-hp-hpux11.00-hppa2.0w.tar.gz. I did unzip, I have changed $MYSQL path from mysql-3.23.39-hp-hpux11.00-hppa2.0w/bin/mysqlaccess file. I ran scripts/mysql_install_db command I started database using bin/safe_mysqld Then I got the below output : --- [2] 27887 [sechp1 256%]Starting mysqld daemon with databases from /nfs/acadia/home/lm/mysql/mysql-3.23.39-hp-hpux11.00-hppa2.0w/data Pid 27894 killed due to text modification or page I/O error 010625 14:37:50 mysqld ended - In error log file I found the following -- 010625 14:44:08 mysqld started 010625 14:44:08 /nfs/acadia/home/lm/mysql/mysql-3.23.39-hp-hpux11.00-hppa2.0w/bin/mysqld: Can't lock file (errno: 46) 010625 14:44:08 /nfs/acadia/home/lm/mysql/mysql-3.23.39-hp-hpux11.00-hppa2.0w/bin/mysqld: Normal shutdown 010625 14:44:08 mysqld ended --- Would anyone please tell me what this error 46 is? - 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
hi
Hai, i gone thro u'r mysql documentation. but they haven't mentioned clearly. it's really big headache for users. using c language i want to connect to datadase and perform some queries(select,update,insert and delete).according to u'r documentation u said that first use mysql_int() and mysql_real_connect method to connect to the database in which library files these buildin functions are defined. this is my c file #includestdio.h #includestring.h #includestdlib.h #include/usr/local/mysql/include/mysql.h #include/usr/local/mysql/include/my_net.h #include/usr/local/mysql/include/mysqld_error.h #include/usr/local/mysql/include/mysys_err.h main() { MYSQL mysql; mysql_init(mysql); mysql_options(mysql,MYSQL_OPT_COMPRESS,0); mysql_options(mysql,MYSQL_READ_DEFAULT_GROUP,odbc); if (!mysql_real_connect(mysql,localhost,user=root,,InControl,0,NULL,0)) { printf(stderr,Failed to connect to database: Error: %s\n,mysql_error(mysql)); } } mysql_init() and mysql_real_connect() are build in functions. in which library files they defined this functions. pls mail me in detail Regards Lakshmi
Problem in running mysql
Hi ! I have some problem in running bin/mysql.when i run this it is not responding. when i run with timeout option it says connection with server is lost. mysqld is running . There is a warning in the host.err file which says that One can only use the --user switch if running as root.And it says ready for connections. Pls throw some light on this problem. l.kumar This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. Visit us at http://www.cognizant.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