Re: mysqld refuse to die
On Sat, 9 Nov 2002, Jack Chen wrote: I have just figured out: kill -9 xxx (process number) Hi! Did you try just 'kill xxx'? How about 'mysqladmin shutdown'? 'kill -9' is an extremely cruel way to bring a server down. You may get corrupted databases that way, although sometimes it's the only option. Regards, Iikka On Sat, 9 Nov 2002, Jack Chen wrote: Hi All, Please help me with this problem: For some reason, I could not bring down my mysqld by running mysqld stop An error message indicate: fail What's going on? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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
wait_timeout
Greeting to all. Here is some data on my server : [student:99] /usr/local/bin mysqladmin -u root -p version 9:18 Enter password: *** mysqladmin Ver 8.23 Distrib 3.23.52, for hp-hpux11.00 on hppa2.0w Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.52-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /student1/mysql/mysql.sock Uptime: 6 min 31 sec Threads: 1 Questions: 8 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1 Queries per second avg: 0.020 [student:100] /usr/local/bin 9:18 I am writing a unix deamon for email processing that uses this mysql server. I got a MySQL error: MySQL server has gone away error. I figured the reason was that my connection timed out. This was because my deamon opens the connections it needs at startup and uses them throughout its lifetime, thus causing gone away error. I saw 2 fixes for this. 1. Increasing wait_timeout value. How should i do this so that it is set to the new value every time i start the server? 2. Opening and closing a mysql connection each time I need to execute a query. Is this a good way to do things, or should I prefer the above method? One more question. I moved mysql.sock file from /tmp to protect it from beeing deleted by admins when system is cleanedup. It is now located in /student1/mysql/ directory. I changed all relevant paths in /etc/my.cnf file but still when I issue `mysql` on the command line it complaints about beeing unable to find /tmp/mysql.sock, only mysql --socket=/student1/mysql/mysql.sock works. Why? Here is my.cnf : # Example mysql config file for medium systems. # # This is for a system with little memory (32M - 64M) where MySQL plays # a important part and systems up to 128M very MySQL is used together with # other programs (like a web server) # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql/var) or # ~/.my.cnf to set user-specific options. # # One can in this file use all long options that the program supports. # If you want to know which options a program support, run the program # with --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port= 3306 socket = /student1/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port= 3306 socket = /student1/mysql/mysql.sock skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= table_cache=64 set-variable= sort_buffer=512K set-variable= net_buffer_length=8K set-variable= myisam_sort_buffer_size=8M log-bin server-id = 1 # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=1 # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /usr/local/mysql/var/ #innodb_data_file_path = ibdata1:10M:autoextend #innodb_log_group_home_dir = /usr/local/mysql/var/ #innodb_log_arch_dir = /usr/local/mysql/var/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high #set-variable = innodb_buffer_pool_size=16M #set-variable = innodb_additional_mem_pool_size=2M # Set .._log_file_size to 25 % of buffer pool size #set-variable = innodb_log_file_size=5M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable= key_buffer=20M set-variable= sort_buffer=20M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=20M set-variable= sort_buffer=20M set-variable= read_buffer=2M set-variable= write_buffer=2M [mysqlhotcopy] interactive-timeout Thank you for any and all help, and I loved mysql so far. Vlatko - 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
ÓÐʱ¼ä¾ÍÀ´¿´¿´°É
b4712.xici.net ÓʼþÄÚÈÝÓëÒÔÏÂÎÄ×ÖÎÞ¹Ø= ÓÅÁªÍøÂç http://www.chinamysql.com רҵÌṩ¸÷ÀàÐéÄâÖ÷»ú£¬²»ÂúÒâ¿É»ñÍË¿î¡£ Ç¿ÊÆÌײͣº100MÖ÷»úËͶ¥¼¶ÓòÃû£¬ËÍ10¸ö10MÆóÒµÓÍÏ䣬¼ÓËÍ20¸ö¶þ¼¶ÓòÃû£¬½öÐè318Ôª/Ä꣡ ÈýÁú֤ȯͶ×Ê http://3long.sayba.com ΪÄúÌṩרҵÀí²Æ·þÎñ¡£ÏÖÔÚ¹ºÂòÖ»Ðè588Ôª£¬ÔùËͼÛÖµ³¬¹ý1800ÔªµÄÀñÆ·£¡ ˵°ÉÍøÉÏÉÌ³Ç http://shop.sayba.com È«Êdz§ÉÌÖ±ÏúµÄÐÂÆ·»òÕÛÉÏÕÛµÄÉÌÆ·£¬ÊÇÄúÍøÂ繺ÎïµÄºÃÈ¥´¦£¡ ʹÓü«ÐÇÓʼþȺ·¢£¬ÎÞÐëͨ¹ýÓʼþ·þÎñÆ÷£¬Ö±´ï¶Ô·½ÓÊÏ䣬ËٶȾø¶ÔÒ»Á÷£¡ Èí¼þÏÂÔØÍøÖ·£ºhttp://www.lovexin.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
SLAVE STOP
On mysql 4,0,4 running under W2K SP3, when I run the command SLAVE STOP; the command it is not execute and it remain pending (the prompt of mysql doesn't return); instead all is normal under 3.53. Which is the problem ? tks regards - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] - 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
I: How to port MS Access to MySQL ??
I use navicat http://www.mysqlstudio.com/. ing. stefano scattini -Messaggio originale- Da: tmb [mailto:topmailbox;yahoo.com] Inviato: venerdì 8 novembre 2002 13.18 A: [EMAIL PROTECTED] Oggetto: How to port MS Access to MySQL ?? Is there a tool for doing a quick port from MS Access to MySQL? Or must you manually create all the tables sql statements in MySQL and then export the MS Access data to a comma delimited file... then import it into MySQL? Thanks for any help - tmb __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - 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 and UPDATE query
Greetings I have problems executing very simple UPDATE query. I do not know whether it is a bug or not, but it works in Access and also works with mySQL, but only from access using linked tables. Query is as followes: UPDATE Table_name SET Field_name = Left(Field_name, 4) 'a' Right(Field_name, 4); This query should change every Field_name's 5'th character to 'a'. One more thing - every record in this table has fixed size value so every value is a string 10 characters long. When using access database or mysql database over access everything goes well, but when using VB and MyODBC or just mysql client, every Field_name's value bocomes 0 (zero). What did I do wrong? Thank you all Bruno Batarelo - 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: mysqld refuse to die
Hi, If you really wish to kill the mysql daemon in this way : You should try : ps -ef |grep mysql ...show all the mysqld processes and after this must enumarate all pid of processes in a single kill command. E.g. kill -9 1024 1056 ...(processes which are open). But it's more health if you can stop the server using : /etc/rc.d/mysqld stop Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jack Chen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 7:57 AM Subject: Re: mysqld refuse to die I have just figured out: kill -9 xxx (process number) Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] On Sat, 9 Nov 2002, Jack Chen wrote: Hi All, Please help me with this problem: For some reason, I could not bring down my mysqld by running mysqld stop An error message indicate: fail What's going on? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] - 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 --- Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus. Xnet automatically scans all messages for viruses using RAV AntiVirus. Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate variantele lor. Va rugam sa luati in considerare ca exista un risc de fiecare data cand deschideti fisiere atasate si ca MobiFon nu este responsabila pentru nici un prejudiciu cauzat de virusi. Disclaimer: RAV AntiVirus may not be able to detect all new viruses and variants. Please be aware that there is a risk involved whenever opening e-mail attachments to your computer and that MobiFon is not responsible for any damages caused by viruses. - 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: mysqld refuse to die
Hi, Why not trying killall -9 mysqld ? Regards, Jocelyn - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 12:08 PM Subject: Re: mysqld refuse to die Hi, If you really wish to kill the mysql daemon in this way : You should try : ps -ef |grep mysql ...show all the mysqld processes and after this must enumarate all pid of processes in a single kill command. E.g. kill -9 1024 1056 ...(processes which are open). But it's more health if you can stop the server using : /etc/rc.d/mysqld stop Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jack Chen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 7:57 AM Subject: Re: mysqld refuse to die I have just figured out: kill -9 xxx (process number) Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] On Sat, 9 Nov 2002, Jack Chen wrote: Hi All, Please help me with this problem: For some reason, I could not bring down my mysqld by running mysqld stop An error message indicate: fail What's going on? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] - 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 --- Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus. Xnet automatically scans all messages for viruses using RAV AntiVirus. Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate variantele lor. Va rugam sa luati in considerare ca exista un risc de fiecare data cand deschideti fisiere atasate si ca MobiFon nu este responsabila pentru nici un prejudiciu cauzat de virusi. Disclaimer: RAV AntiVirus may not be able to detect all new viruses and variants. Please be aware that there is a risk involved whenever opening e-mail attachments to your computer and that MobiFon is not responsible for any damages caused by viruses. - 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: mysqld refuse to die
...because not all mysql processes are named mysql and is one (and you know about this) which is for safe running(mysqld_safe or safe_mysqld) which create new threads when another is killed. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jocelyn Fournier [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED]; Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 2:12 PM Subject: Re: mysqld refuse to die Hi, Why not trying killall -9 mysqld ? Regards, Jocelyn - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 12:08 PM Subject: Re: mysqld refuse to die Hi, If you really wish to kill the mysql daemon in this way : You should try : ps -ef |grep mysql ...show all the mysqld processes and after this must enumarate all pid of processes in a single kill command. E.g. kill -9 1024 1056 ...(processes which are open). But it's more health if you can stop the server using : /etc/rc.d/mysqld stop Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jack Chen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 7:57 AM Subject: Re: mysqld refuse to die I have just figured out: kill -9 xxx (process number) Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] On Sat, 9 Nov 2002, Jack Chen wrote: Hi All, Please help me with this problem: For some reason, I could not bring down my mysqld by running mysqld stop An error message indicate: fail What's going on? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] - 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 --- Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus. Xnet automatically scans all messages for viruses using RAV AntiVirus. Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate variantele lor. Va rugam sa luati in considerare ca exista un risc de fiecare data cand deschideti fisiere atasate si ca MobiFon nu este responsabila pentru nici un prejudiciu cauzat de virusi. Disclaimer: RAV AntiVirus may not be able to detect all new viruses and variants. Please be aware that there is a risk involved whenever opening e-mail attachments to your computer and that MobiFon is not responsible for any damages caused by viruses. - 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: mysqld refuse to die
just kill mysqld_safe and then the mysqld process :) (but AFAIK all the mysql thread are names mysqld ??) - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Jocelyn Fournier [EMAIL PROTECTED]; Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 12:20 PM Subject: Re: mysqld refuse to die ...because not all mysql processes are named mysql and is one (and you know about this) which is for safe running(mysqld_safe or safe_mysqld) which create new threads when another is killed. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jocelyn Fournier [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED]; Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 2:12 PM Subject: Re: mysqld refuse to die Hi, Why not trying killall -9 mysqld ? Regards, Jocelyn - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 12:08 PM Subject: Re: mysqld refuse to die Hi, If you really wish to kill the mysql daemon in this way : You should try : ps -ef |grep mysql ...show all the mysqld processes and after this must enumarate all pid of processes in a single kill command. E.g. kill -9 1024 1056 ...(processes which are open). But it's more health if you can stop the server using : /etc/rc.d/mysqld stop Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jack Chen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 7:57 AM Subject: Re: mysqld refuse to die I have just figured out: kill -9 xxx (process number) Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] On Sat, 9 Nov 2002, Jack Chen wrote: Hi All, Please help me with this problem: For some reason, I could not bring down my mysqld by running mysqld stop An error message indicate: fail What's going on? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] - 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 --- Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus. Xnet automatically scans all messages for viruses using RAV AntiVirus. Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate variantele lor. Va rugam sa luati in considerare ca exista un risc de fiecare data cand deschideti fisiere atasate si ca MobiFon nu este responsabila pentru nici un prejudiciu cauzat de virusi. Disclaimer: RAV AntiVirus may not be able to detect all new viruses and variants. Please be aware that there is a risk involved whenever opening e-mail attachments to your computer and that MobiFon is not responsible for any damages caused by viruses. - 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
escape character
Hi can anybody tell me how can i insert rtf data in my sql, since it
contains escape characters
like this
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0
Verdana;}{\f1\fnil\fcharset2 Webdings;}{\f2\fnil\fcharset0 MS Sans Serif;}}
{\colortbl ;\red0\green0\blue0;\red0\green0\blue255;}
\viewkind4\uc1\pard\cf1\b\f0\fs20 SanjivnullKapila\b0\f1\fs24 4\cf2\f2\fs17
455
\par \pard }
So it deletes the characters \r and \b. Column type is text.
Thanks in advance
Regards
Daya Krishan Dubey
-
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: mysqld refuse to die
Yes.All processes are named mysqld...less one mysqld_safe which is main guilty for keeping mysql daemon in life. P.S. Please tell me (if you wish)...what means AFAIK? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jocelyn Fournier [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED]; Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 2:27 PM Subject: Re: mysqld refuse to die just kill mysqld_safe and then the mysqld process :) (but AFAIK all the mysql thread are names mysqld ??) - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Jocelyn Fournier [EMAIL PROTECTED]; Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 12:20 PM Subject: Re: mysqld refuse to die ...because not all mysql processes are named mysql and is one (and you know about this) which is for safe running(mysqld_safe or safe_mysqld) which create new threads when another is killed. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jocelyn Fournier [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED]; Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 2:12 PM Subject: Re: mysqld refuse to die Hi, Why not trying killall -9 mysqld ? Regards, Jocelyn - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 12:08 PM Subject: Re: mysqld refuse to die Hi, If you really wish to kill the mysql daemon in this way : You should try : ps -ef |grep mysql ...show all the mysqld processes and after this must enumarate all pid of processes in a single kill command. E.g. kill -9 1024 1056 ...(processes which are open). But it's more health if you can stop the server using : /etc/rc.d/mysqld stop Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jack Chen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 7:57 AM Subject: Re: mysqld refuse to die I have just figured out: kill -9 xxx (process number) Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] On Sat, 9 Nov 2002, Jack Chen wrote: Hi All, Please help me with this problem: For some reason, I could not bring down my mysqld by running mysqld stop An error message indicate: fail What's going on? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] - 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 --- Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus. Xnet automatically scans all messages for viruses using RAV AntiVirus. Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate variantele lor. Va rugam sa luati in considerare ca exista un risc de fiecare data cand deschideti fisiere atasate si ca MobiFon nu este
RE: mysqld refuse to die
As Far As I Know -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Saturday, 9 November 2002 23:37 To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED] Subject: Re: mysqld refuse to die Yes.All processes are named mysqld...less one mysqld_safe which is main guilty for keeping mysql daemon in life. P.S. Please tell me (if you wish)...what means AFAIK? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jocelyn Fournier [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED]; Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 2:27 PM Subject: Re: mysqld refuse to die just kill mysqld_safe and then the mysqld process :) (but AFAIK all the mysql thread are names mysqld ??) - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Jocelyn Fournier [EMAIL PROTECTED]; Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 12:20 PM Subject: Re: mysqld refuse to die ...because not all mysql processes are named mysql and is one (and you know about this) which is for safe running(mysqld_safe or safe_mysqld) which create new threads when another is killed. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jocelyn Fournier [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED]; Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 2:12 PM Subject: Re: mysqld refuse to die Hi, Why not trying killall -9 mysqld ? Regards, Jocelyn - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 12:08 PM Subject: Re: mysqld refuse to die Hi, If you really wish to kill the mysql daemon in this way : You should try : ps -ef |grep mysql ...show all the mysqld processes and after this must enumarate all pid of processes in a single kill command. E.g. kill -9 1024 1056 ...(processes which are open). But it's more health if you can stop the server using : /etc/rc.d/mysqld stop Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jack Chen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 7:57 AM Subject: Re: mysqld refuse to die I have just figured out: kill -9 xxx (process number) Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] On Sat, 9 Nov 2002, Jack Chen wrote: Hi All, Please help me with this problem: For some reason, I could not bring down my mysqld by running mysqld stop An error message indicate: fail What's going on? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] - 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 --- Xnet scaneaza
RE: mysqld refuse to die
Also In My Humble Opinion (IMHO) For What It's Worth (FWIW) -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Saturday, 9 November 2002 23:37 To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED] Subject: Re: mysqld refuse to die Yes.All processes are named mysqld...less one mysqld_safe which is main guilty for keeping mysql daemon in life. P.S. Please tell me (if you wish)...what means AFAIK? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jocelyn Fournier [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED]; Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 2:27 PM Subject: Re: mysqld refuse to die just kill mysqld_safe and then the mysqld process :) (but AFAIK all the mysql thread are names mysqld ??) - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Jocelyn Fournier [EMAIL PROTECTED]; Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 12:20 PM Subject: Re: mysqld refuse to die ...because not all mysql processes are named mysql and is one (and you know about this) which is for safe running(mysqld_safe or safe_mysqld) which create new threads when another is killed. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jocelyn Fournier [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED]; Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 2:12 PM Subject: Re: mysqld refuse to die Hi, Why not trying killall -9 mysqld ? Regards, Jocelyn - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 12:08 PM Subject: Re: mysqld refuse to die Hi, If you really wish to kill the mysql daemon in this way : You should try : ps -ef |grep mysql ...show all the mysqld processes and after this must enumarate all pid of processes in a single kill command. E.g. kill -9 1024 1056 ...(processes which are open). But it's more health if you can stop the server using : /etc/rc.d/mysqld stop Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jack Chen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 7:57 AM Subject: Re: mysqld refuse to die I have just figured out: kill -9 xxx (process number) Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] On Sat, 9 Nov 2002, Jack Chen wrote: Hi All, Please help me with this problem: For some reason, I could not bring down my mysqld by running mysqld stop An error message indicate: fail What's going on? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] - 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
[reidbryn@doctor.nl2k.ab.ca: Re: help]
Looks as if security got tightened and now next to no databases with Web/php are geting accessed. What needs to be fixed? Customers are yelling. Rectification needed ASAP! forwarded message -- Hi , I corrected the core mysql tables (there was nothing in them) Your root password for mysql is '@!#@$#%' Because there was no user information stored, you'll need to restore their details so they'll be able to access their databases again. -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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: query crushes server
Eugene, Saturday, November 09, 2002, 1:33:39 AM, you wrote: EB May be this was reported already. EB I have windows 2000 using mysql version 4.0.3-beta-nt EB When I ran a query like EB select distinct a.* from tasks a, gnrlasoc b; EB mysqld-nt.exe crashes. EB I know this query makes no sense but it should not crush server It doesn't crashes for me not on 4.0.3 nor 4.0.4 Could you provide some more detail? -- 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
re: RE: MysQL Installation
SpyProductions, Friday, November 08, 2002, 10:50:33 PM, you wrote: SST Well hells bells! SST Would that be the 'Client programs (i386) (2.3M)' mentioned on the download SST page? :) Yes. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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
re: escape character
Daya,
Saturday, November 09, 2002, 2:28:07 PM, you wrote:
DKD Hi can anybody tell me how can i insert rtf data in my sql, since it
DKD contains escape characters
DKD like this
DKD {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0
DKD Verdana;}{\f1\fnil\fcharset2 Webdings;}{\f2\fnil\fcharset0 MS Sans Serif;}}
DKD {\colortbl ;\red0\green0\blue0;\red0\green0\blue255;}
DKD \viewkind4\uc1\pard\cf1\b\f0\fs20 SanjivnullKapila\b0\f1\fs24 4\cf2\f2\fs17
DKD 455
DKD \par \pard }
DKD So it deletes the characters \r and \b. Column type is text.
You need to escape characters:
http://www.mysql.com/doc/en/String_syntax.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [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
re: Errors stating Mysql server
Beauford, Saturday, November 09, 2002, 8:27:58 AM, you wrote: B I just reinstalled Slackware and now have the unenviable task of getting B Mysql working. What a major pain in the ***. Anyway, here are the B errors. I have read manuals, searched the web, as well as the B newsgroups, and still can't get it to work. No matter what permissions I B change, the errors are still there. Is there not a simple easy way to do B this. This is really ridiculous. B TIA B 021108 21:18:11 mysqld started B /usr/local/mysql/libexec/mysqld: File './beauford-bin.009' not found B (Errcode: 13) B 021108 21:18:11 Could not use beauford-bin for logging (error 13) B 021108 21:18:11 /usr/local/mysql/libexec/mysqld: Can't create/write to B file '/usr/local/mysql/var/beauford.pid' (Errcode: 13) B 021108 21:18:11 /usr/local/mysql/libexec/mysqld: Can't find file: B './mysql/host.frm' (errno: 13) B 021108 21:18:11 /usr/local/mysql/libexec/mysqld: Error on delete of B '/usr/local/mysql/var/beauford.pid' (Errcode: 2) B 021108 21:18:11 mysqld ended MySQL must be the owner of the data dir. Check the owner of MySQL data dir. -- 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
Re: mysqld refuse to die
Thanks you all for your nice suggestions. The thing is, for some reason, I could not stop the mysqld using 'mysqld stop'. Any insight about why this would fail? Another question, which might not be a *pure* mysql one, is: I ran a script to load my mysql database, but it has not finished the job for almost 10 hours and now it is in *wait 4* state. Anything I can do about this? Should I wait till it is done or there is no hope and I just need to stop it and ran again? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] On Sat, 9 Nov 2002, Gelu Gogancea wrote: Hi, If you really wish to kill the mysql daemon in this way : You should try : ps -ef |grep mysql ...show all the mysqld processes and after this must enumarate all pid of processes in a single kill command. E.g. kill -9 1024 1056 ...(processes which are open). But it's more health if you can stop the server using : /etc/rc.d/mysqld stop Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jack Chen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 7:57 AM Subject: Re: mysqld refuse to die I have just figured out: kill -9 xxx (process number) Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] On Sat, 9 Nov 2002, Jack Chen wrote: Hi All, Please help me with this problem: For some reason, I could not bring down my mysqld by running mysqld stop An error message indicate: fail What's going on? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] - 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 --- Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus. Xnet automatically scans all messages for viruses using RAV AntiVirus. Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate variantele lor. Va rugam sa luati in considerare ca exista un risc de fiecare data cand deschideti fisiere atasate si ca MobiFon nu este responsabila pentru nici un prejudiciu cauzat de virusi. Disclaimer: RAV AntiVirus may not be able to detect all new viruses and variants. Please be aware that there is a risk involved whenever opening e-mail attachments to your computer and that MobiFon is not responsible for any damages caused by viruses. - 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: [reidbryn@doctor.nl2k.ab.ca: Re: help]
since my of my customers are reporting that they are getting: Search Results for 'T5Y1M4' Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)No results were found for 'T5Y1M4'. Searching again for the two-digit postal code 'T5'. WHAT must I do to correct his?? On Sat, Nov 09, 2002 at 08:04:45AM -0700, System Administrator a.k.a. The Root of the Problem wrote: Looks as if security got tightened and now next to no databases with Web/php are geting accessed. What needs to be fixed? Customers are yelling. Rectification needed ASAP! forwarded message -- Hi , I corrected the core mysql tables (there was nothing in them) Your root password for mysql is '@!#@$#%' Because there was no user information stored, you'll need to restore their details so they'll be able to access their databases again. -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED]http://www.nl2k.ab.ca 990-3244 - 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 -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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: [reidbryn@doctor.nl2k.ab.ca: Re: help]
create the users again or whatever you had before. Thomas On Sat, 9 Nov 2002 09:38:32 -0700 System Administrator a.k.a. The Root of the Problem [EMAIL PROTECTED] wrote: since my of my customers are reporting that they are getting: Search Results for 'T5Y1M4' Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)No results were found for 'T5Y1M4'. Searching again for the two-digit postal code 'T5'. WHAT must I do to correct his?? On Sat, Nov 09, 2002 at 08:04:45AM -0700, System Administrator a.k.a. The Root of the Problem wrote: Looks as if security got tightened and now next to no databases with Web/php are geting accessed. What needs to be fixed? Customers are yelling. Rectification needed ASAP! forwarded message -- Hi , I corrected the core mysql tables (there was nothing in them) Your root password for mysql is '@!#@$#%' Because there was no user information stored, you'll need to restore their details so they'll be able to access their databases again. -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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 -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED]http://www.nl2k.ab.ca 990-3244 - 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: mysqld refuse to die
Hi, What error you get when try to stop mysql daemon ?..or tell us what is in mysqld.log? Maybe we can help you. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jack Chen [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 5:45 PM Subject: Re: mysqld refuse to die Thanks you all for your nice suggestions. The thing is, for some reason, I could not stop the mysqld using 'mysqld stop'. Any insight about why this would fail? Another question, which might not be a *pure* mysql one, is: I ran a script to load my mysql database, but it has not finished the job for almost 10 hours and now it is in *wait 4* state. Anything I can do about this? Should I wait till it is done or there is no hope and I just need to stop it and ran again? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] On Sat, 9 Nov 2002, Gelu Gogancea wrote: Hi, If you really wish to kill the mysql daemon in this way : You should try : ps -ef |grep mysql ...show all the mysqld processes and after this must enumarate all pid of processes in a single kill command. E.g. kill -9 1024 1056 ...(processes which are open). But it's more health if you can stop the server using : /etc/rc.d/mysqld stop Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jack Chen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 7:57 AM Subject: Re: mysqld refuse to die I have just figured out: kill -9 xxx (process number) Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] On Sat, 9 Nov 2002, Jack Chen wrote: Hi All, Please help me with this problem: For some reason, I could not bring down my mysqld by running mysqld stop An error message indicate: fail What's going on? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] - 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 --- Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus. Xnet automatically scans all messages for viruses using RAV AntiVirus. Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate variantele lor. Va rugam sa luati in considerare ca exista un risc de fiecare data cand deschideti fisiere atasate si ca MobiFon nu este responsabila pentru nici un prejudiciu cauzat de virusi. Disclaimer: RAV AntiVirus may not be able to detect all new viruses and variants. Please be aware that there is a risk involved whenever opening e-mail attachments to your computer and that MobiFon is not responsible for any damages caused by viruses. - 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:
Re: MySQL and UPDATE query
On 11/9/02 3:01 AM, Bruno Batarelo [EMAIL PROTECTED] wrote: Greetings I have problems executing very simple UPDATE query. I do not know whether it is a bug or not, but it works in Access and also works with mySQL, but only from access using linked tables. Query is as followes: UPDATE Table_name SET Field_name = Left(Field_name, 4) 'a' Right(Field_name, 4); This query should change every Field_name's 5'th character to 'a'. One more thing - every record in this table has fixed size value so every value is a string 10 characters long. When using access database or mysql database over access everything goes well, but when using VB and MyODBC or just mysql client, every Field_name's value bocomes 0 (zero). What did I do wrong? Thank you all Bruno Batarelo Maybe CONCAT() is the answer, haven't tried it though: UPDATE Table_name SET Field_name = CONCAT(LEFT(Field_name, 4), 'a', RIGHT(Field_name, 4)); http://www.mysql.com/doc/en/String_functions.html /h - 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: Errors stating Mysql server
MySQL must be the owner of the data dir. Check the owner of MySQL data dir. It was, but I have since changed it to root and it works fine now. Any idea why this would be? drwxr-xr-x 12 root mysql4096 Nov 8 18:00 ./ drwxr-xr-x 15 root root 4096 Nov 8 20:12 ../ drwxr-xr-x2 root mysql4096 Nov 8 18:00 bin/ drwxr-xr-x3 root mysql4096 Nov 8 17:59 include/ drwxr-xr-x2 root mysql4096 Nov 8 17:59 info/ drwxr-xr-x3 root mysql4096 Nov 8 17:59 lib/ drwxr-xr-x2 root mysql4096 Nov 8 18:00 libexec/ drwxr-xr-x3 root mysql4096 Nov 8 18:00 man/ drwxr-xr-x6 root mysql4096 Nov 8 18:00 mysql-test/ drwxr-xr-x3 root mysql4096 Nov 8 18:00 share/ drwxr-xr-x7 root mysql4096 Nov 8 18:00 sql-bench/ drwxr-xr-x5 root mysql4096 Nov 9 05:39 var/ TIA -Original Message- From: Victoria Reznichenko [mailto:victoria.reznichenko;ensita.net] Sent: November 9, 2002 11:28 AM To: [EMAIL PROTECTED] Subject: re: Errors stating Mysql server Beauford, Saturday, November 09, 2002, 8:27:58 AM, you wrote: B I just reinstalled Slackware and now have the unenviable task of B getting Mysql working. What a major pain in the ***. Anyway, here are B the errors. I have read manuals, searched the web, as well as the B newsgroups, and still can't get it to work. No matter what B permissions I change, the errors are still there. Is there not a B simple easy way to do this. This is really ridiculous. B TIA B 021108 21:18:11 mysqld started B /usr/local/mysql/libexec/mysqld: File './beauford-bin.009' not found B (Errcode: 13) B 021108 21:18:11 Could not use beauford-bin for logging (error 13) B 021108 21:18:11 /usr/local/mysql/libexec/mysqld: Can't create/write B to file '/usr/local/mysql/var/beauford.pid' (Errcode: 13) 021108 B 21:18:11 /usr/local/mysql/libexec/mysqld: Can't find file: B './mysql/host.frm' (errno: 13) 021108 21:18:11 B /usr/local/mysql/libexec/mysqld: Error on delete of B '/usr/local/mysql/var/beauford.pid' (Errcode: 2) 021108 21:18:11 B mysqld ended MySQL must be the owner of the data dir. Check the owner of MySQL data dir. - 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: Newbie help needed with mysql
I dont have a my.cnf file, so I touched /etc/my.conf still doesnt work. Where do I find a .cnf file to copy over? and root@rock:/var/run/mysql# ls mysql.sock= it exists. What could my problem be..? I even upgraded. I am using Slackware 8.1 with 2.4.19 kernel. Maybe that will help. Thanks so far! John Chek your my.cnf file and see where it points to for the mysql.sock file.it should be under the client portion of it. if you don't have a my.cnf file hat's your prob right there. Copt one of the cnf files to /etc and you should be up and running. - 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
Newbie help needed with mysql : part II
Ok.. I got the /etc/my.cnf under control, but now when I do this: root@rock:/etc# mysqladmin -u root -h rock password * mysqladmin: connect to server at 'rock' failed error: 'Host 'rock.biohazard.org' is not allowed to connect to this MySQL server' Then I tried this: root@rock:/etc# mysqladmin create testDB mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' in /etc/group, I added root and my user john to the mysql group.. but that did not help. If there is something in the manual, please point it out to me, so I can figure this mess out. Thanks a million John - 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: Newbie help needed with mysql : part II
On Sat, 2002-11-09 at 14:45, john wrote: Ok.. I got the /etc/my.cnf under control, but now when I do this: root@rock:/etc# mysqladmin -u root -h rock password * mysqladmin: connect to server at 'rock' failed error: 'Host 'rock.biohazard.org' is not allowed to connect to this MySQL server' Then I tried this: root@rock:/etc# mysqladmin create testDB mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' in /etc/group, I added root and my user john to the mysql group.. but that did not help. If there is something in the manual, please point it out to me, so I can figure this mess out. Thanks a million John Have you ran mysql_install_db? John Coder - 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
Fatal error when using --skip-grant-tables option
OK, I lost my password. Snicker away. I tried using the instructions I found in the MySQL manual and got hung up on starting the MySQL server in an unsecured state. The instructions say to start mysqld with the --skip-grant-tables option. When I do I get a Fatal Error: Please read Security section of the manual to find out how to run mysqld as root. Then the server shuts down. I tried looking in the documentation but found nothing. Please advise... Robert Johnston Datajockeys, LLC Hillsboro, OR - 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: JDBC Connection Pooling Not Quite Right?
sql, query ... just to make the filter happy. on 11/8/02 2:30 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: You are missing something, I am afraid. To quite Sun's Javadoc for the PooledConnection class Thank you so much for the quick reply. Now I understand why the implementation of pooled connections seemed so lame (why on earth did JDBC client code need to get a different kind of connection?). Strikes me that it's just as ridiculous that I have to implement the pooling scheme. It would have made more sense to provide a reasonable pooling scheme and allowed me to add my own, if I so desired. In any event, thank you. Now I know how to fix the problem! The Java list - [EMAIL PROTECTED] - would probaby be more appropriate than the general list, but otherwise this is the right place. Perhaps that should be mentioned on the Connector/J pages...I had no idea such a list existed. Thanks! -- Rick - 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
little problem, I need some help...
hello everyone: to begin with, I apologise for asking a question which is probably obvious. My name is Emilio Pisanty and I and one of the two makers of my school's website. recently we updated the database system (on mysql) from version 3.23 to version 4. since then, any attmepts we've made to update tables have met with a 1175 error (You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column). can anyone tell me how I work around this? sorry again, and thanks in advance, Emilio Pisanty - 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: little problem, I need some help...
On 11/9/02 3:14 PM, 3mip1s4la-Emilio Pisanty [EMAIL PROTECTED] wrote: hello everyone: to begin with, I apologise for asking a question which is probably obvious. My name is Emilio Pisanty and I and one of the two makers of my school's website. recently we updated the database system (on mysql) from version 3.23 to version 4. since then, any attmepts we've made to update tables have met with a 1175 error (You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column). can anyone tell me how I work around this? sorry again, and thanks in advance, Emilio Pisanty Nothing is obvious and is hard to advise you if you don't give us some more info on the table structure and the update query you have trouble with. /h - 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: little problem, I need some help...
tables have met with a 1175 error (You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column). Nothing is obvious and is hard to advise you if you don't give us some more info on the table structure and the update query you have trouble with. /h ok. thable structure is this: mysql describe pupils; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | name | varchar(20) | YES | | NULL| | | surname | varchar(20) | YES | | NULL| | | surname2 | varchar(20) | YES | | NULL| | | form | char(3) | YES | | NULL| | | tutor| varchar(20) | YES | | NULL| | | sex | char(1) | YES | | NULL| | | birth| date| YES | | NULL| | | math | char(3) | YES | | NULL| | | optA | char(3) | YES | | NULL| | | optB | char(3) | YES | | NULL| | +--+-+--+-+-+---+ 10 rows in set (0.00 sec) it was built in version 3.23, and we recently updated to 4.0.4 beta. the query I'm running is mysql UPDATE pupuils SET tutor = 'URIOSTEGUI' WHERE group = 'U6U'; (setting the name of the tutor for Upper 6) and I meet with: ERROR 1175: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column I don't quite understand what a KEY column is, can someone explain it to me? if you can't answer, where can I find error listings? because they don't appear to be on the site. hope this helps you help me... thanks in advance, Emilio Pisanty - 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: little problem, I need some help...
Hi, I don't see any group column in your table, are you displaying the right table (describe pupils; instead of describe pupuils; ?). A KEY column is a column which have an INDEX on it. Regards, Jocelyn - Original Message - From: 3mip1s4la-Emilio Pisanty [EMAIL PROTECTED] To: R. Hannes Niedner [EMAIL PROTECTED] Cc: MySQL Mailinglist [EMAIL PROTECTED] Sent: Sunday, November 10, 2002 12:34 AM Subject: Re: little problem, I need some help... tables have met with a 1175 error (You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column). Nothing is obvious and is hard to advise you if you don't give us some more info on the table structure and the update query you have trouble with. /h ok. thable structure is this: mysql describe pupils; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | name | varchar(20) | YES | | NULL| | | surname | varchar(20) | YES | | NULL| | | surname2 | varchar(20) | YES | | NULL| | | form | char(3) | YES | | NULL| | | tutor| varchar(20) | YES | | NULL| | | sex | char(1) | YES | | NULL| | | birth| date| YES | | NULL| | | math | char(3) | YES | | NULL| | | optA | char(3) | YES | | NULL| | | optB | char(3) | YES | | NULL| | +--+-+--+-+-+---+ 10 rows in set (0.00 sec) it was built in version 3.23, and we recently updated to 4.0.4 beta. the query I'm running is mysql UPDATE pupuils SET tutor = 'URIOSTEGUI' WHERE group = 'U6U'; (setting the name of the tutor for Upper 6) and I meet with: ERROR 1175: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column I don't quite understand what a KEY column is, can someone explain it to me? if you can't answer, where can I find error listings? because they don't appear to be on the site. hope this helps you help me... thanks in advance, Emilio Pisanty - 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: little problem, I need some help...
On Sat, 2002-11-09 at 19:34, 3mip1s4la-Emilio Pisanty wrote: tables have met with a 1175 error (You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column). Nothing is obvious and is hard to advise you if you don't give us some more info on the table structure and the update query you have trouble with. /h ok. thable structure is this: mysql describe pupils; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | name | varchar(20) | YES | | NULL| | | surname | varchar(20) | YES | | NULL| | | surname2 | varchar(20) | YES | | NULL| | | form | char(3) | YES | | NULL| | | tutor| varchar(20) | YES | | NULL| | | sex | char(1) | YES | | NULL| | | birth| date| YES | | NULL| | | math | char(3) | YES | | NULL| | | optA | char(3) | YES | | NULL| | | optB | char(3) | YES | | NULL| | +--+-+--+-+-+---+ 10 rows in set (0.00 sec) it was built in version 3.23, and we recently updated to 4.0.4 beta. the query I'm running is mysql UPDATE pupuils SET tutor = 'URIOSTEGUI' WHERE group = 'U6U'; (setting the name of the tutor for Upper 6) and I meet with: ERROR 1175: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column I don't quite understand what a KEY column is, can someone explain it to me? if you can't answer, where can I find error listings? because they don't appear to be on the site. hope this helps you help me... well a couple of things I see. 1. you have no group in field so it can't compare U6U to anything. 2. I don't think you can use a field name group anyway since group is reserved in mysql 3. you have no key in your table therefore you can't do a conditional statement (where) to compare it to. Error 1175 is the error that was reported to you. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column - 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: little problem, I need some help...
Every SQL database requires the ability to locate a record which is unique in some way. You can't have two records which look the same. That's why you need to define a primary KEY on a column or coumns. You need to read a primer on SQL databases Alan -Original Message- From: 3mip1s4la-Emilio Pisanty [mailto:emipisala;lancaster.edu.mx] Sent: Sunday, 10 November 2002 11:34 To: R. Hannes Niedner Cc: MySQL Mailinglist Subject: Re: little problem, I need some help... tables have met with a 1175 error (You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column). Nothing is obvious and is hard to advise you if you don't give us some more info on the table structure and the update query you have trouble with. /h ok. thable structure is this: mysql describe pupils; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | name | varchar(20) | YES | | NULL| | | surname | varchar(20) | YES | | NULL| | | surname2 | varchar(20) | YES | | NULL| | | form | char(3) | YES | | NULL| | | tutor| varchar(20) | YES | | NULL| | | sex | char(1) | YES | | NULL| | | birth| date| YES | | NULL| | | math | char(3) | YES | | NULL| | | optA | char(3) | YES | | NULL| | | optB | char(3) | YES | | NULL| | +--+-+--+-+-+---+ 10 rows in set (0.00 sec) it was built in version 3.23, and we recently updated to 4.0.4 beta. the query I'm running is mysql UPDATE pupuils SET tutor = 'URIOSTEGUI' WHERE group = 'U6U'; (setting the name of the tutor for Upper 6) and I meet with: ERROR 1175: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column I don't quite understand what a KEY column is, can someone explain it to me? if you can't answer, where can I find error listings? because they don't appear to be on the site. hope this helps you help me... thanks in advance, Emilio Pisanty - 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: little problem, I need some help...
hello everyone: 1) in my school groups are called forms, so I used it not to confuse you 2) I hadn't learnt how to define indexes on MySQL so I hadn't defined any 3) now I have, and... 4) the query worked. thanks for your help, Emilio Pisanty - 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 security and CGI
Hello all! I am working on a site which is using mod_perl and a mysql database on Linux with Apache. I am also putting cookies and user address information into a cookies table to fill up form fields for subsequent visits. Standard enough. Also, the database is on the same server as apache. Now, my problem is that I am paranoid about hackers who are able to break in through apache and assume the user apache. Who can then issue mysql selects and inserts on the cookies table. Does anyone have pointers to mysql security docs and such where I can do what I want without these concerns? Thanks a buncho in advance! --Raj PS: THANK YOU MYSQL DEVELOPERS What a god-send!! * - 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: little problem, I need some help...
You don't *need* a primary key on a table. You don't a key on a table at all, if that's what you want. You can turn off this error message without altering your table by specifying --safe-updates=0 when you start the mysql client. This option apparently is turned on by default in 4.x. The point of the option is to stop people from doing silly things like delete from table without a WHERE clause. Dean Harding -Original Message- From: Alan McDonald [mailto:alan;meta.com.au] Sent: Sunday, 10 November 2002 12:04 pm To: 3mip1s4la-Emilio Pisanty Cc: MySQL Mailinglist Subject: RE: little problem, I need some help... Every SQL database requires the ability to locate a record which is unique in some way. You can't have two records which look the same. That's why you need to define a primary KEY on a column or coumns. You need to read a primer on SQL databases Alan -Original Message- From: 3mip1s4la-Emilio Pisanty [mailto:emipisala;lancaster.edu.mx] Sent: Sunday, 10 November 2002 11:34 To: R. Hannes Niedner Cc: MySQL Mailinglist Subject: Re: little problem, I need some help... tables have met with a 1175 error (You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column). Nothing is obvious and is hard to advise you if you don't give us some more info on the table structure and the update query you have trouble with. /h ok. thable structure is this: mysql describe pupils; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | name | varchar(20) | YES | | NULL| | | surname | varchar(20) | YES | | NULL| | | surname2 | varchar(20) | YES | | NULL| | | form | char(3) | YES | | NULL| | | tutor| varchar(20) | YES | | NULL| | | sex | char(1) | YES | | NULL| | | birth| date| YES | | NULL| | | math | char(3) | YES | | NULL| | | optA | char(3) | YES | | NULL| | | optB | char(3) | YES | | NULL| | +--+-+--+-+-+---+ 10 rows in set (0.00 sec) it was built in version 3.23, and we recently updated to 4.0.4 beta. the query I'm running is mysql UPDATE pupuils SET tutor = 'URIOSTEGUI' WHERE group = 'U6U'; (setting the name of the tutor for Upper 6) and I meet with: ERROR 1175: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column I don't quite understand what a KEY column is, can someone explain it to me? if you can't answer, where can I find error listings? because they don't appear to be on the site. hope this helps you help me... thanks in advance, Emilio Pisanty - 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
Re: I: How to port MS Access to MySQL ??
although i make a living from their products and corereader runs under windows, i really really hate to give macrosoft a plug. but i keep seeing this kind of question here, so here's what i do, if you have the tools. 1. i fire up enterprise manager for ms sql server, because it has a pretty slick dts mechanism. (man, i hate writing that.) 2. then i suck the access database into ms sql. 3. then i alter whatever needs to be cleaned up inside the server for whatever server it's going to. 4. then, still inside enterprise manager, i send it to mysql, or oracle, or whatever. super simple and easy. argh! gotta wash my mouth out with soap. I use navicat http://www.mysqlstudio.com/. ing. stefano scattini -Messaggio originale- Da: tmb [mailto:topmailbox;yahoo.com] Inviato: venerdì 8 novembre 2002 13.18 A: [EMAIL PROTECTED] Oggetto: How to port MS Access to MySQL ?? Is there a tool for doing a quick port from MS Access to MySQL? Or must you manually create all the tables sql statements in MySQL and then export the MS Access data to a comma delimited file... then import it into MySQL? Thanks for any help - tmb __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - 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 -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.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: Question regarding nested select
if you have a windows box that you can use as a front end, download corereader from http://www.corereader.com it lets you do point and click queries, so you can quickly experiment with simple queries. In article [EMAIL PROTECTED], [EMAIL PROTECTED] writes: Hi, Does version 2.23.52 supports the use of nested select? I want to write a query based on a group where I do a count of something for each group. In SQL Server 7 it would look something like this, select a.department ,(select count(*) from empdb where gender='m' and department=a.department) as male ,(select count(*) from empdb where gender='f' and department=a.department) as female from empdb a group by department No need for a nested SELECT: SELECT department, SUM(IF(gender = 'm', 1, 0)) AS male, SUM(IF(gender = 'f', 1, 0)) AS female FROM empdb GROUP BY department -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.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
Help with mysql_fetch_array
Ok, I can't figure out how to make my select sum(runtime) from list
query work properly. At the bottom is the entire page. I've tried a
few different things, but can't figure out how I'm SUPPOSED to set this
up.
Here is what I think are the relevant lines:
$dvd_time_query = select sum(runtime) from list;
$dvd_time_result = mysql_query($dvd_time_query);
#$dvd_time_display = mysql_fetch_array($dvd_time_query);
#echo td class=mfont size =
-1b.($dvd_time_display[count])./b/td;
echo td class=mfont size = -1b.$dvd_time_result./b/td;
Notice I've tried a few things, that I currently have commented out. I
think I need a while loop in here somewhere from what I've read, but I
haven't been able to make sense of the manual or any other help pages
I've found.
Any help would be greatly appreciated.
Thanks,
Chip
html
head
titleOur DVD's/title
link rel=stylesheet href=dvd.css /
style type=text/css/style
/head
body link=white vlink=white alink=white
?
@$db = mysql_pconnect(localhost,username,password);
if (!$db)
{
echo Error: Could not connect to the database. Please try
again later.;
exit;
}
mysql_select_db(dvds);
$query = select * from list order by title;
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
$dvd_time_query = select sum(runtime) from list;
$dvd_time_result = mysql_query($dvd_time_query);
#$dvd_time_display = mysql_fetch_array($dvd_time_query);
echo table cols=5 align=center border=0 cellspacing=2 cellpadding=2
bgcolor=#ff;
echo thead style='display:table-header-group';
echo tr bgcolor=#505050;
echo td class =m valign=bottomfont size = -1 color =
whiteA HREF=''bTitle/A/td;
echo td class =m valign=bottomfont size = -1 color =
whiteA HREF='genre.dvds.php'bGenre/a/td;
echo td class =m valign=bottomfont size = -1 color =
whiteA HREF='rating.dvds.php'bRating/A/td;
echo td class =m valign=bottomfont size = -1 color =
whiteA HREF='runtime.dvds.php'bRuntime/A/td;
echo td class =m valign=bottomfont size = -1 color =
whitebMore Info/td;
echo /tr;
echo /thead;
echo tbody style='display:table-row-group';
for ($i=0; $i $num_results; $i++)
{
$row = mysql_fetch_array($result);
echo tr bgcolor=#e0e0e0 valign=top;
echo tdfont size = -1;
echo htmlspecialchars( stripslashes($row[title]));
echo /td;
echo tdfont size = -1;
echo htmlspecialchars( stripslashes($row[genre]));
echo /td;
echo tdfont size = -1;
echo htmlspecialchars( stripslashes($row[rating]));
echo /td;
echo td class=info align = rightfont size = -1;
echo htmlspecialchars( stripslashes($row[runtime]));
echo /td;
echo tdfont size = -1center;
echo nbspA HREF=';
echo htmlspecialchars( stripslashes($row[info]));
echo ' target='_blank' class=infoMore Info/A;
echo nbsp;
echo /tdcenter;
echo /tr;
}
echo td class=mfont size = -1bTotal Runtime:/b/td;
echo td class=mfont size = -1nbsp/td;
echo td class=mfont size = -1nbsp/td;
#echo td class=mfont size =
-1b.($dvd_time_display[count])./b/td;
echo td class=mfont size = -1b.$dvd_time_result./b/td;
echo td class=mfont size = -1nbsp/td;
echo /table;
echo Total Number of DVD's in Dabatase: .$num_results.;
?
/body
/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 crashing
Mysql version: 3.23.53 Background: I've got a master and slave setup and I'm switching to a new master server. In the process of switching I need the new master to be a slave for awhile. However, after copying over a snapshot of my data I found that mysql dies whenever the slave thread starts. Problem: Upon further investigation I found that I can start the mysql daemon (without the slave setup) and connect locally just fine, but if I try to connect from a remote host mysql, segfaults and dies: /usr/local/mysql/bin/safe_mysqld: line 1: 10781 Segmentation fault nice --5 nohup /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/blaa.ncsa.uiuc.edu.pid --skip-locking -O key_buffer\=32M -O table_cache\=256 -O myisam_sort_buffer_size\=32M -O sort_buffer\=16M -O record_buffer\=1M --set-variable\=max_allowed_packet\=8M --log-slow-queries\=\/var\/log\/mysql\/slow-queries --log-update\=\/usr\/local\/mysql-backup\/update.log --log-bin\=\/usr\/local\/mysql-backup\/binlog\/mysqlbin --log-bin-index\=\/usr\/local\/mysql-backup\/binlog\/mysqlbin.index --set-variable\=query_buffer_size\=131072 --set-variable\=join_buffer_size\=262144 --set-variable\=thread_cache_size\=16 --set-variable\=max_connections\=1000 -O max_connect_errors\=1 --server-id\=3 /usr/local/mysql/var/blaa.ncsa.uiuc.edu.err 21 Number of processes running now: 1 mysqld process hanging, pid 10791 - killed 021109 19:15:45 mysqld restarted 021109 19:15:45 mysqld ended -- The error log simply says this: Number of processes running now: 1 mysqld process hanging, pid 12010 - killed 021109 20:09:00 mysqld restarted 021109 20:09:00 Can't start server: Bind on TCP/IP port: Address already in use 021109 20:09:00 Do you already have another mysqld server running on port: 3306 ? 021109 20:09:00 Aborting 021109 20:09:00 /usr/local/mysql/libexec/mysqld: Shutdown Complete 021109 20:09:00 mysqld ended -- The remote host sees this: mysql -h blaa.ncsa.uiuc.edu -u virus-admin -p Enter password: ERROR 2013: Lost connection to MySQL server during query I think that's just a symptom of the above problem. I thought it might be a data corruption problem, so I removed my data and ran mysql_install_db. The problem persists. Any ideas? I've just about run out of things to try. The other two mysql servers don't have this problem and they're installed with the same binaries. Thanks, Mike - 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: mysqld refuse to die
[HUNDREDS of lines clipped...] PLEASE, folks, try to trim up your quotes a bit? Adding one line while mindlessly quoting a thread that has itself been mindlessly quoted at least a half-dozen levels deep may not bother those who get separate messages, but those who get the digest version suffer quite a bit because of it. Just try to be a bit more thoughtful about what others see. Thanks in advance! -- SQL SQL SQL SQL SQL SQL SQL SQL : Jan Steinman -- nature Transography(TM): http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Buy My Step Van! http://www.Bytesmiths.com/van - 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: JDBC Connection Pooling Not Quite Right?
Rick Mann wrote: sql, query ... just to make the filter happy. on 11/8/02 2:30 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: You are missing something, I am afraid. To quite Sun's Javadoc for the PooledConnection class Thank you so much for the quick reply. Now I understand why the implementation of pooled connections seemed so lame (why on earth did JDBC client code need to get a different kind of connection?). Strikes me that it's just as ridiculous that I have to implement the pooling scheme. It would have made more sense to provide a reasonable pooling scheme and allowed me to add my own, if I so desired. Not in Sun's eyes. They figure (rightly or wrongly) that no one runs server-side Java outside of some application server. So they don't spend time specifying a 'standard' connection pool, because that's 'vendor' specific...instead they specify a contract between a JDBC driver and an application server to provide connection pooling. On the other hand, you don't need to re-invent the wheel either. There is a lot of open source connection pooling code out there. The one I'm currently recommending (as it sees the most current development) is DBCP from the Apache Jakarta Commons project: http://jakarta.apache.org/commons/dbcp.html In any event, thank you. Now I know how to fix the problem! The Java list - [EMAIL PROTECTED] - would probaby be more appropriate than the general list, but otherwise this is the right place. Perhaps that should be mentioned on the Connector/J pages...I had no idea such a list existed. Thanks! I'll forward the request to our web team. It is mentioned at the bottom of the README for the driver, however :) -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ 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
PHP bias
I am bothers me. It bothers me that that the MySQL people have a bias towards PHP. PHP is an inferior language. Deal with perl instead. Robert - 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: PHP bias
On 11/10/02 5:12 AM, Robert Macwange [EMAIL PROTECTED] wrote: I am bothers me. It bothers me that that the MySQL people have a bias towards PHP. PHP is an inferior language. Deal with perl instead. Robert Ouch.Death to all fanatics!!! Do you have any question or are you just boiling? /h - 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: PHP bias
I'd suggest that he's just trolling. -Original Message- From: R. Hannes Niedner [mailto:hannes.niedner;gmx.net] Sent: Saturday, November 09, 2002 9:27 PM To: MySQL Mailinglist Subject: Re: PHP bias On 11/10/02 5:12 AM, Robert Macwange [EMAIL PROTECTED] wrote: I am bothers me. It bothers me that that the MySQL people have a bias towards PHP. PHP is an inferior language. Deal with perl instead. Robert Ouch.Death to all fanatics!!! Do you have any question or are you just boiling? /h - 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 4.1 Sub Selects
All, Anyone have any rough idea when 4.1 (with SubSelects) is due to be released? Thanks, Greg. 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: Help with mysql_fetch_array
ok, here is my code without all of the html (sorry people). I'm trying to get a sum of the field runtime. With this code, I get Resource id #3 as an error. Any help getting me to the proper result would be greatly appreciated. ? @$db = mysql_pconnect(localhost,dviewd); mysql_select_db(dvds); $query = select * from list order by title; $result = mysql_query($query); $num_results = mysql_num_rows($result); $dvd_time_query = select sum(runtime) from list; $dvd_time_result = mysql_query($dvd_time_query); echo td class=mfont size = -1b.$dvd_time_result./b/td; ? Thanks, Chip - 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 with mysql_fetch_array
On Sat, 2002-11-09 at 23:53, Chip Shabazian wrote: ok, here is my code without all of the html (sorry people). I'm trying to get a sum of the field runtime. With this code, I get Resource id #3 as an error. Any help getting me to the proper result would be greatly appreciated. ? @$db = mysql_pconnect(localhost,dviewd); mysql_select_db(dvds); $query = select * from list order by title; $result = mysql_query($query); $num_results = mysql_num_rows($result); $dvd_time_query = select sum(runtime) from list; $dvd_time_result = mysql_query($dvd_time_query); add this line; $dvd_result=mysql_result($dvd_time_result,0,0); echo td class=mfont size = -1b.$dvd_result./b/td; //change $dvd_time_result to $dvd_result ? - 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 4.1 Sub Selects
On Sun, Nov 10, 2002 at 03:45:04PM +1100, Greg Matthews wrote: All, Anyone have any rough idea when 4.1 (with SubSelects) is due to be released? Well, if you pull the source code, it's there. But I suspect it'll be a few months before you start seeing pre-built binaries available. There's a lot that needs to be shaken out first--at least that's my impression so far. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 95 days, processed 2,004,951,757 queries (242/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: PHP bias
On Sun, Nov 10, 2002 at 05:12:40AM -0800, Robert Macwange wrote: It bothers me that that the MySQL people have a bias towards PHP. They don't. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 95 days, processed 2,004,958,987 queries (242/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: PHP bias
On Sat, 9 Nov 2002, R. Hannes Niedner wrote: On 11/10/02 5:12 AM, Robert Macwange [EMAIL PROTECTED] wrote: I am bothers me. It bothers me that that the MySQL people have a bias towards PHP. PHP is an inferior language. Deal with perl instead. Robert Ouch.Death to all fanatics!!! Do you have any question or are you just boiling? It's just that MySQL and PHP integrate together so well. The authors of PHP have gone to great lengths to create extensive interfaces to a wide range of databases, not just MySQL. perl doesn't have anything like as much database support, which is why PHP has become popular in the web community. Andy - 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: PHP bias
On Sun, Nov 10, 2002 at 05:49:37AM +, andy thomas wrote: perl doesn't have anything like as much database support, which is why PHP has become popular in the web community. Oh, let's not go down this road. Perl and PHP both have excellent database support. And they're both incredibly popular in the web community. Can we stop this thread? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 95 days, processed 2,005,207,271 queries (241/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: PHP bias
On Sunday 10 November 2002 14:12, Robert Macwange wrote: PHP is an inferior language. Deal with perl instead. Looks like you're not very familar with the spirit of Open Source: Perl, PHP, Python, Ruby etc. are very excellent languages. They all have benefits and of course some disadvantages. But this competition helps each one to improve and become more popular. The same with MySQL, Postgres, SleepyCat, ... etc. There is no better or inferior: Just define your needs and choose whats the best for you. Regards Georg - 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: PHP bias Stop feeding the troll
On 11/9/02 11:31 PM, Georg Richter [EMAIL PROTECTED] wrote: Looks like you're not very familar with the spirit of Open Source: Perl, PHP, Python, Ruby etc. are very excellent languages. They all have benefits and of course some disadvantages. But this competition helps each one to improve and become more popular. The same with MySQL, Postgres, SleepyCat, ... etc. There is no better or inferior: Just define your needs and choose whats the best for you. Regards Georg These are all valid points - There is lid for every pot e.g. language for every task but It has been said before the guy raising the thread was most likely a troll. So lets go back to business and answer real questions. :-)/h - 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 4.1 Sub Selects
It would be a huge help to get hold of MySql 4.1. What's shaken out mean? Is 4.1 still mid-development, or is it in alpha, more or less finished, and needs debugging? Is there anyway soon that someone could build and release some binaries? I'd be happy to do testing if 4.1 is in a semi-usable state. Greg. - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Greg Matthews [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, November 10, 2002 4:21 PM Subject: Re: MySql 4.1 Sub Selects On Sun, Nov 10, 2002 at 03:45:04PM +1100, Greg Matthews wrote: All, Anyone have any rough idea when 4.1 (with SubSelects) is due to be released? Well, if you pull the source code, it's there. But I suspect it'll be a few months before you start seeing pre-built binaries available. There's a lot that needs to be shaken out first--at least that's my impression so far. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 95 days, processed 2,004,951,757 queries (242/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: PHP bias
I am bothers me. It bothers me that that the MySQL people have a bias towards PHP. PHP is an inferior language. Deal with perl instead. Robert Ouch.Death to all fanatics!!! Do you have any question or are you just boiling? It's just that MySQL and PHP integrate together so well. The authors of PHP have gone to great lengths to create extensive interfaces to a wide range of databases, not just MySQL. perl doesn't have anything like as much database support, which is why PHP has become popular in the web community. I agree. It's really a drag that you can't use databases very well from within Perl very easily. I wish that someone would invent a database inferface for Perl. And it'd be really cool if they'd do it in such a way that the general interface was portable, so that you could plug in drivers for particular database engines like MySQL or PostgreSQL or Oracle or Informix or even flat-file formats like CSV. And then it'd be neat if someone would invent Perl modules to that would use this database interface so that you could do things like transfer data in and out of databases to send information to and from entities like XML documents or Excel spreadsheets. Man! The more I think about it, the more of a bummer it is that you just can't do this stuff from Perl. - 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: PHP bias
On 11/9/02 11:04 PM, Paul DuBois [EMAIL PROTECTED] wrote: I agree. It's really a drag that you can't use databases very well from within Perl very easily. I wish that someone would invent a database inferface for Perl. And it'd be really cool if they'd do it in such a way that the general interface was portable, so that you could plug in drivers for particular database engines like MySQL or PostgreSQL or Oracle or Informix or even flat-file formats like CSV. And then it'd be neat if someone would invent Perl modules to that would use this database interface so that you could do things like transfer data in and out of databases to send information to and from entities like XML documents or Excel spreadsheets. Man! The more I think about it, the more of a bummer it is that you just can't do this stuff from Perl. :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) Though I think it is not really necessary - for anyone not getting it: http://www.amazon.com/exec/obidos/ASIN/0735710546/ref%3Dcm%5Fbg%5Fd/002-226 0661-0130404 /h - 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: PHP bias
On 11/9/02 11:04 PM, Paul DuBois [EMAIL PROTECTED] wrote: I agree. It's really a drag that you can't use databases very well from within Perl very easily. I wish that someone would invent a database inferface for Perl. And it'd be really cool if they'd do it in such a way that the general interface was portable, so that you could plug in drivers for particular database engines like MySQL or PostgreSQL or Oracle or Informix or even flat-file formats like CSV. And then it'd be neat if someone would invent Perl modules to that would use this database interface so that you could do things like transfer data in and out of databases to send information to and from entities like XML documents or Excel spreadsheets. Man! The more I think about it, the more of a bummer it is that you just can't do this stuff from Perl. :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) Though I think it is not really necessary - for anyone not getting it: http://www.amazon.com/exec/obidos/ASIN/0735710546/ref%3Dcm%5Fbg%5Fd/002-226 0661-0130404 /h - 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
Hello all :-)
Hi all. My name is Mike. I have a Linux RedHat 7.3 with Mysql ver 3.23.49. I want to grant access to databases and tables to users,but only to a certin databases and tables. I red the how-to but both grant and revoke commands does not seems to work (he execute the command but says that 0 records were change) Also if it insert rules to the db and tables_priv (and do a rehash after) it does not work. Can anyone tell me what to do ? is it actually possible on my version of Mysql ? Syntex and examples will be very much helpfull. Thank you very much Mike - 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
