RE: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5)
Hi, I have experienced similar problems to the one you have; the problem you have is that the time gap between the failure and now is so big that you cannot resume replication, because of the big data portion you have to replicate. When this happens to me, increasing the value of the variable you have posted did not work; i did: 1º Stop replication 2º Use mysqlbinlog to see what is on the repl files. 3º Manually apply the changes (on the slave, of course) to a defined position (50K queries far away the failure). 4º Start replication on this position, manually especifying the position on the command "start slave" (see manual). This worked fine to me. Regards. -Mensaje original- De: Dominik Klein [mailto:[EMAIL PROTECTED] Enviado el: lunes 28 de abril de 2008 16:28 Para: mysql@lists.mysql.com Asunto: Re: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5) Hi. Juan Eduardo Moreno wrote: > Sorry, what is your setting for max_allowed_packet variable? mysql> show variables like "%allowed%"; ++--+ | Variable_name | Value| ++--+ | max_allowed_packet | 16776192 | ++--+ 1 row in set (0.00 sec) Here's an excerpt from the logs. It does not look like that value is involved in this: 080428 13:07:04 [ERROR] Error reading packet from server: Out of memory (Needed 2704 bytes) ( server_errno=5) 080428 13:07:04 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'SRV02bin.000131' position 447892967 080428 13:07:04 [Note] Slave: connected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'SRV02-bin.000131' at position 447892967 080428 13:22:14 [ERROR] Error reading packet from server: Out of memory (Needed 2704 bytes) ( server_errno=5) 080428 13:22:14 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'SRV02-bin.000131' position 471157588 080428 13:22:14 [Note] Slave: connected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'SRV02-bin.000131' at position 471157588 080428 14:38:06 [ERROR] Error reading packet from server: Out of memory (Needed 3464 bytes) ( server_errno=5) 080428 14:38:06 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'SRV02-bin.000131' position 583864714 080428 14:38:06 [Note] Slave: connected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'SRV02-bin.000131' at position 583864714 080428 15:13:24 [ERROR] Error reading packet from server: Out of memory (Needed 3128 bytes) ( server_errno=5) 080428 15:13:24 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'SRV02-bin.000131' position 635409380 080428 15:13:24 [Note] Slave: connected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'SRV02-bin.000131' at position 635409380 080428 15:32:14 [ERROR] Error reading packet from server: Out of memory (Needed 2688 bytes) ( server_errno=5) 080428 15:32:14 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'SRV02-bin.000131' position 665146758 080428 15:32:14 [Note] Slave: connected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'SRV02-bin.000131' at position 665146758 Regards Dominik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Antes de imprimir este e-mail piense bien si es necesario hacerlo. Antes de imprimir este e-mail piense bien si es necesario hacerlo. * Este mensaje es privado y CONFIDENCIAL y se dirige exclusivamente a su destinatario. Si usted ha recibido este mensaje por error, no debe revelar, copiar, distribuir o usarlo en ningún sentido. Le rogamos lo comunique al remitente y borre dicho mensaje y cualquier documento adjunto que pudiera contener. El correo electrónico via Internet no permite asegurar la confidencialidad de los mensajes que se transmiten ni su integridad o correcta recepción. JAZZTEL no asume responsabilidad por estas circunstancias. Si el destinatario de este mensaje no consintiera la utilización del correo electrónico via Internet y la grabación de los mensajes, rogamos lo ponga en nuestro conocimiento de forma inmediata.Cualquier opinión expresada en este mensaje pertenece únicamente al autor remitente, y no representa necesariamente la opinión de JAZZTEL, a no ser que expresamente se diga y el remitente esté autorizado para hacerlo. * This message is private and CONFIDENTIAL and it is intended exclusively for its addressee. If you receive this message in error, you should not disclose, copy, distribute this e-mail or use it in any other way. Please inform the sender and delete the message and attachments from your system.Internet e-mail neither guarantees the confidentiality nor the integrity or proper receipt of the messages sent. JAZZTEL does not assume any liability for those
RE: Optimal MySQL server -- opinions?
Hi, My experience shows me that RAM and disk is fundamental for any database, especially MySQL. As much IO load, much more disk preading you have to take with. Personally, i have 2 databases with 11 millions Inserts / day (2GB / day), so my advise is that you spend as much money as you can in SAN disks, or similar (fiber, attached SCSI, etc). I have it on a 6G Poweredge 1855, 2 Xeon dual processors (my bottleneck is obviously disk I/O). The other counterpart is that if you can put the entire databases on RAM, your disk needs are not so high. So if you can afford that. Regards. -Mensaje original- De: Rene Fournier [mailto:[EMAIL PROTECTED] Enviado el: domingo 27 de abril de 2008 23:57 Para: mysql@lists.mysql.com Asunto: Optimal MySQL server -- opinions? Okay, the previous subject was too narrow, what I am really looking for are opinions on general disk/memory/cpu configurations, manufacturer notwithstanding... As stated previously, I'm configuring a PowerEdge 2950III, and trying to decide what will provide the best bang-for-buck. The server will be used strictly as a MySQL database server running atop Red Hat Linux. Two large databases, each about 2GB, heavy on both Inserts and Selects. Up until recently, I had spec'd: 2 x Quad-Core Xeon 5430 @ 2.66 GHz (6 MB cache) , 1333 MHz FSB 8 GB Ram (4x2GB) 4 x 146 GB 15K SAS drives (RAID 1/1 -- first set for OS, apps, second set for MySQL data) ...worked out to around $5,500. Now however there is a processor promotion, such that: 1 x Quad-Core Xeon 5450 @ 3.0 GHz (6 MB cache) , 1333 MHz FSB 8 GB Ram (4x2GB) 4 x 146 GB 15K SAS drives (RAID 1/1 -- first set for OS, apps, second set for MySQL data) ...works out to around $4,500. So what I'm wondering is, do I really need an eight-core box, since my experience tells me that MySQL's greatest bottleneck is disk I/O. I'm wondering if I would be better off with just one processor to start with (are they easy to add later, btw?), maybe add more RAM, and just save some cash. Any thoughts or suggestions are much appreciated. I have to pull the trigger on this soon. I was hoping they would bump the specs or drop the prices significantly... I've been watching these for months and there's been promo after promo... I anticipate a major update, has anyone heard anything? (Should I wait a little longer maybe?) Thanks. ...Rene Antes de imprimir este e-mail piense bien si es necesario hacerlo. Antes de imprimir este e-mail piense bien si es necesario hacerlo. * Este mensaje es privado y CONFIDENCIAL y se dirige exclusivamente a su destinatario. Si usted ha recibido este mensaje por error, no debe revelar, copiar, distribuir o usarlo en ningun sentido. Le rogamos lo comunique al remitente y borre dicho mensaje y cualquier documento adjunto que pudiera contener. El correo electronico via Internet no permite asegurar la confidencialidad de los mensajes que se transmiten ni su integridad o correcta recepcion. JAZZTEL no asume responsabilidad por estas circunstancias. Si el destinatario de este mensaje no consintiera la utilizacion del correo electronico via Internet y la grabacion de los mensajes, rogamos lo ponga en nuestro conocimiento de forma inmediata.Cualquier opinion expresada en este mensaje pertenece unicamente al autor remitente, y no representa necesariamente la opinion de JAZZTEL, a no ser que expresamente se diga y el remitente este autorizado para hacerlo. * This message is private and CONFIDENTIAL and it is intended exclusively for its addressee. If you receive this message in error, you should not disclose, copy, distribute this e-mail or use it in any other way. Please inform the sender and delete the message and attachments from your system.Internet e-mail neither guarantees the confidentiality nor the integrity or proper receipt of the messages sent. JAZZTEL does not assume any liability for those circumstances. If the addressee of this message does not consent to the use of Internet e-mail and message recording, please notify us immediately.Any views or opinions contained in this message are solely those of the author, and do not necessarily represent those of JAZZTEL, unless otherwise specifically stated and the sender is authorised to do so. * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Performance problem
New queries, tuning the insert (DELAYED) we make on the database. The clients have not to wait to the io response of the thread of the database that inserts the data and the repl data. -Mensaje original- De: Tim McDaniel [mailto:[EMAIL PROTECTED] Enviado el: viernes 18 de abril de 2008 17:34 CC: mysql@lists.mysql.com Asunto: RE: Performance problem On Fri, 18 Apr 2008, Francisco Rodrigo Cortinas Maseda <[EMAIL PROTECTED]> wrote: > > im new on the performance tuning of this database (MySQL 5.0.45, > > rpm-based installation), and i have one performance problem on our > > new installation: ... > > We are experiencing problems about the performance of the database, > > in the way that we are seeing that the radius clients are seeing the > > radius servers gone away for the acct service. > > I`ve resolved my problems without hardware manipulation. Me, I'd not like to see much technical detail, but I'm curious now: what sorts of things did you do? Restructuring, different queries, what? -- Tim McDaniel, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Antes de imprimir este e-mail piense bien si es necesario hacerlo. Antes de imprimir este e-mail piense bien si es necesario hacerlo. * Este mensaje es privado y CONFIDENCIAL y se dirige exclusivamente a su destinatario. Si usted ha recibido este mensaje por error, no debe revelar, copiar, distribuir o usarlo en ningun sentido. Le rogamos lo comunique al remitente y borre dicho mensaje y cualquier documento adjunto que pudiera contener. El correo electronico via Internet no permite asegurar la confidencialidad de los mensajes que se transmiten ni su integridad o correcta recepcion. JAZZTEL no asume responsabilidad por estas circunstancias. Si el destinatario de este mensaje no consintiera la utilizacion del correo electronico via Internet y la grabacion de los mensajes, rogamos lo ponga en nuestro conocimiento de forma inmediata.Cualquier opinion expresada en este mensaje pertenece unicamente al autor remitente, y no representa necesariamente la opinion de JAZZTEL, a no ser que expresamente se diga y el remitente este autorizado para hacerlo. * This message is private and CONFIDENTIAL and it is intended exclusively for its addressee. If you receive this message in error, you should not disclose, copy, distribute this e-mail or use it in any other way. Please inform the sender and delete the message and attachments from your system.Internet e-mail neither guarantees the confidentiality nor the integrity or proper receipt of the messages sent. JAZZTEL does not assume any liability for those circumstances. If the addressee of this message does not consent to the use of Internet e-mail and message recording, please notify us immediately.Any views or opinions contained in this message are solely those of the author, and do not necessarily represent those of JAZZTEL, unless otherwise specifically stated and the sender is authorised to do so. * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Performance problem
I`ve resolved my problems without hardware manipulation. Thanks to all. -Mensaje original- De: Francisco Rodrigo Cortinas Maseda Enviado el: miércoles 16 de abril de 2008 18:57 Para: mysql@lists.mysql.com Asunto: RV: Performance problem Hi all, im new on the performance tuning of this database (MySQL 5.0.45, rpm-based installation), and i have one performance problem on our new installation: - The radius servers (that are written on perl) we have are writing the auth and acct log to one mysql database. The conn we have is an TCPIP conn. - We have two databases, one for auth data and another for acct data. - We have one table for each day on each database, on which we insert the auth and acct data. We also have three indexes on each table, that occupy almost 300M per day. - The volume of traffic is nearly 10 million rows per day. - The partition of the database is mounted on a LVM partition of a RAID1 disk. We are experiencing problems about the performance of the database, in the way that we are seeing that the radius clients are seeing the radius servers gone away for the acct service. The server of the database is a Dell Poweredge 1855 with 6 GB of RAM and RHEL4. We have modified the variables of the database with: SET GLOBAL thread_cache_size=8; SET GLOBAL table_cache=256; set GLOBAL max_connections=200; set GLOBAL key_buffer_size=1610416128; set GLOBAL read_buffer_size=524288; set GLOBAL read_rnd_buffer_size=1048576; SET GLOBAL delayed_insert_limit=400; SET GLOBAL delayed_queue_size=12000; SET GLOBAL net_buffer_length=32768; The queries that we are doing are: INSERT DELAYED IGNORE () VALUES (); Originally, the server has 2GB of RAM, but seeing this problems, we have installed another 4 GB of RAM. From the statistics of vmstat we see that we are suffering som IO bottleneck (i think): procs ---memory-- ---swap-- -io --system-- cpu r b swpd free buff cache si sobibo incs us sy id wa 0 4 0 4280956 40144 139245600 014 1853 1180 1 0 48 50 0 3 0 4279932 40152 139348800 010 1882 1258 2 0 42 56 0 3 0 4279908 40172 139450800 0 2052 1861 1202 2 1 45 52 0 4 0 4276452 40192 139552800 0 9179 1850 1164 2 1 66 31 1 3 0 4274748 40200 139630000 0 7 1957 1337 2 1 64 34 0 4 0 4272956 40212 139732800 024 1926 1283 2 1 41 56 0 3 0 4271484 40224 139861600 026 1906 1250 2 1 32 66 0 3 0 4270204 40228 139965200 0 9 1855 1154 2 0 24 74 0 3 0 4268924 40236 140016400 010 1852 1144 2 0 24 74 1 4 0 4267516 40248 140145200 013 2063 1480 2 1 27 71 0 3 0 4264476 40280 140272000 0 11134 1965 1363 2 1 49 48 0 4 0 4262772 40300 140374000 013 1971 1382 2 0 60 37 0 4 0 4261372 40316 140476400 015 1875 1213 2 1 46 52 0 3 0 4260028 40328 140553200 014 1831 1152 2 0 48 50 The "wa" column shows a quite large number, so we think that it is an IO bottleneck. The question is: ¿ has anybody have seesomething similar? ¿has anybody an idea about how to resolve this problem? Thanks. Antes de imprimir este e-mail piense bien si es necesario hacerlo. * Este mensaje es privado y CONFIDENCIAL y se dirige exclusivamente a su destinatario. Si usted ha recibido este mensaje por error, no debe revelar, copiar, distribuir o usarlo en ningún sentido. Le rogamos lo comunique al remitente y borre dicho mensaje y cualquier documento adjunto que pudiera contener. El correo electrónico via Internet no permite asegurar la confidencialidad de los mensajes que se transmiten ni su integridad o correcta recepción. JAZZTEL no asume responsabilidad por estas circunstancias. Si el destinatario de este mensaje no consintiera la utilización del correo electrónico via Internet y la grabación de los mensajes, rogamos lo ponga en nuestro conocimiento de forma inmediata.Cualquier opinión expresada en este mensaje pertenece únicamente al autor remitente, y no representa necesariamente la opinión de JAZZTEL, a no ser que expresamente se diga y el remitente esté autorizado para hacerlo. * This message is private and CONFIDENTIAL and it is intended exclusively for its addressee. If you receive this message in error, you should not disclose, copy, distribute this e-mail or use it in any other way. Please inform the sender and delete the message and attachments from your system.Internet e-mail neither guarantees the confidentiality nor the integrity or proper receipt of the messages sent. JAZZTEL does not assume any liability for those circumstances. If the addressee of this message does not consent to the use of Internet e-mail and message recording, ple
RV: Performance problem
Hi all, im new on the performance tuning of this database (MySQL 5.0.45, rpm-based installation), and i have one performance problem on our new installation: - The radius servers (that are written on perl) we have are writing the auth and acct log to one mysql database. The conn we have is an TCPIP conn. - We have two databases, one for auth data and another for acct data. - We have one table for each day on each database, on which we insert the auth and acct data. We also have three indexes on each table, that occupy almost 300M per day. - The volume of traffic is nearly 10 million rows per day. - The partition of the database is mounted on a LVM partition of a RAID1 disk. We are experiencing problems about the performance of the database, in the way that we are seeing that the radius clients are seeing the radius servers gone away for the acct service. The server of the database is a Dell Poweredge 1855 with 6 GB of RAM and RHEL4. We have modified the variables of the database with: SET GLOBAL thread_cache_size=8; SET GLOBAL table_cache=256; set GLOBAL max_connections=200; set GLOBAL key_buffer_size=1610416128; set GLOBAL read_buffer_size=524288; set GLOBAL read_rnd_buffer_size=1048576; SET GLOBAL delayed_insert_limit=400; SET GLOBAL delayed_queue_size=12000; SET GLOBAL net_buffer_length=32768; The queries that we are doing are: INSERT DELAYED IGNORE () VALUES (); Originally, the server has 2GB of RAM, but seeing this problems, we have installed another 4 GB of RAM. From the statistics of vmstat we see that we are suffering som IO bottleneck (i think): procs ---memory-- ---swap-- -io --system-- cpu r b swpd free buff cache si sobibo incs us sy id wa 0 4 0 4280956 40144 139245600 014 1853 1180 1 0 48 50 0 3 0 4279932 40152 139348800 010 1882 1258 2 0 42 56 0 3 0 4279908 40172 139450800 0 2052 1861 1202 2 1 45 52 0 4 0 4276452 40192 139552800 0 9179 1850 1164 2 1 66 31 1 3 0 4274748 40200 139630000 0 7 1957 1337 2 1 64 34 0 4 0 4272956 40212 139732800 024 1926 1283 2 1 41 56 0 3 0 4271484 40224 139861600 026 1906 1250 2 1 32 66 0 3 0 4270204 40228 139965200 0 9 1855 1154 2 0 24 74 0 3 0 4268924 40236 140016400 010 1852 1144 2 0 24 74 1 4 0 4267516 40248 140145200 013 2063 1480 2 1 27 71 0 3 0 4264476 40280 140272000 0 11134 1965 1363 2 1 49 48 0 4 0 4262772 40300 140374000 013 1971 1382 2 0 60 37 0 4 0 4261372 40316 140476400 015 1875 1213 2 1 46 52 0 3 0 4260028 40328 140553200 014 1831 1152 2 0 48 50 The "wa" column shows a quite large number, so we think that it is an IO bottleneck. The question is: ¿ has anybody have seesomething similar? ¿has anybody an idea about how to resolve this problem? Thanks. Antes de imprimir este e-mail piense bien si es necesario hacerlo. * Este mensaje es privado y CONFIDENCIAL y se dirige exclusivamente a su destinatario. Si usted ha recibido este mensaje por error, no debe revelar, copiar, distribuir o usarlo en ningún sentido. Le rogamos lo comunique al remitente y borre dicho mensaje y cualquier documento adjunto que pudiera contener. El correo electrónico via Internet no permite asegurar la confidencialidad de los mensajes que se transmiten ni su integridad o correcta recepción. JAZZTEL no asume responsabilidad por estas circunstancias. Si el destinatario de este mensaje no consintiera la utilización del correo electrónico via Internet y la grabación de los mensajes, rogamos lo ponga en nuestro conocimiento de forma inmediata.Cualquier opinión expresada en este mensaje pertenece únicamente al autor remitente, y no representa necesariamente la opinión de JAZZTEL, a no ser que expresamente se diga y el remitente esté autorizado para hacerlo. * This message is private and CONFIDENTIAL and it is intended exclusively for its addressee. If you receive this message in error, you should not disclose, copy, distribute this e-mail or use it in any other way. Please inform the sender and delete the message and attachments from your system.Internet e-mail neither guarantees the confidentiality nor the integrity or proper receipt of the messages sent. JAZZTEL does not assume any liability for those circumstances. If the addressee of this message does not consent to the use of Internet e-mail and message recording, please notify us immediately.Any views or opinions contained in this message are solely those of the author, and do not necessarily represent those of JAZZTEL, unless otherwise specifically stated and the sender is authorised to do so. *
Daniel Whitener still in list?
Hi there I checked your post at http://lists.mysql.com/mysql/166873 I'm with some troubles with Multiple Query and error 2013 (lost connection). Can u gimme some help?? 10ks Franz - Francisco Bischoff ICQ#: 1891104 Current ICQ status: + More ways to contact me i See more about me: - ___ Yahoo! doce lar. Faça do Yahoo! sua homepage. http://br.yahoo.com/homepageset.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: confirm subscribe to mysql@lists.mysql.com
On Friday 13 May 2005 14:54, [EMAIL PROTECTED] wrote: > To confirm that you would like > > [EMAIL PROTECTED] > > added to the mysql mailing list, please click on > the following link: > > http://lists.mysql.com/s/mysql/4284b19ec06544bb/santiagocapel=yahoo.es > > This confirmation serves two purposes. First, it verifies that we are > able to get mail through to you. Second, it protects you in case > someone forges a subscription request in your name. > > > --- Administrative commands for the mysql list --- > > I can handle administrative requests automatically. Please > do not send them to the list address! Instead, send > your message to the correct command address: > > For help and a description of available commands, send a message to: ><[EMAIL PROTECTED]> > > To subscribe to the list, send a message to: ><[EMAIL PROTECTED]> > > To remove your address from the list, just send a message to > the address in the ``List-Unsubscribe'' header of any list > message. If you haven't changed addresses since subscribing, > you can also send a message to: ><[EMAIL PROTECTED]> > > or for the digest to: ><[EMAIL PROTECTED]> > > For addition or removal of addresses, I'll send a confirmation > message to that address. When you receive it, simply reply to it > to complete the transaction. > > If you need to get in touch with the human owner of this list, > please send a message to: > > <[EMAIL PROTECTED]> > > Please include a FORWARDED list message with ALL HEADERS intact > to make it easier to help you. > > --- Enclosed is a copy of the request I received. > > Received: (qmail 22439 invoked by uid 48); 13 May 2005 13:54:38 - > Date: 13 May 2005 13:54:38 - > Message-ID: <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Unsubscribe request > From: <[EMAIL PROTECTED]> > > This message was generated because of a request from 217.35.111.1. -- Tengo que cambiar mi firma - Francisco Santiago Capel Torres [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 5.0.2 alpha crashes with Query Browser
that pretty much explains why it's been happening ;) Thanks :) On Thu, 17 Mar 2005 22:34:08 +0100, Martijn Tonies <[EMAIL PROTECTED]> wrote: > Francisco, > > > Maybe it's my setup... but: > > > > whenever I try to login to use the mySQL query browser, it instantlly > > turns off the 5.0.2 alpha mySQL instance (stops running). the error I > > get is: > > > > mysqld-max-nt.exe - Application Error > > > > the instruciton at "0x00538d34" referenced memory at "0x007f9000". The > > memory could not be "read". > > > > Running Win2k pro w/ 512mb of ram. > > 5.0.2 will crash on pretty much everything. > > It does seem that starting the server works, but that's about it :-) > > With regards, > > Martijn Tonies > Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL > Server > Upscene Productions > http://www.upscene.com > > -- -Francisco http://pcthis.blogspot.com | PC news with out the jargon! http://sqlthis.blogspot.com | Tsql and More... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
5.0.2 alpha crashes with Query Browser
Maybe it's my setup... but: whenever I try to login to use the mySQL query browser, it instantlly turns off the 5.0.2 alpha mySQL instance (stops running). the error I get is: mysqld-max-nt.exe - Application Error the instruciton at "0x00538d34" referenced memory at "0x007f9000". The memory could not be "read". Running Win2k pro w/ 512mb of ram. -- -Francisco http://pcthis.blogspot.com | PC news with out the jargon! http://sqlthis.blogspot.com | Tsql and More... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Wrong bytesec nightmare!
Hello all, I am getting quite desperate on this, since I've been trying to recover my diary of a whole year of travelling which was stored in a MyISAM table for a couples of weeks now! The MySQL server was running in a XP machine and suddenly the hard disk crashed starting my particular nightmare. I had to use recovery tools to scan the disk and I thought I was saved when I found the *.frm, *.MYI and *.MYD files and was able to recover them, but when I tried get the tables back into MySQL and backup their contents, I found a series of errors that have kept me down ever since! The first complain I got when I selected the table was: Didn't find any fields in table 'news' I then checked the table for errors, and got: mysql> check table news; +--+---+-- +-+ | Table| Op| Msg_type | Msg_text | +--+---+-- +-+ | ver.news | check | error| Incorrect information in file: './ver/news.frm' | +--+---+-- +-+ 1 row in set (0.03 sec) I checked it with myisamchk and got: Curro:/usr/local/mysql/bin root# ./myisamchk ../data/ver/news myisamchk: error: '../data/ver/news' is not a MyISAM-table I was reading the manual and since I had the description of the original tables, I created new tables with the same structure and used the *.frm files. With myisamchk I got the same error, but with CHECK TABLE the error changed and got: mysql> check table news; +--+---+-- +--+ | Table| Op| Msg_type | Msg_text | +--+---+-- +--+ | ver.news | check | error| Can't open file: 'news.MYI' (errno: 130) | +--+---+-- +--+ 1 row in set (0.01 sec) Which meant I guess, the file is corrupted: MySQL error: 130 = Incorrect file format I then used the new *.MYI and got the following errors: Curro:/usr/local/mysql/bin root# ./myisamchk ../data/ver/news Checking MyISAM file: ../data/ver/news Data records: 0 Deleted blocks: 0 - check file-size myisamchk: warning: Size of datafile is: 848484 Should be: 0 - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links myisamchk: error: Wrong bytesec: 154-126-101 at linkstart: 0 MyISAM-table '../data/ver/news' is corrupted Fix it using switch "-r" or "-o" mysql> check table news; +--+---+-- ++ | Table| Op| Msg_type | Msg_text | +--+---+-- ++ | ver.news | check | warning | Size of datafile is: 848484 Should be: 0 | | ver.news | check | error| Wrong bytesec: 154-126-101 at linkstart: 0 | | ver.news | check | error| Corrupt | +--+---+-- ++ 3 rows in set (0.10 sec) I searched the web to try to find a fix but I couldn't find any solved problem similar to this, with the Wrong bytesec at linkstart 0. I tried to repair the tables, and both the REPAIR TABLE and the myisamchk repairs using the newly created .frm and .MYI files resulted in an empty set, a truncated data file. I also tried with REPAIR TABLE .. USE_FRM with no luck, always complaining first of the 'Wrong bytesec' and then finding the blocks either that point outside data file or too small. Here is an extract of the result: mysql> repair table news USE_FRM; +--++-- +--- ---+ | Table| Op | Msg_type | Msg_text | +--++-- +--- ---+ | ver.news | repair | info | Wrong bytesec: 154-126-101 at 0; Skipped | | ver.news | repair | info | Found block that points outside data file at 488 | | ver.news | repair | info | Found block that points outside data file at 544 | | ver.news | repair | info | Found block with too small length at 896; Skipped| | ver.news | repair | info | Found block with too small length at 1120; Skipped | | ver.news | repair | info | Found link that points at -4170694140902777944 (outside data file) at 1148 | | ver.news | repair | info | Found block that points out
Re: Recover registers afected by UPDATE
Egor Egorov wrote: Francisco Ivan Anton Prieto <[EMAIL PROTECTED]> wrote: I am crazy with a problem. I would like to know the best method to SELECT affected rows after an UPDATE. If you set column values to the new (different from current value), you can just use the same WHERE clause in the SELECT statement. UPDATE table SET a=1 WHERE a=0 LIMIT 2; SELECT * FROM table WHERE a=1 ->doesn't work because column a have rows with value '1' before UPDATE I have the next idea : query("LOCK TABLES table"); // HERE RETRIEVE ROWS I WILL UPDATE result = query(SELECT * FROM table WHERE a=0 LIMIT 2); // HERE I UPDATE ROWS query("UPDATE table SET a=1 WHERE WHERE a=0 LIMIT 2"); query("UNLOCK TABLES"); This would work fine??? Is there a better way? I use SELECT...FOR UPDATE and it seems does not work. I'll wait your comments. Thanks for your time -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Recover registers afected by UPDATE
I am crazy with a problem. I would like to know the best method to SELECT affected rows after an UPDATE. Thanks to all by your help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Permissions
You could use views but they will not be available until version 5 or 5.1 In the doc you can find : Views are useful for allowing users to access a set of relations (tables) as if it were a single table, and limiting their access to just that. Views can also be used to restrict access to rows (a subset of a particular table). One does not require views to restrict access to columns, as MySQL Server has a sophisticated privilege system. See section 5.4 The MySQL Access Privilege System (http://www.mysql.com/doc/en/Privilege_system.html). Maybe this could help you Francisco -Original Message- From: Manuele [mailto:[EMAIL PROTECTED] Sent: Thursday, February 26, 2004 5:44 PM To: [EMAIL PROTECTED] Subject: Permissions Hello, I'd like to apologize, I know what I am asking is probably impossibile, but I would like to know if someone has a way to set up permissions on a row basis, for example if a certain condition matches (for example, grant select on row if columnA is NULL). Anyone has any idea on how to do so? I wouldn't like to devolve this to the application, as users will have a mysql username/password and they MIGHT directly connect to the db. Thanks in advance. -- Manuele - This mail sent through IMP: http://horde.org/imp/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ERROR 2003: Can't connect to MySQL server on ....
Hi: Thanx for the response. But yes the "ZEUS.OLYMPUS.LOCAL" host is in the mysql.user database for the user root. There are 2 entries for the root user, one for [EMAIL PROTECTED] and one fore [EMAIL PROTECTED] and they both have the same global privileges set to ALL. I think that I have to add the IP address as an allowed host though, but I thought that the mySQL server could resolve the IP to the host name? Thanx! -Original Message- From: O'K Web Design [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 8:06 AM To: Francisco Castellon Subject: Re: ERROR 2003: Can't connect to MySQL server on Hi I am not an expert but I would make all root privileges global and make sure you are allowing log in's by root into any host. It just sounds like "ZEUS.OLYMPUS.LOCAL" is not on your allowed list. As far as my understanding goes, if you are resolving an address, then it would try to connect using the 'not' local method. Mike - Original Message - From: "Francisco Castellon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: June 5, 2003 2:40 AM Subject: ERROR 2003: Can't connect to MySQL server on > Hello list: > > Just finished installing mySQL on a Linux Debian system and I have a > question about how the 2 root users that are set up by default. When I > look at my user table there is a root user allowed to log in from > "localhost" and also another root user but this one is only allowed to > log in from "host.mydomain.com" (host being the computer that the mySQL > server is installed in). I understand the difference since localhost is > when you are working on the computer itself (or remotely through ssh) > that has the mySQl server installed and that HOST.MYDOMAIN.COM is the > name of the localhost machine on the LAN. However, if you are accessing > the mySQL server from HOST.MYDOMAIN.COM isn't that technically the same > thing as accessing from localhost? since in order to access the mySQL > server from HOST.MYDOMAIN.COM I would have to be at the machine itself > wouldn't the server just treat that connection as localhost? I have read > on the mysql.com site about how the mySQL server sorts the entries in > the user table at the time the server is started by priority of specific > entries to less specific ones, however if I have a password set for both > [EMAIL PROTECTED] and [EMAIL PROTECTED] then which connection would be > used? Not that it matters since the set of privileges are the same. I am > just really wondering if I need the extra entry of > [EMAIL PROTECTED] when I already have [EMAIL PROTECTED] And how would > I ever connect to the mySQL server using the [EMAIL PROTECTED] > account? > > Also I was trying to access the mySQL server using the root@ > HOST.MYDOMAIN.COM account by using the command below: > > Shell> mysql -u root -h ZEUS.OLYMPUS.LOCAL -p > Enter Password: *** > > And this is what I get: ERROR 2003: Can't connect to MySQL server on > 'ZEUS.OLYMPUS.LOCAL' (111) > > I also tried using the IP of the server: > Shell> mysql -u root -h 192.168.1.8 -p > Enter Password: *** > > And I still got: ERROR 2003: Can't connect to MySQL server on > '192.168.1.8' (111) > > What does that mean? I tried searching on the list archives but found > nothing on it. And I did check my /etc/hosts file and this is what is in > it: > > 127.0.0.1 localhost > 192.168.1.8 ZEUS.OLYMPUS.LOCAL ZEUS > > Any help would be appreciated it, thanx! > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2003: Can't connect to MySQL server on ....
Hello list: Just finished installing mySQL on a Linux Debian system and I have a question about how the 2 root users that are set up by default. When I look at my user table there is a root user allowed to log in from "localhost" and also another root user but this one is only allowed to log in from "host.mydomain.com" (host being the computer that the mySQL server is installed in). I understand the difference since localhost is when you are working on the computer itself (or remotely through ssh) that has the mySQl server installed and that HOST.MYDOMAIN.COM is the name of the localhost machine on the LAN. However, if you are accessing the mySQL server from HOST.MYDOMAIN.COM isn't that technically the same thing as accessing from localhost? since in order to access the mySQL server from HOST.MYDOMAIN.COM I would have to be at the machine itself wouldn't the server just treat that connection as localhost? I have read on the mysql.com site about how the mySQL server sorts the entries in the user table at the time the server is started by priority of specific entries to less specific ones, however if I have a password set for both [EMAIL PROTECTED] and [EMAIL PROTECTED] then which connection would be used? Not that it matters since the set of privileges are the same. I am just really wondering if I need the extra entry of [EMAIL PROTECTED] when I already have [EMAIL PROTECTED] And how would I ever connect to the mySQL server using the [EMAIL PROTECTED] account? Also I was trying to access the mySQL server using the root@ HOST.MYDOMAIN.COM account by using the command below: Shell> mysql -u root -h ZEUS.OLYMPUS.LOCAL -p Enter Password: *** And this is what I get: ERROR 2003: Can't connect to MySQL server on 'ZEUS.OLYMPUS.LOCAL' (111) I also tried using the IP of the server: Shell> mysql -u root -h 192.168.1.8 -p Enter Password: *** And I still got: ERROR 2003: Can't connect to MySQL server on '192.168.1.8' (111) What does that mean? I tried searching on the list archives but found nothing on it. And I did check my /etc/hosts file and this is what is in it: 127.0.0.1 localhost 192.168.1.8 ZEUS.OLYMPUS.LOCAL ZEUS Any help would be appreciated it, thanx!
ERROR 2003: Can't connect to MySQL server on ....
Hello list: Just finished installing mySQL on a Linux Debian system and I have a question about how the 2 root users that are set up by default. When I look at my user table there is a root user allowed to log in from "localhost" and also another root user but this one is only allowed to log in from "host.mydomain.com" (host being the computer that the mySQL server is installed in). I understand the difference since localhost is when you are working on the computer itself (or remotely through ssh) that has the mySQl server installed and that HOST.MYDOMAIN.COM is the name of the localhost machine on the LAN. However, if you are accessing the mySQL server from HOST.MYDOMAIN.COM isn't that technically the same thing as accessing from localhost? since in order to access the mySQL server from HOST.MYDOMAIN.COM I would have to be at the machine itself wouldn't the server just treat that connection as localhost? I have read on the mysql.com site about how the mySQL server sorts the entries in the user table at the time the server is started by priority of specific entries to less specific ones, however if I have a password set for both [EMAIL PROTECTED] and [EMAIL PROTECTED] then which connection would be used? Not that it matters since the set of privileges are the same. I am just really wondering if I need the extra entry of [EMAIL PROTECTED] when I already have [EMAIL PROTECTED] And how would I ever connect to the mySQL server using the [EMAIL PROTECTED] account? Also I was trying to access the mySQL server using the root@ HOST.MYDOMAIN.COM account by using the command below: Shell> mysql -u root -h ZEUS.OLYMPUS.LOCAL -p Enter Password: *** And this is what I get: ERROR 2003: Can't connect to MySQL server on 'ZEUS.OLYMPUS.LOCAL' (111) I also tried using the IP of the server: Shell> mysql -u root -h 192.168.1.8 -p Enter Password: *** And I still got: ERROR 2003: Can't connect to MySQL server on '192.168.1.8' (111) What does that mean? I tried searching on the list archives but found nothing on it. And I did check my /etc/hosts file and this is what is in it: 127.0.0.1 localhost 192.168.1.8 ZEUS.OLYMPUS.LOCAL ZEUS Any help would be appreciated it, thanx!
BUG REPORT MYSQL WITH NSS_LDAP
Hello. I'd like to report a bug I've found with MySQL. MySQL, as shipped with Mandrake 9, gets hanged when starting it with safe_mysqld or service mysql start or /etc/rc.d/init.d/mysql ALWAYS WHEN NSS_LDAP IS ENABLED! I'd like to report this so that you can try if it's a bug from mysql or mandrake9 by trying it on other systems... I guess it's a mysql bug as nss_ldap is very standard and used worldwide. Thank you -- Francisco A. Lozano Factory Web - I+D Tlf: 902 365 055 http://www.factoryw.com Error 152. Windows no encontrado. ¿(A)legrarse, (B)ailar, (F)iesta? - Servicios de Correo de Factory Web http://www.factoryw.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: Where does MySQL store db files?
Hi, You can check that if the server is running by executing this: Show variables like "datadir%" from mysql. Bye, --- Robert Citek <[EMAIL PROTECTED]> wrote: > > At 05:35 AM 12/10/2002 -0800, tmb wrote: > >1 - On a Linux/Apache box, > >when you create a MySQL db with tables, etc, > >Where does MySQL store the files associated with > the > >db? > > If the database is named foobar, then usually in > /var/lib/mysql/foobar > > >2 - On subsiquent db's, does MySQL store those > files > >in the same directory or each db in a seperate > folder? > > New folder, for example /var/lib/mysql/new_db > > Regards, > - 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 > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Wrong port is shutdown with several mysql(s) running in Win.
Hello, I have several mysql 3.23 daemons running in a Windows XP Professional computer. To achieve this, I have run the following commands: mysqld-opt --basedir=C:\mysql --datadir="C:\mydb\data1" --port=3020 --standalone --default-table-type=MyISAM --tmpdir="C:\mydb\temp1" mysqld-opt --basedir=C:\mysql --datadir="C:\mydb\data2" --port=3021 --standalone --default-table-type=MyISAM --tmpdir="C:\mydb\temp2" mysqld-opt --basedir=C:\mysql --datadir="C:\mydb\data3" --port=3022 --standalone --default-table-type=MyISAM --tmpdir="C:\mydb\temp3" After running these three commands from three different ms-dos windows, I have three mysql running in ports 3020, 3021, and 3022. Now from another ms-dos windows, I execute: mysqladmin --port=3022 shutdown This command should shutdown the mysql running on 3022 but it shutdown 3020 instead. I try again: mysqladmin --port=3022 shutdown And 3021 is shutdown instead of 3022. I have concluded that there is a possible bug which always shutdown in the order of creation no matter which port you specify. I have tried the same thing in the newest version: 4.04 and it does not happen. 4.04 shutdown the port correctly. Any thoughts? Thanks. __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query problem
Change your query for: select red,green,blue from colorchanger INNER JOIN jobattributekit ON colorcode = value where attributekit = "Color" and jobnumber = "28200124RB4-001" and scenario="JN75K"; Also remember that MySQL does not allow sub-queries. --- Amit Lonkar <[EMAIL PROTECTED]> wrote: > Hi all > Does mysql support simple joins? > > I am trying to run the following query:- > > select red,green,blue from colorchanger where > colorcode = select value from jobattributekit where > attributekit = "Color" and jobnumber = > "28200124RB4-001" and scenario="JN75K"; > > ColorChanger Table:- > ColorCode ColorRedGreenBlue > STBBLUE 58 110 165 > > JOBATTRIBUTEKIT Table:- > Jobnumber AttributekitValueScenario > 28200124RB4-001 Color STB JN75K > > > The error that it gives is :- > ERROR 1064: You have an error in your SQL syntax > near > 'select value from jobattr > ibutekit where attributekit = "Color" and jobnumber > = > "' at line 1 > > Thanks > Amit > > > > > > > > > __ > Do You Yahoo!? > HotJobs - Search Thousands of New Jobs > http://www.hotjobs.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 > __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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: generating random integer id
Hi, If you are generating the id yourself a good strategy is to use UUID that are "guaranteed" to be "universally" unique. If you are developing for the Microsoft platform, there is an API functions that returns you a UUID and this number is guaranteed to be unique. If you are working in Java, you can download the source code of a UUID generator. Bye, --- Tom Gao <[EMAIL PROTECTED]> wrote: > hi guys, > > I'm trying to generate randomly a number as the > primary key the key is to > be an integer in mysql. So like auto_increment I can > insert values and the > pk can be generated automatically. > > could someone point me to the right direction > please > > thanks > Tom > > > > - > 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 > __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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: MySQL vs. Oracle (not speed)
Hi Mary, I am not specially against or pro MySQL, Microsoft SQL Server, Oracle or any other database. Teams make their choices based on the project needs such as budget (is your team ready to spend thousands of dollars on Oracle and marry that corporation forever?), deployment (do you want your product with Oracle's price tag attached to it?), functionality: does the database server provide a viable solution technically speaking?, etc, etc. So it is not an issue of good or bad. But regardless of all that, what we should have, at least, is a great respect for people that has been working so hard to provide an affordable and viable alternative to the database server giants. I don't think that throwing those numbers without any other explanations about your test environments, SQL, tables, etc is a good practice. Do you think that you always get what you pay when you spend thousand of dollars in software and services without leaving you any other choices? I know that you did not put bad intentions behind your comment but should be more careful and precise. Whoever is interested on some benchmarks can go to: http://www.mysql.com/information/benchmarks.html There is an interesting article comparing Ms-SQL, Oracle, DB2 and MySQL in: http://www.pcmag.com/article2/0,4149,7279,00.asp Sincerely, Francisco --- Mary Stickney <[EMAIL PROTECTED]> wrote: > > I have been doing speed tests the same query > ran on MYSQL took 45 > minutes > on MS-SQL it took 11 minutes.. > > yes you do get what you pay for > > -Original Message- > From: Francisco [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 16, 2002 8:47 AM > To: Mary Stickney; Elizabeth Bogner; > [EMAIL PROTECTED] > Subject: RE: MySQL vs. Oracle (not speed) > > > Hi, > > I am beging using MySQL for quite a while and it is > a > very good choice if you don't really need stored > procedures. MySQL provides a pretty good > implementation of a subset of MySQL-92, performance > is > great, it is cross-platform, provides transactions, > and its price... well is free. > > Hope it helps. > --- Mary Stickney <[EMAIL PROTECTED]> wrote: > > > > It doesn't suport alot of differnt things > > it dosent have store procedures , dosent have a > > complete SQL command set... > > > > I am using it becasue I am being forced to... > > > > > > > > -Original Message- > > From: Elizabeth Bogner > > [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, August 15, 2002 9:25 PM > > To: [EMAIL PROTECTED] > > Subject: MySQL vs. Oracle (not speed) > > > > > > > > A company I work with is in the process of > upgrading > > its databases from > > some > > motheaten system to something current. My > impression > > is that they > > want to go with Oracle, and I'm not sure if this > is > > based on anything > > other than being impressed with the size and > > presumed quality support > > of Oracle. I'd like to encourage them to at least > > seriously consider > > using > > MySQL instead. > > > > I don't think that speed is a huge factor here; we > > do a lot of XML > > publishing > > and content management, but at most we'd have > > several gigabytes of > > data and several dozen simultaneous users, so well > > within the > > capabilities > > of MySQL. I've looked at various things I could > > find, like the benchmarks > > pages (probably not relevant) and the MySQL myths > > page, which was > > somewhat helpful, but I couldn't find anything > more > > along the lines of > > "How to Convince my Management to go with MySQL." > I > > don't even know > > what to expect from them, but I'm imagining > they'll > > say, "But MySQL > > doesn't support sub-selects," to which I can > reply, > > "But you can write > > most of those as joins anyway, so it won't matter > > because the software > > will all be written from scratch." Etc. > > > > Are there pointers anyone can give me? > > > > E. Bognewitz > > > > > > > - > > 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.mysq
RE: MySQL vs. Oracle (not speed)
Hi, I am beging using MySQL for quite a while and it is a very good choice if you don't really need stored procedures. MySQL provides a pretty good implementation of a subset of MySQL-92, performance is great, it is cross-platform, provides transactions, and its price... well is free. Hope it helps. --- Mary Stickney <[EMAIL PROTECTED]> wrote: > > It doesn't suport alot of differnt things > it dosent have store procedures , dosent have a > complete SQL command set... > > I am using it becasue I am being forced to... > > > > -Original Message- > From: Elizabeth Bogner > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 9:25 PM > To: [EMAIL PROTECTED] > Subject: MySQL vs. Oracle (not speed) > > > > A company I work with is in the process of upgrading > its databases from > some > motheaten system to something current. My impression > is that they > want to go with Oracle, and I'm not sure if this is > based on anything > other than being impressed with the size and > presumed quality support > of Oracle. I'd like to encourage them to at least > seriously consider > using > MySQL instead. > > I don't think that speed is a huge factor here; we > do a lot of XML > publishing > and content management, but at most we'd have > several gigabytes of > data and several dozen simultaneous users, so well > within the > capabilities > of MySQL. I've looked at various things I could > find, like the benchmarks > pages (probably not relevant) and the MySQL myths > page, which was > somewhat helpful, but I couldn't find anything more > along the lines of > "How to Convince my Management to go with MySQL." I > don't even know > what to expect from them, but I'm imagining they'll > say, "But MySQL > doesn't support sub-selects," to which I can reply, > "But you can write > most of those as joins anyway, so it won't matter > because the software > will all be written from scratch." Etc. > > Are there pointers anyone can give me? > > E. Bognewitz > > > - > 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 > __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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: Count and group by problems
Interesting a spooky. Try to use different cursor types. As you know, ADO, or better said, OLE DB behaves (or misbehaves) depending on the cursor. Have you tried a FORWARD and READ ONLY cursor. Good Luck --- "Menard, Inc. Information Systems" <[EMAIL PROTECTED]> wrote: > Evening > > I think I'm losing my mind. I have a very simple > query that works fine in > MySQLFront but will not work when I connect using > ADO: > > select booger, count(*) from nose group by booger > > If I try the above query with one record It works > fine. Once I try it with > more records, nothing returns. > > If I try: > select booger from nose group by booger > It returns results with one or more records. > > Thanks for all of your help! > > Jake > > > - > 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 > __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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: probleme conection (Please explain)
Hi Florian, If you want to connect remotely to the server, you have to grant permission to that user. Try this: GRANT ALL PRIVILEGES ON *.* TO 'theuser'@'%' IDENTIFIED BY 'thepassword'; With this command you are telling MySQL to accept calls from any computer if the user name is 'theuser' and the password is 'thepassword'; I recomend you to refer to MySQL's manual about permissions. Bye and Good Luck. --- Florian Litot <[EMAIL PROTECTED]> wrote: > I am able very well to connect me to the base of > data on my computer > (locally) but if I want that somebody connects > himself since another > computer it cannot it tries to be connected by the > intermediary of an > interface java and thus by link JDBC and if we > install the ihm java on the > local computer the ihm Donc functioning I do not > know where there is a > problem if it is the connection jdbc which is not > able to be connected to > the distant computer or then it is the base of data > which refuse the > connection I would go more on the point of view than > it is the base of am > in version 4.0 ss win nt if need be for another > information say me for I do > not have the practice and I begin with mysql for the > moment what I did it > is right a standard install of mysql while adding to > use and create the > table and data is necessary it to make another > thing? > > At 15:29 02/08/02, you wrote: > >Hi, > > > >Could you put more detail in the description of the > >problem? > > > >Bye. > >--- Florian Litot <[EMAIL PROTECTED]> > >wrote: > > > Hi, > > > i use mysql v4.0 i have got a problem with the > > > connection to database i can > > > connect if i have localhost but if i want to > connect > > > to database i can't. > > > There is a limitation with mysql v4.0 or not ? > have > > > you got an idea? > > > thanks > > > > > > > > > > >- > > > 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 > > > > > > > > >__ > >Do You Yahoo!? > >Yahoo! Health - Feel better, live better > >http://health.yahoo.com > __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Save Image (GIF or JPEG) file in the database ?
Hi, It depends how you want to treat those images. One of the advantages of putting the images in separate files is that you can modified them directly. If the images are small, I think that a blob field is a good idea but if the images are big, can make the database grow to much. Hope it helps. Bye and Good Luck. --- Simon Green <[EMAIL PROTECTED]> wrote: > Have a look at > http://www.mysql.com/doc/B/L/BLOB.html > > Simon > > -Original Message- > From: Khanh Pham > [mailto:[EMAIL PROTECTED]] > Sent: 02 August 2002 09:59 > To: [EMAIL PROTECTED] > Subject: Save Image (GIF or JPEG) file in the > database ? > > > Hello ladies & gents, > > I am new to MySQL. I wonder if I can save a picture > in the database, > then I can load into a JSP. The perfect example is > an employee page ! > > Thanks in advance for your helps ! > > /Khanh > > > - > 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 > __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: probleme conection (Please explain)
Hi, Could you put more detail in the description of the problem? Bye. --- Florian Litot <[EMAIL PROTECTED]> wrote: > Hi, > i use mysql v4.0 i have got a problem with the > connection to database i can > connect if i have localhost but if i want to connect > to database i can't. > There is a limitation with mysql v4.0 or not ? have > you got an idea? > thanks > > > - > 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 > __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Running an SQL file from the command line
mysqlsource sms.sql Bye and Good Luck! --- Scott Pippin <[EMAIL PROTECTED]> wrote: > I need to run a file called sms.sql from the command > line. Is this > possible and what is the syntax? > Thanks in advance. > > - > 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 > __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySQL using OLEDB
Hi, Search if somebody has the OLEDB driver for MySQL, and then you will be able to do it. Bye and Good Luck! --- "Darrell A. Sullivan, II" <[EMAIL PROTECTED]> wrote: > Can anyone tell me if it is possible to connect to a > MySQL server running on > Linux from a Windows Visual Basic application > without setting up a DSN on > the Windows computer? > > I know this can be done with MS SQL Server and I > have heard it can be done > with Oracle so I am wondering if there is a > connection string that will work > with MySQL. Currently everything I try brings up a > DSN setup screen and this > is something that I definitely do not want. > > Thanks for any help. > > Darrell > > > - > 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 > __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Linux Installation (make) problem
Hi, I recomend you to use the pre-compiles binary distribution. You won't have to build it and it worked for me. This is the link for the Intel platform: http://www.mysql.com/downloads/download.php?file=Downloads/MySQL-3.23/mysql-3.23.51-pc-linux-gnu-i686.tar.gz Bye and Good Luck. --- Saravanan C <[EMAIL PROTECTED]> wrote: > > To: [EMAIL PROTECTED] > > From: Saravanan C <[EMAIL PROTECTED]> > > Subject: From Saravanan, REC, INDIA > > Date: Thu, 1 Aug 2002 13:05:17 GMT > > - > > Hi Lists, > > > > I recently downloaded > mysql-3.23.51-pc-linux-gnu-i686 from mysql.com for > linux > > platform. > > > > I did the following. > > > > Created group mysql > > Created user mysql > > Extracted the zip using gunzip to > /usr/local/mysql-VERSION-OS/ > > cd /usr/local/mysql-VERSION-OS/ > > ./configre --prefix=/usr/loca/mysql > > > > . > > . > > [root@neelsl mysql-3.23.51-pc-linux-gnu-i686]# > Starting mysqld daemon with > datab > > ases from > /usr/local/mysql-3.23.51-pc-linux-gnu-i686/data > > 020801 16:23:20 mysqld ended > > > > [root@neelsl mysql-3.23.51-pc-linux-gnu-i686]# > make > > make: *** No targets specified and no makefile > found. Stop. > > [root@neelsl mysql-3.23.51-pc-linux-gnu-i686]# > make install > > make: *** No rule to make target `install'. Stop. > > > > What is the problem, I am following the > instructions provided in the > manual.txt. > > > > I am new to this. > > > > Regards, > > > > Saravanan > > > * > > C. Saravanan Phone : 500 281 > *2241 (Off.) > > Programmer, Dept. of Comp.Sc. & Eng. 341 311 > (Res.) > > Regional Engineering College, > > Trichy, Tamilnadu, INDIAFax : 500 > 188 > > > * > > "What is a friend? A single soul dwelling in two > bodies. " > > > > - > > This message was sent from RECTMAIL. > > http://www.rect.edu/ or > http://rangoli.rect.ernet.in/ > > > - > This message was sent from RECTMAIL. > http://www.rect.edu/ or > http://rangoli.rect.ernet.in/ > > > > - > 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 > __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AIX 4.3 Installation of Binary file does not work because libz. (Still unresolved).
Hi, I wanted to summarize my problem again so if somebody had the same issue can help me. O.S. IBM AIX 4.3.3 MySQL Binary Distribution: 3.23.46 When I run ./scripts/mysql_install_db, I got this error: exec(): 0509-036 Cannot load program ./bin/mysqld because of the following errors: 0509-150 Dependent module libz.a(shr.o) build not be loaded. 0509-022 Cannot load module libz.a(shr.o). 0509-026 System error: A file or directory in the path name does not exist. Installation of grant tables failed! I was asked to download the libz library, which I did (zlib.1.1.4.tar). I compiled for the IBM AIX using make-3.79.1.tar but when I run the ./scripts/mysql_install_db and I get almost the same error: exec(): 0509-036 Cannot load program ./bin/mysqld because of the following errors: 0509-150 Dependent module /usr/lib/libz.a(shr.o) could not be loaded. 0509-152 Member shr.o is not found in archive Installation of grant tables failed! Is there anything else that I can do? Victoria Reznichenko confirmed that they are working on a new binary distribution, but does anybody now when we should expect the new release? Thanks in advanced. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: order by date
Hi, Change the alias to date_format(date,'%D %M %Y') AS mydate, so you are sure that you sort by the date field not my the formatted date. Be aware that if you sort my the formatted string, MySql is going to treat it as a string and therefore sort it as a string. "11th July 2002" < "2st July 2002" if we compare them as strings but 07-11-2002 > 07-02-2002 if we compare them as dates. Bye and Good Luck! --- julian haffegee <[EMAIL PROTECTED]> wrote: > This must be a regularly appearing problem, which is > why i'm surprised I > can't find a webpage on it.. > > I have > > $result = mysql_query("SELECT title, url, > description, author, > date_format(date,'%D %M %Y') AS date FROM > documents_tbl, url_tbl WHERE > documents_tbl.title_id = url_tbl.url_id ORDER BY > date DESC"); > > Everything works fine, but the ORDER BY bit sorts > all dates as 9th, 8th 7th > etc rather than 31st, 30th and so on. > > can anyone tell me where to look to read all about > it. > > Thanks Jules > > > - > 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 > __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: why does MySQL need to access the internet? my firewall wants to know
Hi, Are you sure that is trying to access the internet. It may be trying to open the port, remember that MySQL needs 3306 (by default) to communicate with the server. I think if you just open that port, everything will be ok. Bye and Good Luck. --- "Matthew K. Gold" <[EMAIL PROTECTED]> wrote: > Hi, > > When I try to start MySQL, I get alerts from my > personal firewall that MySQL > is trying to access the internet...why would this > happen? > > I'm currently using (or trying to use) Abriasoft's > Merlin desktop, which > includes apache. I would have thought that if I'm > running a apache on my > own computer, there would be no need to access the > internet. > > I would guess that this has something to do with > Abriasoft, except that this > also happened to me when i was running MySQL without > the aid of merlin or > anything else. > > I'd appreciate it if anyone could shed some light on > this matter... > > Thanks, > > Matt > > > - > 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 > __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query problem
Hi, Use LEFT JOIN instead of =. In a 1:m relationship, only records that match in both tables are selected. With L.J., the master is always selected even if the record is not present in the child. Master Id 1 2 3 4 5 Children FK_id Value 1 V1 1 V2 2 V3 Select id, value from Master, Children Where Master.Id = Children.FK_id 1, V1 1, V2 2, V3 Select id, value from Master Left Join Children On Master.Id = Children.FK_id 1, V1 1, V2 2, V3 4, NULL 5, NULL This query is very useful to find records without children Select id, value from Master Left Join Children On Master.Id = Children.FK_id Where value is null Bye and Good Luck. --- Kevin <[EMAIL PROTECTED]> wrote: > Hello, > > I have a query that runs perfectly until one of the > items has no value or is > set to 0: > > SELECT > item.*, color.Name AS COLOR, > shapecode.Shape AS SHAPE, > clarity.Name AS CLARITY > FROM item, color, shapecode, clarity > WHERE > clarity.ID = item.CLARITY_ID > AND shapecode.ID = item.SHAPE_ID > AND item.COLOR_ID = color.ID > AND ITEM_ID='MA603' > > If the item.CLARITY_ID has no value or a value of 0 > (which there is no > defined value for in the clarity table), then the > query fails. > > Can anything be done without adding more login in > the code? > > Thanks > > --Kevin > > > - > 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 > __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need help with Tables/Attributes
Hello Nitesh, You can find that and more at... http://www.mysql.com/doc/A/L/ALTER_TABLE.html Good Luck, --- Nitesh Divecha <[EMAIL PROTECTED]> wrote: > Hello All, > > I need help with tables. I have created my table > with some attributes in > it. > > I need to modify my table attributes, can any one > help me with the > modify command or can give me the short cut to the > web. > > Example: > Mysql> create table test(ID int(4), Name > varchar(20), Sex varchar(1)); > > Now I need to change the attribute NAME TO Full > name, HOW? > > Please help, Thanking in Advance. > > Regards > Nitesh > > > > - > 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 > __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: IBM-AIX 4.3 MySQL Binnary Installation Problem: libz is missing.
Victoria, I am using mysql-3.23.49-ibm-aix4.3.3.0-rs6000.tar.gz, which is the latest version posted on your site. Also, when I try to compile mysql-3.23.51.tar.gz, I get the following error executing the make command: "my_gethostbyname.c", line 81.5: 1506-068 (S) Operation between types "struct hostent*" and "int" is not allowed. make: 1254-004 The error code from the last command is 1. I am using GNU Make 3.79.1 Thanks in advance. Francisco, Thursday, July 25, 2002, 2:46:39 AM, you wrote: FR> When I try to execute scripts/mysql_install_db, I get FR> some errors about some libraries missing: FR> exec(): 0509-036 Cannot load program FR> ./bin/my_print_defaults because of the following FR> errors: FR> 0509-150 Dependent module libz.a(shr.o) could not be FR> loaded. FR> 0509-022 Cannot load module libz.a(shr.o). FR> 0509-026 System error: A file or directory in the path FR> name does not exist. FR> How can I get those libraries and what should I do FR> once I get them? What version did you install? This problem was in 3.23.49, 3.23.50, 3.23.51 for AIX because of wrong build. MySQL developers are still working on a new build. -- 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 __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
IBM-AIX 4.3 MySQL Binnary Installation Problem: libz is missing.
Hi, When I try to execute scripts/mysql_install_db, I get some errors about some libraries missing: exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-150 Dependent module libz.a(shr.o) could not be loaded. 0509-022 Cannot load module libz.a(shr.o). 0509-026 System error: A file or directory in the path name does not exist. How can I get those libraries and what should I do once I get them? Thanks in advance. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Hello I am new to the list..
Hi, Mailing list: http://lists.mysql.com/ Joining three tables could be something like this. Select * from t1 INNER JOIN t2 ON t1.id = t2.id INNER JOIN t3 ON t2.id = t3.id I highly recomend you to read some basic SQL books before you carry on with your project. Trial and error is not always the better option. :-) Bye and Good Luck! --- Dj <[EMAIL PROTECTED]> wrote: > And could not find where or if they have archives of > the list for my to > search though so I guess I will ask my question. > > > I was wondering how to go about joining 3 tables. I > figured out how to > join 2 took me about 30 min to get it to join right, > but I cant for the > life of me figure out 3. > > Here are the SQL statements I have tried > > SELECT twc_loot_distro.*, twc_mob_loot.loot_name > FROM twc_loot_distro > INNER JOIN ( > SELECT twc_loot_distro.*, twc_mob_list.mob_name > FROM twc_loot_distro > LEFT JOIN twc_mob_list > ON twc_loot_distro.mob_id=twc_mob_list.mob_id > ) > ON twc_loot_distro.loot_id=twc_mob_loot.loot_id > > > SELECT twc_loot_distro.*, twc_mob_loot.loot_name > FROM ( > SELECT twc_loot_distro.*, twc_mob_list.mob_name > FROM twc_loot_distro > LEFT JOIN twc_mob_list > ON twc_loot_distro.mob_id=twc_mob_list.mob_id > ) > INNER JOIN twc_mob_loot > ON twc_loot_distro.loot_id=twc_mob_loot.loot_id > > > > SELECT twc_loot_distro.*, twc_mob_list.mob_name, > twc_mob_loot.loot_name > FROM twc_loot_distro > LEFT JOIN twc_mob_list, twc_mob_loot > ON twc_loot_distro.mob_id=twc_mob_list.mob_id AND > twc_loot_distro.loot_id=twc_mob_loot.loot_id > > > > None of those worked, just gave me errors in syntax > so obviously I am > doing something wrong, but I don't see what. > > The following join statement works > SELECT twc_loot_distro.*, twc_mob_list.mob_name > FROM twc_loot_distro > LEFT JOIN twc_mob_list > ON twc_loot_distro.mob_id=twc_mob_list.mob_id > > But adding a 3rd table to that is proving much more > complicated. > > > > - > 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 > __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Network access?
Hi, If you mean how to connect to a MySQL server from a remote machine in a local network, you only need to include the computer (or ip address) of the server in the HOSTNAME. You also have to make sure that the user in the connection string, has permission to access the database, you should go to MySQL's manual to learn about security and permissions. I hope it helps. Bye and Good Luck. --- Steve Dickey <[EMAIL PROTECTED]> wrote: > I am a MySQL newbie and can not seem to find the > documentation that > explains how to allow network or remote access to a > running MySQL > server. It does not seem to be in the my.cnf file > or in the manual??? > I am sure this is a simple thing but it is really > holding me up right > now. Thanks for any help. > > scd > > - > 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 > __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Select Problem
Hi, Use LEFT JOIN instead = Bye and Good Luck! --- Mark Colvin <[EMAIL PROTECTED]> wrote: > I want to select from three tables where there may > or may not be a record in > the third table. Table 1 and 2 have a one to one > relationship and table 1 > and 2 both have a one to many relationship with > table three. All three > tables have a column called 'code' and I want to > select where code is in > table one and table1.code = table2.code and > table1.code = table3.code. I > also want the records that are in table 1 and 2 but > do not have any any > record(s) in table three. Is it possible to build a > query that would get the > results into one recordset? I have tried various > queries that don't quite > return what I need. I hope this makes some sort of > sense. > > > > This e-mail is intended for the recipient only and > may contain confidential information. If you are > not the intended recipient then you should reply > to the sender and take no further ation based > upon the content of the message. > Internet e-mails are not necessarily secure and > CCM Limited does not accept any responsibility > for changes made to this message. > Although checks have been made to ensure this > message and any attchments are free from viruses > the recipient should ensure that this is the case. > > > - > 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 > __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help me with this query
See comments below... -- Arul <[EMAIL PROTECTED]> wrote: > Hi > > I Dont think this will work coz I need the company > which has serviceid = 1 > AND serviceid = 2 and serviceid = 3 > I think that you are mixing natural language with logical expression, right? The expression above always returns FALSE, that is, no record will be returned. > So let's take this Query , > > Select companyid, count(*) from CompanyServices > where > serviceid = 1 or serviceid = 2 or serviceid = 3 > group by companyid > having count(*) = 3 > > If i have another company say companyid = 5 ,who has > serviceid = 1 AND > serviceid = 6 AND serviceid = 7 , even this company > will be retrieved which > will be against the search criteria. This company won't be retrieve because just services 1. Look the query again Arul, we are filtering the records: serviceid = 1 or serviceid = 2 or serviceid = 3 Only records with serviceid 1, 2, or 3 will be returned in the query. Then we are grouping to count the records for each group, and finally (with the HAVING COUNT), we are making sure that only company with the three services are shown. Have you really tried this query? Because I tried and it worked unless I misunderstood what you want to do. > Also another company whose companyid = 7 has > serviceid = 1 AND serviceid = 2 > AND serviceid = 3 AND serviceid = 5 .This company > will not be retrieved > since the count is not 3.But by search criteria , > this company should be > retrieved. > The count for this company will be 3 because the same reason as above. Look this simple table: id1,id2 1,1 1,2 1,3 2,3 3,4 3,5 3,6 Select * from tblService where id2 = 1 or id2 = 2 or id2 = 3 will return: id1,id2 1,1 1,2 1,3 2,3 Select id1, count(*) from tblService where id2 = 1 or id2 = 2 or id2 = 3 group by id1 returns: id1,count(*) 1,3 2,1 and finally Select id1, count(*) from tblService where id2 = 1 or id2 = 2 or id2 = 3 group by id1 having count(*) = 3 id1,count(*) 1,3 Only and only id1 (company) 1 services the three service type. Let me know if this is not what you wanted. Bye and Good Luck. > So how do we handle these situations > > -Arul > - Original Message - > From: "Francisco Reinaldo" <[EMAIL PROTECTED]> > To: "Arul" <[EMAIL PROTECTED]>; "MySQL" > <[EMAIL PROTECTED]> > Cc: "Arul" <[EMAIL PROTECTED]> > Sent: Wednesday, July 17, 2002 3:27 AM > Subject: Re: help me with this query > > > > Hi, > > > > Select companyid, count(*) from CompanyServices > where > > serviceid = 1 or serviceid = 2 or serviceid = 3 > > group by companyid > > having count(*) = 3 > > > > Bye and Good Luck. > > --- Arul <[EMAIL PROTECTED]> wrote: > > > Hi All > > > > > > The Table design goes like this > > > > > > Company Table > > > > > > companyid integer > > > name varchar(100) > > > > > > > > > Services Table > > > > > > ServiceIDinteger > > > Servicevarchar(50) > > > > > > > > > Company Services > > > --- > > > companyidinteger - References > > > Company(companyid) > > > serviceid integer - References > > > Services(ServiceID) > > > > > > The Values in Company table are > > > > > > companyidname > > > 1'ABC' > > > 2'XYZ' > > > 3'CDE' > > > > > > > > > The Values in Services table are > > > > > > serviceidservice > > > 1'Ebiz' > > > 2'MainFrames' > > > 3'CAD' > > > 4'Maintenance' > > > > > > The Values in Company Services table are > > > > > > companyidserviceid > > > 1 1 > > > 1 2 > > > 1 3 > > > 2 1 > > > 2 2 > > > 3 4 > > > > > > > > > I have a List Box where the user selects his > Need > > > for Services. > > > Suppose the User selects 1 , 2 and 3 , then i > need > > > to show him the company > > > which provides him all 1 , 2 and
RE: MySQL in different OSes
>From MySQL manual: http://www.mysql.com/doc/M/o/Moving.html http://www.mysql.com/doc/U/p/Upgrading-to-arch.html I have tried and it works in HP-Solaris and LINUX, but I tend to agree with Cal, my recomendation is to use an alternative procedure such as dumping and importing. Bye and Good Luck. --- Cal Evans <[EMAIL PROTECTED]> wrote: > Yes and no. > > No, you can't (shouldn't) copy the file from one > server to another. Bad > Mojo. It MAY work if you are only using MyISAM file > types but no promises > there. > > You would be much better off using mysqldump to dump > the contents of your > databases to a text file and then re-importing them > on the other machine. > > master > mysqldump -opt > everything.sql > > slave > mysql < everything.sql > > Warning this will wipe everything on your slave > machine as it imports from > the master. > > =C= > > * > * Cal Evans > * The Virtual CIO > * http://www.calevans.com > * > > > -Original Message- > From: Hanxue Lee [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 17, 2002 12:39 AM > To: [EMAIL PROTECTED] > Subject: MySQL in different OSes > > > Hi, > > I just want to know if I can just copy a MySQL > database from, say Windows > 2000 > to Linux. Will it still work? Does it has binary > data compabilities? > > Thank you > > > Yours Truly, > Hanxue > > > - > 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 > __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help me with this query
Hi, Select companyid, count(*) from CompanyServices where serviceid = 1 or serviceid = 2 or serviceid = 3 group by companyid having count(*) = 3 Bye and Good Luck. --- Arul <[EMAIL PROTECTED]> wrote: > Hi All > > The Table design goes like this > > Company Table > > companyid integer > name varchar(100) > > > Services Table > > ServiceIDinteger > Servicevarchar(50) > > > Company Services > --- > companyidinteger - References > Company(companyid) > serviceid integer - References > Services(ServiceID) > > The Values in Company table are > > companyidname > 1'ABC' > 2'XYZ' > 3'CDE' > > > The Values in Services table are > > serviceidservice > 1'Ebiz' > 2'MainFrames' > 3'CAD' > 4'Maintenance' > > The Values in Company Services table are > > companyidserviceid > 1 1 > 1 2 > 1 3 > 2 1 > 2 2 > 3 4 > > > I have a List Box where the user selects his Need > for Services. > Suppose the User selects 1 , 2 and 3 , then i need > to show him the company > which provides him all 1 , 2 and 3 services . By our > data , its company 1 > I cant search by using IN coz it would select a > record even if the company > is providing any one of the services. > I did this by using self join for ex: > > select > distinct(c.companyid) , c.name > from > company c , companyservices cs1, > companyservices cs2, > companyservices cs3 > where > cs1.serviceid = 1 > AND cs2.serviceid = 2 > AND cs3.serviceid = 3 > AND c.companyid = cs1.companyid > > > > Is there any other way , i could achive the result > without using a self join > > -Arul > > 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 > __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Use MySQL and Visual Basic 6.0
Hi, This is not related with your issue but if you want to do serious development, don't use Windows 98 in any of its versions. It is going to give a lot of problems. Bye and Good Luck. --- Matthew Scarrow <[EMAIL PROTECTED]> wrote: > I've built a whole program with vb6 and mysql > database back end. Never had > any problems. I used the mysql odbc for windows to > access the database. What > are you using? > > Matthew Scarrow > ComIT Solutions Inc. > www.comit.ca > Phone: 519-442-0100 > Fax: 519-442-0429 > > > -Original Message- > From: Carlos Rovetto [mailto:[EMAIL PROTECTED]] > Sent: Sunday, July 14, 2002 9:18 PM > To: [EMAIL PROTECTED] > Subject: Use MySQL and Visual Basic 6.0 > > > Hi. I am begining using MySQL with Visual Basic 6.0 > in Windows 98 first > edition. Some times i to receive this message but i > don't know why. > > Error on rename of '.\video\products.MYI' to > '.\video\#sql2-fffa6015-3.MYI' > (Errcode: 13) > > The SQL instruction is: > alter table products add (unitprice double(7,2), > precio2 double(7,2)) > > I don't know if use MySQL with VB and Windows is > good idea. > > Thanks > > Carlos > > > > > _ > MSN. Más Útil cada Día. http://www.msn.es/intmap/ > > > - > 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 > __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help - query suggestion needed - interesting case
Hi, Since subqueries are not allowed in MySQL, this is what I would do: Create a temporary table with the id's containing multiple dates. Inner join your table with the temporary table. Even if MySQL allowed subqueries, this is what will probably happen behind the scene. Bye and Good Luck! --- Mihail Manolov <[EMAIL PROTECTED]> wrote: > :) Is this some sort of a joke? > > I am grouping using event_id, which makes your query > useless because it will > return just the first time row per each event_id. > > Thanks anyway. I may have to use second query... :-( > > > Mihail > > > - Original Message - > From: "Bhavin Vyas" <[EMAIL PROTECTED]> > To: "Mihail Manolov" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Thursday, July 11, 2002 10:51 PM > Subject: Re: Help - query suggestion needed - > interesting case > > > > How about: > > > > SELECT > > event_id, time, > > count(DISTINCT time) AS Ranges > > FROM > > events > > GROUP BY > > event_id HAVING Ranges > 1 > > > > > > - Original Message - > > From: "Mihail Manolov" > <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Thursday, July 11, 2002 2:58 PM > > Subject: Help - query suggestion needed - > interesting case > > > > > > > Greetings, > > > > > > I am stuck with this problem: > > > > > > I have the following table: > > > > > > event_id time > > > 1002000-10-23 > > > 1002000-10-23 > > > 1012000-10-24 > > > 1012000-10-25 > > > > > > I need to know all event_id's that have multiple > times + time columns. > Is > > it > > > possible to get that result in just one query? > > > The result should be something like this: > > > > > > event_id time > > > 1012000-10-24 > > > 1012000-10-25 > > > > > > > > > I managed to get all event_id's that have > multiple times, but I don't > know > > > how to get the time column in the same query. > > > Here is my current query: > > > > > > SELECT > > > event_id, > > > count(DISTINCT time) AS Ranges > > > FROM > > > events > > > GROUP BY > > > event_id HAVING Ranges > 1 > > > > > > Please help me to find a single query that will > return the time column > as > > > well. > > > > > > > > > Mihail > > > > - > 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 > __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: select query
Hi, Sorry but MySQL does not support subqueries yet. Bye and Good Luck! --- Narcis GRATIANU <[EMAIL PROTECTED]> wrote: > > > When I try this: > > SELECT article, dealer, price > FROM shop s1 > WHERE price=(SELECT MAX(s2.price) > FROM shop s2 > WHERE s1.article = s2.article) LIMIT > 0, 100 > > I got this error message: > > You have an error in your SQL syntax near 'SELECT > MAX(s2.price) > FROM shop s2 > WHERE s1.article' at line 3 > > > My shop table contains this data: > +-++---+ > > | article | dealer | price | > > +-++---+ > > |0001 | A | 3.45 | > > |0001 | B | 3.99 | > > |0002 | A | 10.99 | > > |0003 | B | 1.45 | > > |0003 | C | 1.69 | > > |0003 | D | 1.25 | > > |0004 | D | 19.95 | > > +-++---+ > > > > > > and the table was created with this commnad: > > > > CREATE TABLE shop ( > > article INT(4) UNSIGNED ZEROFILL DEFAULT '' NOT > NULL, > > dealer CHAR(20) DEFAULT '' NOT > NULL, > > price DOUBLE(16,2) DEFAULT '0.00' NOT > NULL, > > PRIMARY KEY(article, dealer)); > > > > > > Thank You ! > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql certification
Dough! They started behaving like big corporations already; certification, consulting, etc, etc. :-) --- "Defryn, Guy" <[EMAIL PROTECTED]> wrote: > > > > I was wondering if anybody heard about a possible > release of books that help you prepare for the Mysql > certification? > > Cheers > > - > 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 > __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query realted to Mysql access.
No1. Sounds like a permission problem. Make sure that you have that domain in the list of computer allowed to connect to MySQL. Refer to MySQL manual to get more information about this. No2. PC based application won't run on Linux unless you run them under an PC-emulator which I don't even know if there is for Linux. Solution: Program in Java if you want cross-platform applications. Bye and good luck. --- Naathan <[EMAIL PROTECTED]> wrote: > Hello, > > Greetings! > > I am trying hard to connect to MySQL database stored > on Linux machine > through a > VB program running on windows on another machine. > > My problems are .. > > Problem No1: > > My Windows machine is under a Windows NT domain. > Linux machine is under another Windows NT domain. > > I created a database in the MySQL server which is in > LINUX server. > I installed the MyODBC and created the DSN also. > > I try to connect to MySQL server through a VB > coding. > > I am getting the following error message like . > > " [TCX][MyODBC]Host is not > allowed to connect this MySQL > server " > > Kindly let me know how to connect the MySQL database > stored on LINUX machine > through a VB > coding. > > Problem 2: > > I have MySQL database stored on Linux machine. > I have LINUX client machine also. > I want to run a application which is created in VB. > I tried to run an VB exe in the Linux machine. I am > not able to run the VB > exe. > Can I run the VB exe in LINUX systems? how? > If yes then what to do for run the VB exe file in > Linux? > > Kindly give solutions to my above problems. > > With best regards, > > Naathan. India. > > > > - > 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 > __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database documentation
Hi, These tools are not open source: http://www.thekompany.com/products/dataarchitect/ You can download the evaluation. It supports MySQL directly: http://www.datanamic.com/download/download_dezign.html If you are not familiar with database methodology and relation entity diagrams, I recomend you to buy a book that explains the concept a little bit. Bye and good luck. --- Gigi Di Leo <[EMAIL PROTECTED]> wrote: > Hello list. > > At the end of a db programming job (using php) I > have been asked for a document describing in details > the structure of a MySQL database. > The purpose of the document is to make other DB > people able to manage and interface the database (I > can figure out that there is also the intent to > impress the customer by graphic and heavy paper). > Could you please suggest me some source where I > could learn about the best standard methods to > describe a DB structure ? > Is there any tool which is able to produce this kind > of document semi/automatically ? > > gg > > > - > 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 > __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: UDF, Can anyone please help?
Hi Miles, Could you explain the same thing with a some sample data? I does not need to be your data. I think that what you want to do is this but I am not sure. Field1 Field2 A 1 A 1 A 2 A 3 B 1 B 1 B 2 C 2 C 2 C 4 C 4 When you say last do you mean this in ms access? Select Field1, Last( Field2 ) From MyTable Group by Field1 Maybe I am not understanding your question, but why don't you do this? Select Field1, Max( Field2 ) From MyTable Group by Field1 Bye and good luck. P.S. One tip about the volume of emails. Check them dialy and delete the ones that you are not interested in. If you are not subscribeb to the mail-list, how are you going to help other people? :-) --- Miles Roper <[EMAIL PROTECTED]> wrote: > Hi, > > I've being trying for the last couple of months to > convert a MS Access to > Mysql. I pull out data extract from around 100 + > queries. These took about > 5 months of solid work to develop and are extremely > complex. I can convert > these to mysql, but have one big problem. There is > no last function in > mysql. I know you can do a descending sort by ID > and grab the first row to > get the same thing. This will not work as I need to > do it over several > thousand different groups. So I need the last row > per group. > > I have been trying to write a aggregate last UDF > function in mysql, and > would consider this to be very simple, however, I > can't get it to work. I > don't really know how to program in C and my > understanding of it is quite > vague. I really need some help to do this from > someone in the community. I > have posted several times in the past and haven't > heard anything from > anyone. I am getting quite frustrated and are about > ready to flag this > exercise as a great waste of time. > > I have successful so far got the UDF to compile, and > installed. I had to > recompile mysql for HPUx to get it to support UDFs > in the first place. It > has taken me 50+ hours to export several hundred meg > of data from access to > mysql. I have even written quite a bit of > code/scripts to get it to the > point where I can start fixing things. > > So, please, can anyone help me with this. I don't > expect someone to do this > all for me, but just a LITTLE help would be nice. I > will quite happily post > this back into the community if I can get it to > work. > > I have removed myself off the mailing digest as the > volume is too high. If > you could please email me at > [EMAIL PROTECTED] > > Yours Gratefully > > Miles > > > - > 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 > __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need Help with mysqlimport please-urgent!
I am not sure if I understand your issue, but if the tables have been updated in the local computer is because you did not connect to the server. With mysqlimport you can specify the host (-h), the user name and password. I think that you should use something like: mysqlimport -hMYSERVER -pMYUSER -uTHEPASSWORD ... Make user that the user has rights to connect to that server. Good luck! --- [EMAIL PROTECTED] wrote: > Hello, > Here is my problem, I would like to use > mysqlimport (which i > have compiled as a batch file to run) from a client > side to load data onto > the database on a server side, meaning that I would > normally access my > server through the pc and running the batch file. > Problem is that there are > no errors but the tables on the server side does not > get updated but > instead points to updating my local database, data > are loaded into my > tables instead (i have the exact replica database on > my own pc). Here is a > sample command line from my batch file > > @h:\mysql\bin\MYSQLI~1.EXE --replace --local > --fields-terminated-by="," > --fields-enclosed-by="\"" > --lines-terminated-by="\r\n" BO h: > \mysql\data\BO\outnum > > i've mapped h:\ as pointing to the c:\ of my > server..is that possible? > Also if i specify --local i think that would be the > issue.however if i > remove the --local then i get an error saying > something like 'this mysql > version does not support or something like that' > > P.S. My table name is outnum which is the same as > the file name, MySQL > version is 3.23.51. > > What am i doing wrong here? Need help please (could > someone guide me what > to do from the very beginning. I need to run > mysqlimport as if i'm running > any program from the console itself but only from a > remote terminal). > Urgent! Thank you. > > Regards, > Eric Loe. > > ** > NOTICE OF CONFIDENTIALITY > ** > This message and any files transmitted with it may > be privileged and/or > confidential and are intended only for the use of > the addressee. If you, > the reader of this message, are not the intended > recipient, you should not > disseminate, distribute or copy this message. If you > have received this > message in error, please notify us immediately by > return email and delete > the original message. Thank you. > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Binary data mysqldump and restore.
If I remember correctly from the manual, you can dump your data generating the SQL statements (this is what you are doing) and your file will have a bunch of INSERTS. Your problem is that those inserts will have something like SET YourBinaryField = 'a-bunch-of-characters'. The problem is that some of the binary data could make the insert impossible to be executed. What I would try is to export the data as a delimited file, then you will have to files, one with your database structure (that you will run first) and another one with the data (delimited by something). Take a look on the manual about this and good luck! --- "Mark Williams (MWP)" <[EMAIL PROTECTED]> wrote: > Hi all... > > !! First, can you CC to [EMAIL PROTECTED], as > im not on the mailing list. > > I have a few tables which are storing a few MB of > binary data (like jpegs). > I can dump the db fine using mysqldump, but on doing > a "mysql ... < dumpfile" i get many errors, as it > seems mysql isnt accepting the binary data in the > dump file. > > I get hundreds of errors like: > ERROR: > Unknown command '\Z'. > ERROR: > Unknown command '\0'. > ERROR: > Unknown command '\Z'. > ERROR: > Unknown command '\0'. > ERROR: > Unknown command '\"'. > ERROR 1064: You have an error in your SQL syntax > near 'GIF89a2\02\0÷ÿ\0\0\0\0ÀÀÀ\0\0 > >\Z\0\Z 0\" > INSE' at line 1 > Query OK, 0 rows affected (0.00 sec) > > Query OK, 1 row affected (0.01 sec) > > So how do i do this? > > Thanks, > MWP > > - > 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 > __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RecordCount
Some database providers implementation always return -1 no matter the amount of records is returned. That happens to ADO too for certain cursors. The best way to go to count records is Count(*), prepare a query like Select count(MyField) from MyTable Where ... and then get the value. I hope it helps. Good Luck! --- Peter Stöcker <[EMAIL PROTECTED]> wrote: > Hi there! > > I'm using MySQL with Delphi 5. > > After running a query i get a recordcount of -1. But > when I check the result there are records. > > Can anybody help me? > > > Thanks, > peter > __ > FreeMail in der Premiumversion! Mit mehr Speicher, > mehr Leistung, mehr > Erlebnis und mehr Pramie. Jetzt unter > http://club.web.de/?mc=021105 > > > - > 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 > __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Left Join Query Too Slow
Hola Javier, It is difficult to tell because you did not include the table structures, relationships, indices, etc. But... at a first glance we is killing you query anyways is this: > FROM > Bill b, Hour h The poor db engine is probably creating a huge temporary table with all possible combinations between Bill and Hour. Is this really what you want to do? Good Luck! --- Javier Campoamor <[EMAIL PROTECTED]> wrote: > Hi, > > I have a problem with the next query because it's > too slow (>10 seconds) and > I need to do 10 queries like this one to show a > page. > > > > SELECT > h.Hour, count(c.Amount) As NumberOfCalls, > sum(c.Amount) As Amount > FROM > Bill b, Hour h > LEFT JOIN > Call c > ON > c.Type='N' AND > b.date <= '2001-06-01' AND > b.date >= DATE_SUB('2001-06-01', INTERVAL 1 MONTH) > AND > b.BillNumber = c.BillNumber AND > h.HourId = HOUR(c.Hour) > GROUP BY > h.Hour > ORDER BY > h.HourId; > > > > In this query the Calls table is big (>70.000 rows) > but the two other tables > are really small (24 & 20 rows). > > When I try to show only the summary for the hours > when there has been Calls > (without the Hour table and the LEFT JOIN), it takes > only 0,5 seconds but I > need to use the Hour table to obtain also the > summary for the hours when > there hasn't been calls. > > I have already created index for the Call.BillNumber > and the Bill.BillNumber > fields, and it has helped (from 40 second to 10 > seconds) but it doesn't > solve the problem. > > I though that the problem were in the HOUR(c.Hour) > but I used a fixed value > and the query is still slow. > > Do you have any idea about the way to optimize it? > > Thanks in advance > > Javier > > > > - > 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 > __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JDBC driver problem
Which driver are you using? I use mm.mysql-2.0.4-bin.jar Which IDE are you using? If you are using JBuilder 5, you have to go to required library and add one pointing to that file. If you are building a jar file from your classes, you have to make sure that you tell the library to include this JDBC jar file. You can do that from the library properties. Then you only have to execute your application using java myapp.jar. If you are not building a jar file, you can do two things: - Make sure that your CLASSPATH includes the jat file name with the path. CLASSPATH=C:\pleasework\jdbc\mysql\mm.mysql-2.0.4-bin.jar or - If you don't want to modify the CLASSPATH: java -classpath C:\pleasework\jdbc\mysql\mm.mysql-2.0.4-bin.jar myapp.jar. Good Luck! --- Myrto Karyda <[EMAIL PROTECTED]> wrote: > I have a problem with the installation of the JDBC > driver for Mysql. > I have Windows XP and Java2 SDK 1.4.01 > I tried to install the JDBC driver > org.gjt.mm.mysql.Driver but every time I > try to connect to my database, I get a > ClassNotFoundException: > org.gjt.mm.mysql.Driver error, although I have put > the org directory into > the path of XP. > I follow the installation notes very carefully but > nothing happens. > Does anyone know anything about this? > Do you have a better driver to suggest? > > > > - > 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 > __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database Structure
How are you connecting to MySQL?, through MySQL ODBC I am assuming. I might happen that the ODBC driver for MySQL does not implement ADOX functionality. Have you tried to take a look to the MySQL++ API? You might have to create your own dll (or COM component) to modify the database structure from your application. Good Luck! --- Efren Pedroza <[EMAIL PROTECTED]> wrote: > Hi everyone, > > I just become a MySQL user and I am trying to > migrate my application from > Access 2000 / SQL Server to MySQL, my system was > developed with MS Visual > Basic 6 SP5, everything seems to be Ok, but in > my application I modify > often Database Structure using ADOX to retrive > structure and modify it, but > when the program try to retrive the structure > nothing works, how can I get > structure database from VB ? > > Is there a way to do that ? > > Or maybe I've to try with some tool that I don't > known. > > Any comment or suggestion is welcomed !!! > > Thanks in advance !!! > > > - > 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 > __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: I'd like to use MySQL with WindowsXP.
Why don't you try to download MySQL from www.mysql.com? Maybe your CD-copy is corrupted. Good luck! --- Dean Harding <[EMAIL PROTECTED]> wrote: > It sure does work on XP. I'm using it right now... > > What error does it give, or if no errors, what > happens when you try to > run it? > > Dean Harding. > > -Original Message- > From: ÎèC [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 18 June 2002 3:28 pm > To: [EMAIL PROTECTED] > Subject: I'd like to use MySQL with WindowsXP. > > Dear Sirs > I have MySQL version 3.23.49. > MySQL CD was included Japanese monthly publication( > Nikkei Software). > This book said MySQL is able to work on Windows > 95/98/2000/Me/NT/XP. > Then I tried to install MySQL to WindowsXP(home > edition) PC. But is > does not work. I would like to use MySQL on Windows > XP. Please advise > me what wrong. Is it possible to use on WindowsXP ? > Best regards > Osamu Ishizaki > > [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 > __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Creating Tables/Keys from PowerDesigner Sql
Well, that would depend if the SQL script generated by your designer is compatible with MySQL, some type names may be different. Good Luck! --- [EMAIL PROTECTED] wrote: > I generated an SQL script of my datamodel in > PowerDesigner which I'd like > to import into mySql to create my tables, keys, etc. > How do I accomplish > this? > > Thanks, > > Jason E. Brawner > > > > > - > 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 > __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Is the order same?
Hi, I would not rely on the "insertion order" if I were you. Honestly, I don't know how MySQL deals with it but servers such as Microsoft SQL Server or even Access won't provide a deterministic order unless you sort using sort by. I recomend you to use sort by anyways if you need the result sets sorted, you never know if you want to migrate to another platform. To make things a little bit faster, you can create some sorted indices. Good Luck! --- Steve Edberg <[EMAIL PROTECTED]> wrote: > At 12:00 PM -0500 6/14/02, Jay Blanchard wrote: > >[snip] > >When I say 'select * from table', can I always be > assured of the > >order in which the results are retrieved. If I > issue the query a second > >time, (assuming no new insertions on the table), > will I get the results in > >the same order, again? > >[/snip] > > > >Yes. Data is always sorted from first entered to > last entered unless you > >change the sort with an ORDER BY or GROUP BY. > > > ...unless you do any deletes and subsequent inserts, > or you optimize > the table, or MySQL decides to change internal > record ordering, or... > > As a general rule in relational databases, results > should always be > considered an unordered set unless you EXPLICITLY > specify an ORDER BY. > > - steve > > > >HAGW! > > > >Jay > >sql, mysql, query > > > > > -- > ++ > | Steve Edberg > [EMAIL PROTECTED] | > | University of California, Davis > (530)754-9127 | > | Programming/Database/SysAdmin > http://pgfsun.ucdavis.edu/ | > ++ > | "If only life would imitate toys." > | > | - Ted Raimi, March 2002 > | > | - > http://www.whoosh.org/issue67/friends67a.html#raimi > | > ++ > > - > 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 > __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: table is read only when DB copied from Win to UNIX
Hi Gary, According to this from MySQL manual: "2.5.5 Upgrading to Another Architecture If you are using MySQL Version 3.23, you can copy the `.frm', `.MYI', and `.MYD' files between different architectures that support the same floating-point format. (MySQL takes care of any byte-swapping issues.) The MySQL ISAM data and index files (`.ISD' and `*.ISM', respectively) are architecture-dependent and in some cases OS-dependent. If you want to move your applications to another machine that has a different architecture or OS than your current machine, you should not try to move a database by simply copying the files to the other machine. Use mysqldump instead. By default, mysqldump will create a file full of SQL statements. You can then transfer the file to the other machine and feed it as input to the mysql client. Try mysqldump --help to see what options are available. If you are moving the data to a newer version of MySQL, you should use mysqldump --opt with the newer version to get a fast, compact dump. The easiest (although not the fastest) way to move a database between two machines is to run the following commands on the machine on which the database is located:" files are not platform dependent. Just the floating field is not. I have done it. I can query the database. It just that the tables are read only. Thanks again. --- [EMAIL PROTECTED] wrote: > The db files are not standard text files, and ARE > platform dependent. Sorry! > > > Gary Every > Sr. UNIX Administrator > Ingram Entertainment > (615) 287-4876 > "Pay It Forward" > mailto:[EMAIL PROTECTED] > http://accessingram.com > > > -Original Message- > From: Francisco Reinaldo [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 13, 2002 9:48 AM > To: Chris Knipe > Cc: MySQL > Subject: Re: table is read only when DB copied from > Win to UNIX > > > Thanks a lot Chris for the tip, but that precisely > what I am trying to avoid so my users don't have to > go > through import and exports. I am kind of lazy too > and > I don't want to create an application to do that > :-). > > Wouldn't be nice that we could just copy the > database, > modify permissions and go? > > Come on! I bet that somebody has already done it. > Please tell me... > > Thanks. > --- Chris Knipe <[EMAIL PROTECTED]> wrote: > > Don't copy the physical files. Use mysqldump and > > mysqlimport instead. > > > > > > Kind Regards, > > > > Chris Knipe > > MegaLAN Corporate Networking Services > > Tel: +27 21 854 7064 > > Cell: +27 72 434 7582 > > > > - Original Message - > > From: "Francisco Reinaldo" <[EMAIL PROTECTED]> > > To: "Tonu Samuel" > > <[EMAIL PROTECTED]> > > Cc: "MySQL" <[EMAIL PROTECTED]> > > Sent: Thursday, June 13, 2002 12:14 AM > > Subject: Re: table is read only when DB copied > from > > Win to UNIX > > > > > > > Thanks for the tip but I have added to the table > > db in > > > mysql database full permission for everybody to > > that > > > database. I don't think that is a permission > thing > > > because when I add a new table, I can insert > data > > into > > > that new table. Besides it does not happen when > I > > copy > > > the database from UNIX to Windows. > > > > > > I'll keep trying though but if somebody already > > knows > > > the solution, please let me know. > > > > > > Thanks. > > > --- Tonu Samuel > > > <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > On Wed, 12 Jun 2002, Francisco Reinaldo wrote: > > > > > > > > > Fine, I can see the database, show tables > > works, > > > > > selects works. The whole nine yards? Nope! I > > > > cannot > > > > > insert any values in that database. I get > the > > > > > following error: "Table xxx is read only". I > > have > > > > > checked the OS permission for that directory > > and I > > > > > have given full persmission (write, read and > > > > execute). > > > > > Also I have checked MySQL permissions, > adding > > full > > > > > permission for all users to that database > but > > > > nothing. > > > > > It looks like the problem is at the table > > level > > > > > because when I manually add a new table to > the > > > > MySQL > > > &g
Re: table is read only when DB copied from Win to UNIX
Thanks a lot Chris for the tip, but that precisely what I am trying to avoid so my users don't have to go through import and exports. I am kind of lazy too and I don't want to create an application to do that :-). Wouldn't be nice that we could just copy the database, modify permissions and go? Come on! I bet that somebody has already done it. Please tell me... Thanks. --- Chris Knipe <[EMAIL PROTECTED]> wrote: > Don't copy the physical files. Use mysqldump and > mysqlimport instead. > > > Kind Regards, > > Chris Knipe > MegaLAN Corporate Networking Services > Tel: +27 21 854 7064 > Cell: +27 72 434 7582 > > - Original Message - > From: "Francisco Reinaldo" <[EMAIL PROTECTED]> > To: "Tonu Samuel" > <[EMAIL PROTECTED]> > Cc: "MySQL" <[EMAIL PROTECTED]> > Sent: Thursday, June 13, 2002 12:14 AM > Subject: Re: table is read only when DB copied from > Win to UNIX > > > > Thanks for the tip but I have added to the table > db in > > mysql database full permission for everybody to > that > > database. I don't think that is a permission thing > > because when I add a new table, I can insert data > into > > that new table. Besides it does not happen when I > copy > > the database from UNIX to Windows. > > > > I'll keep trying though but if somebody already > knows > > the solution, please let me know. > > > > Thanks. > > --- Tonu Samuel > > <[EMAIL PROTECTED]> wrote: > > > > > > > > > On Wed, 12 Jun 2002, Francisco Reinaldo wrote: > > > > > > > Fine, I can see the database, show tables > works, > > > > selects works. The whole nine yards? Nope! I > > > cannot > > > > insert any values in that database. I get the > > > > following error: "Table xxx is read only". I > have > > > > checked the OS permission for that directory > and I > > > > have given full persmission (write, read and > > > execute). > > > > Also I have checked MySQL permissions, adding > full > > > > permission for all users to that database but > > > nothing. > > > > It looks like the problem is at the table > level > > > > because when I manually add a new table to the > > > MySQL > > > > UNIX, the inserts work. > > > > > > The only reason this can happen is wring > permission > > > bits no tables. > > > Internally there is no way to make MyISAM (I > assume > > > you use them) > > > read-only. Look as which user mysqld runs and > make > > > tables writable to that > > > user. > > > > > > Tonu > > > > > > > > > > > > - > > > 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 > > > > > > > > > __ > > Do You Yahoo!? > > Yahoo! - Official partner of 2002 FIFA World Cup > > http://fifaworldcup.yahoo.com > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list > archive) > > > > To request this thread, e-mail > <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: setting up two instances of mySQL
Hi Chris, I am Tom, you know your manager, did you say that I am wrong!!! Just kidding :-). Well I cannot find any good reason for having two databases in two different instance. Do you have two Oracles or Microsoft SQL Server instances in the computer? Nope. The only reason when that is acceptable, is when you want to keep two version of the same database engine. Like having 3.23 and 4.0. Having two MySQL instances is going to complicate things making everything more difficult to maintain and install. Good Luck. --- Cal Evans <[EMAIL PROTECTED]> wrote: > The pros are you can run them under separate > user/group ids therefore you > can make it much harder for someone with access to > only one to get to the > other's data. > > The cons are that you will have 2 copies running > therefore it will take > longer to maintain. > > =C= > > * > * Cal Evans > * Journeyman Programmer > * Techno-Mage > * http://www.calevans.com > * > > > -Original Message- > From: Chris Stefanick > [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 05, 2002 7:56 AM > To: MySQL Support > Subject: setting up two instances of mySQL > > > I have one product already using a mySQL database. > We just inherited a new > product (via an acquisition) that uses it's own > mySQL database which we're > going to stick on the same server. My manager wants > me to setup a second > instance of mySQL on the machine for the new > product's database. I don't > see the point. Why not just have both databases > running under the same > instance of mySQL? Which brings me to my question. > What are the pros and > cons of setting up multiple instances of mySQL on > the same machine? > > Thanks so much, > CS > > > - > 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 > __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can I connect to a MySQL Database on a unix platform from a PC?
Hi, I've been able to connect from an Windows XP to a HP Solaris and LINUX. Make sure that you can ping the UNIX computer from yours. Then replace the computer name in the connection string (most of the time is localhost) for the UNIX computer's ip address (you can use the name if you have DNS resolution) but ip will make the connection faster. Now you can connect, you must set up the permission for your database for the user connecting through the network. The easiest thing is give the appropiate permission to all hostnames. There are some very good examples in MySQL's manual. Good Luck! --- Liqiang Feng <[EMAIL PROTECTED]> wrote: > As a potential MySQL customer, I am trying to find > the answer to the > question "Can I connect to a MySQL Database on a > unix platform from a PC > through TCP/IP network? If the answer is yes, what > other additional > supporting software will be needed on the Unix > platform and on the PC? Any > pointers, examples are greatly appreciated. > > Thanks. > > > Larry Feng > Software Engineer > Cisco Photonics, Inc. > RCDN4/2, S2-025 > 2200 East President George Bush Turnpike > Richardson, TX 75082 > 469-255-1247 > Fax 469-255-9488 > [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 > __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
License.
Hi, You don't have to pay the license because you are not distributing MySQL, BUT whoever installs and user your application and intends to use MySQL will have to purchase the license because that person it is using with a commercial application that it is not open source. That GPL thing is very tricky. Good luck. __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: table is read only when DB copied from Win to UNIX
Thanks for the tip but I have added to the table db in mysql database full permission for everybody to that database. I don't think that is a permission thing because when I add a new table, I can insert data into that new table. Besides it does not happen when I copy the database from UNIX to Windows. I'll keep trying though but if somebody already knows the solution, please let me know. Thanks. --- Tonu Samuel <[EMAIL PROTECTED]> wrote: > > > On Wed, 12 Jun 2002, Francisco Reinaldo wrote: > > > Fine, I can see the database, show tables works, > > selects works. The whole nine yards? Nope! I > cannot > > insert any values in that database. I get the > > following error: "Table xxx is read only". I have > > checked the OS permission for that directory and I > > have given full persmission (write, read and > execute). > > Also I have checked MySQL permissions, adding full > > permission for all users to that database but > nothing. > > It looks like the problem is at the table level > > because when I manually add a new table to the > MySQL > > UNIX, the inserts work. > > The only reason this can happen is wring permission > bits no tables. > Internally there is no way to make MyISAM (I assume > you use them) > read-only. Look as which user mysqld runs and make > tables writable to that > user. > > Tonu > > > - > 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 > __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
table is read only when DB copied from Win to UNIX
Hi, I have an installation of MySQL in Windows and another one in UNIX Solaris 2.7. I need to move the databases across system and I have manually ftped a database directory from the Windows MySQL to the UNIX MySQL. Fine, I can see the database, show tables works, selects works. The whole nine yards? Nope! I cannot insert any values in that database. I get the following error: "Table xxx is read only". I have checked the OS permission for that directory and I have given full persmission (write, read and execute). Also I have checked MySQL permissions, adding full permission for all users to that database but nothing. It looks like the problem is at the table level because when I manually add a new table to the MySQL UNIX, the inserts work. The funny thing is when I do it the other way around, that is, from Solaris to UNIX works without having to do anything at all. Lovely and reliable UNIX!!! Thanks in advance. :-) __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
table is read only when DB copied from Win to UNIX
Hi, I have an installation of MySQL in Windows and another one in UNIX Solaris 2.7. I need to move the databases across system and I have manually ftped a database directory from the Windows MySQL to the UNIX MySQL. Fine, I can see the database, show tables works, selects works. The whole nine yards? Nope! I cannot insert any values in that database. I get the following error: "Table xxx is read only". I have checked the OS permission for that directory and I have given full persmission (write, read and execute). Also I have checked MySQL permissions, adding full permission for all users to that database but nothing. It looks like the problem is at the table level because when I manually add a new table to the MySQL UNIX, the inserts work. The funny thing is when I do it the other way around, that is, from Solaris to UNIX works without having to do anything at all. Lovely and reliable UNIX!!! Thanks in advance. :-) __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cross-platform Deployment issue.
Hi, I have an application in Java that access MySQL databases through JDBC. The issue is that I have to be able to move the database files across different platforms (Windows, UNIX-Solaris, UNIX-IBM, UNIX-HP). If I go to the manual, MySQL says that the database files are compatible between computers with the same floating-point format. What is this about? How can the floating-point issue be overcome without having to export the data in one platform and export it to the other one? Thanks in advance. Bye, Francisco. __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cross-platform Deployment issue.
Hi, I have an application in Java that access MySQL databases through JDBC. The issue is that I have to be able to move the database files across different platforms (Windows, UNIX-Solaris, UNIX-IBM, UNIX-HP). If I go to the manual, MySQL says that the database files are compatible between computers with the same floating-point format. What is this about? How can the floating-point issue be overcome without having to export the data in one platform and export it to the other one? Thanks in advance. Bye, Francisco. __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cross-platform Deployment issue.
Hi, I have an application in Java that access MySQL databases through JDBC. The issue is that I have to be able to move the database files across different platforms (Windows, UNIX-Solaris, UNIX-IBM, UNIX-HP). If I go to the manual, MySQL says that the database files are compatible between computers with the same floating-point format. What is this about? How can the floating-point issue be overcome without having to export the data in one platform and export it to the other one? Thanks in advance. Bye, Francisco. __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Setup and Configure ODBC Data Source Automaticaly
I have a database application in MS-Access running in Windows NT, that is in a network drive, and it has about 150 users. What i want to do, is centralize the database in a PC that would be the server, and place the MS-Access tables in a MySQL database, and the tables would be accessed from MS-Access with ODBC. The MS-Access Application remains the same, the only diference is the tables that would be acessed with ODBC. I would like to know if there is any way of setup and configure ODBC automaticaly, because i have 150 users, and i wouldn't like to setup and configure the ODBC Data Source in 150 PC's. The Optimal solution would be when the application starts, detects if the ODBC Data Source exists, and if it doesn't exists, copy (for example from a network drive) the files needed into the operating system, and the process would be transparent to the user. If anyone has a solution to this problem i would be gratefully. Best Regards, Francisco Spínola - 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 Service could not be started
I have tried to install MySql in a Windows NT Workstation, but in the end of installation occurs an error, that follows: -- DlgcacWinName:_INS5176._MP - Application Error The instruction at "0x" referenced memory at "0x". The memory could not be read. --- I have another error, that i don't know if it has any relation with the previous error, that is, when i try to start the service, with: net start mysql, appear the following error: --- The MySql Service could not be started A system error has occurred System error 1067 has ocurred The process terminated unexpectedly I would appreciate some help. Francisco Spínola [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
unix1
-- Virus Warning Message (on tjintranet) Found virus TROJ_SIRCAM.A in file unix1.zip.com The file unix1.zip.com is moved to /var/tmp/virANB0.nrHt. - Hi! How are you? I send you this file in order to have your advice See you later. Thanks -- Virus Warning Message (on tjintranet) unix1.zip.com is removed from here because it contains a virus. - - 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
01062001
-- Virus Warning Message (on tjintranet) Found virus TROJ_SIRCAM.A in file 01062001.xls.bat The file 01062001.xls.bat is moved to /var/tmp/virPKB0HQl_p. - Hi! How are you? I send you this file in order to have your advice See you later. Thanks -- Virus Warning Message (on tjintranet) 01062001.xls.bat is removed from here because it contains a virus. - - 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
T_chamado06f
-- Virus Warning Message (on tjintranet) Found virus TROJ_SIRCAM.A in file T_chamado06f.xls.lnk The file T_chamado06f.xls.lnk can not be moved because /var/tmp/virSIA0zg7eo: No space left on device. - Hi! How are you? I send you this file in order to have your advice See you later. Thanks -- Virus Warning Message (on tjintranet) T_chamado06f.xls.lnk is removed from here because it contains a virus. - - 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
mes0501
-- Virus Warning Message (on tjintranet) Found virus TROJ_SIRCAM.A in file mes0501.xls.pif The file mes0501.xls.pif is moved to /var/tmp/virCOE0PgUxY. - Hi! How are you? I send you this file in order to have your advice See you later. Thanks -- Virus Warning Message (on tjintranet) mes0501.xls.pif is removed from here because it contains a virus. - - 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