Gemini compile error
While compiling MySQL+Gemini-3.23.41 i received the following error: gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../incl -I../msgs -O3 -DDBUG_OFF -c dsmindex.c In file included from dsmindex.c:39: /usr/include/string.h:245: parse error before `(' /usr/include/string.h:245: warning: conflicting types for built-in function `memset' /usr/include/string.h:245: parse error before `int' make[4]: *** [dsmindex.o] Error 1 make[4]: Leaving directory `/usr/local/src/Apache/mysql+gemini-3.23.41/gemini/api' System is RedHat 7.1, with their GCC 2.96-85 While I'm on the subject, does BDB tables provide the same type of locking that Gemini does? Is there any reason to favor Gemini over BDB? -- H | Life is the art of drawing without an eraser. - John Gardner + Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 Director of Internet Operations / SysAdmin. 800.441.3873 x130 Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave, #6 http://www.pcraft.com . . .. Boulder, CO 80303, U.S.A. - 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: Gemini compile error
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 22 Nov 2001, Ashley M. Kirchner wrote: While compiling MySQL+Gemini-3.23.41 i received the following error: System is RedHat 7.1, with their GCC 2.96-85 Same here, althogh the binary version starts up fine. While I'm on the subject, does BDB tables provide the same type of locking that Gemini does? Is there any reason to favor Gemini over BDB? While on the subject: has anyone seen a WORKING gemini table? I've tried 2 different redhat systes, and 3 different debian systems, and always got the same result: starts up fine, dies in about 15 seconds, safe_mysqld tries to bring it up, so it recoveres from the crash, repeats the whole thing a few times, and then no longer recovers. Max uptime, starting with a new database, ending with an unrecoverable one, has never exceeded 30 minutes. So I'm trying Innodb tables now. Initial tests (the ones that caused gemini to die in less than a minute) have been runing for about 4 days in a row now, and it's very stable. I have yet to test what it does with 50-60k users at the same time. (That's what is causing me problems with myisam table locks now.) I need to modiy a lot of code to use row-level locks. I'll let you know about the result. :) BDB as far as I know does not support row-level locking, it has page-level locks. Attila ... Actual newspaper headline, 1/17/77: Cold Wave Linked to Temperatures - --- Public key: http://civ.hu/attila.asc -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE7/LqgDeyfLhmXxQwRAkXyAJ9yj0BLVxqQrrH9UYkTWXX18/hrAQCgiSqX 7CMbRMZz2qhiy7y/fnwqyKw= =NsLE -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error 127 Table Handle
What is Error 127 table handle error ? Restarting mysqld takes care of it. ulimit = 1024. Thanks.
Re: mysqlgui
hi glenn, try to connect from another system on network. because it is client software. if i am connecting from another system on network it is connecting. urs, sreedhar - Original Message - From: Glenn English [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 22, 2001 3:58 AM Subject: mysqlgui RH7.2 When I run 1.7.5 either static or semi static, I get Can't connect to local MySQL server through socket (111) Host name is localhost (120.0.0.1 doesn't work either). I do have access rights - running as root. -- Glenn English [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
How can I download and learn this database.
Mysql, On Linux and win2000 or Win9x. Thanks I am beginner. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.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
SV: Need help with SELECT 2 tables from choice of 3
Can't you just make a check before you make a call to the DB? if( member_id 1000 ) // old member query here else // new member query here -Ursprungligt meddelande- Fran: Jerry [mailto:[EMAIL PROTECTED]] Skickat: den 21 november 2001 21:24 Till: [EMAIL PROTECTED] Amne: Re: Need help with SELECT 2 tables from choice of 3 Why no have 3 tables: Members Data TheseMembersAreOld Members and Data are as you have them defined. TheseMembersAreOld contains only the Member_ID field. You then make the Member_ID field primary key on TheseMembersAreOld and Members. You can then perform a very fast joins. Hm, thank you for the idea... I think my problem is the OLD members and members are not the same people. That is why I have renamed them (added 10 number to every one of them), so Data table now has numbers from 1-1000 (my new members) numbers from 10 to 101000 (my old members). From old members I only need the name, nothing else! From new members I need all the data. Now because in the forum topic (yes, I am builing a custom forum) there must be a member, I need 1. If this is an old member from the old forum to disply only name 2. If member is new to display all the data. Now I have a problem of joining the 3 tables because obviously in Data field Member_ID there is a number that represents a member OR a number that represents a old member, never both (none is the same). In SQL I can not do the AND and compare both MEMBER_ID's because it would never return anything. If I use or I do get data, but not one, but multiplied number od times (every new member is then resulted or every old member, depending on in which table SQL finds the data). Yours Jerry Slovenia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How can I download and learn this database.
Hi. You will get far just by downloading it and read the manual at www.mysql.com ABDULLAH ERDOÐAN wrote: Mysql, On Linux and win2000 or Win9x. Thanks I am beginner. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.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 -- Ulf Bäckman System developer Skanova Networks Network Security - 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-3.23.44 fails to pass tests,3.23.43 also fails.
Description: $ rm -f config.cache $ ./configure --prefix=/home/crystal/local/mysql-3.23.44 $ --with-berkeley-db \ $ --with-innodb \ $ --with-charset=big5 \ $ --with-extra-charsets=latin1,gb2312 $ make clean $ make $ make test $ # mysql-3.23.39, 3.23.40, 3.23.42 can pass all tests. $ $ rm -f config.cache $ ./configure --prefix=/home/crystal/local/mysql-3.23.44 \ $ --with-berkeley-db \ $ --with-innodb $ make clean $ make $ make test $# this configuration(without charset big5/gb2312) can pass all tests. How-To-Repeat: pls. ref. Description. Fix: NA Submitter-Id: submitter ID Originator: Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: Failure to pass tests. Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.44 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Linux c2 2.4.10-4GB #1 Fri Sep 28 17:20:21 GMT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -rwxr-xr-x1 root root 1384168 Sep 20 11:52 /lib/libc.so.6 -rw-r--r--1 root root 25215580 Sep 20 11:28 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 20 11:28 /usr/lib/libc.so -rw-r--r--1 root root 856542 Oct 26 00:13 /usr/lib/libc-client.a lrwxrwxrwx1 root root 20 Nov 20 12:39 /usr/lib/libc-client.so- libc-client.so.2000c -rwxr-xr-x1 root root 718160 Oct 26 00:13 /usr/lib/libc-client.so.2000c Configure command: ./configure --prefix=/home/crystal/local/mysql-3.23.44 --with-berkeley-db - -with-innodb --with-charset=big5 --with-extra-charsets=latin1,gb2312 - 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 + WIN 2000
hi, I had posted a few days back regarding having problems running MySQL on WIN 2000... I had installed and was running MySQL and PHP with IIS successfully for nearly 2 mths now... All of sudden since a few days back the MySQL service refuses to start and keeps giving various errors such as unable to find path etc... I uninstalled and reinstalled MySQL a couple of times all in vain.. What could have happened and how may I rectify this problem... Would appreciate much if anyone can help me out on this.. TIA, sandeep - 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 Win200 problem (telnet localhost)
hi, I had posted a few days back regarding having problems running MySQL on WIN 2000... I forgot to add before, I can ping my localhost but unable to do a telnet localhost too... I had installed and was running MySQL and PHP with IIS successfully for nearly 2 mths now... All of sudden since a few days back the MySQL service refuses to start and keeps giving various errors such as unable to find path etc... I uninstalled and reinstalled MySQL a couple of times all in vain.. What could have happened and how may I rectify this problem... Would appreciate much if anyone can help me out on this.. TIA, sandeep - 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-3.23.4[34] fails to pass tests
Description: $ rm -f config.cache $ ./configure --prefix=/home/crystal/local/mysql-3.23.44 \ $ --with-berkeley-db \ $ --with-innodb \ $ --with-charset=big5 \ $ --with-extra-charsets=latin1,gb2312 $ make clean $ make $ make test $ # mysql-3.23.39, 3.23.40, 3.23.42 can pass all tests. $ $ rm -f config.cache $ ./configure --prefix=/home/crystal/local/mysql-3.23.44 \ $ --with-berkeley-db \ $ --with-innodb $ make clean $ make $ make test $# this configuration can pass all tests. How-To-Repeat: pls. ref. Description. Fix: NA Submitter-Id: submitter ID Originator: Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Failure to pass tests. Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.44 (Source distribution) Environment: System: Linux c2 2.4.10-4GB #1 Fri Sep 28 17:20:21 GMT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -rwxr-xr-x1 root root 1384168 Sep 20 11:52 /lib/libc.so.6 -rw-r--r--1 root root 25215580 Sep 20 11:28 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 20 11:28 /usr/lib/libc.so -rw-r--r--1 root root 856542 Oct 26 00:13 /usr/lib/libc-client.a lrwxrwxrwx1 root root 20 Nov 20 12:39 /usr/lib/libc-client.so - libc-client.so.2000c -rwxr-xr-x1 root root 718160 Oct 26 00:13 /usr/lib/libc-client.so.2000c Configure command: ./configure --prefix=/home/crystal/local/mysql-3.23.44 --with-berkeley-db --with-innodb --with-charset=big5 --with-extra-charsets=latin1,gb2312 - 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 installation problem on NT
Hi, all, I tried to install mySQL on Windows NT (Service Pack 6). That means: Unzipping, installing, then starting mySQL as a service with : mysqld-nt --install. Until now everything worked fine and we saw the service in the NT's Service list. But we could not start the service. Neither with NT nor with NET START mysql from the DOS box. There was an error 1067. One more thing to explain: We installed mySQL in a directory D:\inst\\ When we started: mysqld-nt --install there was no file my.cnf. (Because my installation in the office is in C:\mysql I forgot to save my.cnf in WINNT). Maybe thats the problem. But I don´t know. Second question: How to get rid of the mysql-service in the NT service list. You see I'm not very accustomed to WIN NT. I hope somebody will help me. Many thanks in advance Joachim - 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
hanging slaves and slave_read_timeout
Hi, We're replicating databases across a firewall with a 300 second reflective ACL timeout set. This causes occasional problems with replication, where if the master is idle for more than 300 seconds, the connections are closed by the firewall in such a way that the slaves never notice. That is, show slave status reports that the slave is running when in fact it has stalled. I see that in the manual there is a slave_read_timeout option which looks like it might fix this problem ( if I upgrade my servers) - but I'm not sure I'm reading the document properly. Is it the case that if slave_read_timeout is set to 150 seconds, and if the connection goes quiet for 150 seconds, then the slave will close and reopen the connection ? (Which is what I want) regards, Martin - 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
SV: Need help with SELECT 2 tables from choice of 3
You can join all three tables together select d.members_id, m.name, old.name from data as d left join members as m on m.members_id=d.members_id left join oldmembers as old on old.members_id=d.members_id If the members_id belongs to an old member, all fields from the member table will be null. If it's a new member, all fields from the old member table will be null .. That way you only need to query the database once. Then, in your PHP/ASP code you check if id 1000 and if it is you use the fields from the new members table... d.members_id, m.name, old.name 1 NULLname1 100 NULLname2 2000name2 NULL /torgil I left joined the DATA with MEMBERS and in a loop when displaying records, when I see that the MEMBER_ID belongs to the old member, I open another recordset that get's me his name from OLDMEMBERS table. I thought that this is better than the first solution because when my database grows, all of the new messages will be from new members, not old, so the condition to open recordset in for...next loop would not be executed. Is my thinking valid? Yours Jerry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqlgui
Glenn English writes: RH7.2 When I run 1.7.5 either static or semi static, I get Can't connect to local MySQL server through socket (111) Host name is localhost (120.0.0.1 doesn't work either). I do have access rights - running as root. -- Glenn English [EMAIL PROTECTED] Hi! All you have to do is follow instructions from README that came with distro. Here is a relevant part : When you start mysqlgui for the first time, you'll need to tell it how to connect to the MySQL server. To do this, click on the ``Options'' button. Select the ``Server'' tab and fill in the fields that indicate where to find the server. On Unix, if you have problems with mysqlgui not knowing the location of the socket file for connections to localhost, enter the full pathname of the socket file in the ``SQL command on the start-up'' field. On Windows, this field is used if you wish to specify the named pipe option. Then select the ``Client'' tab and fill in your MySQL user name. Take care to select the right value for the ``Ask for password'' button, depending on whether or not you want mysqlgui to prompt you for your MySQL password. After you have filled in the server and client values, click on the ``Save'' button. From then on, each time mysqlgui starts up, it will connect to the MySQL server automatically. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Database system architecture
Hi. We're in the process of making a database driven website for a client and I'd like to clear one doubt. There are going to be two frontend machines w/ apache on linux and one shared NAS on the back for the all data (possibly a Netapp box). My question is: is it a good idea to have the database files on a NAS mounted partition on each frontend and a MySQL server on each too? This way both servers are going ot access the same set of data, but I was fearing of file locking errors or something like that. BTW, DB use on inserts/updates is not going to be very heavy. If this isn't a good idea... any insights about how to make this setup to be optimal? Thanks. -- Luis - 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
.pid file missing
I think I erased my .pid file in a misguided effort to reset my password, does anyone know how to re-create it or do I need to do a full SQL re-install? Thanks - Mike __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie query
At 10.08 21/11/01 -0700, Steve Meyers wrote: Wait for 4.1, it will have multi-table updates in it. Until then, you'll have to use two separate queries. Steve i'm also new to mysql but i think you can use MERGE tables. Couldn't you ? == dott. Ivano Mario Luberti Archimede Informatica societa' cooperativa a r. l. Via G. Ferraris 12 - 56121- Ospedaletto- Pisa tel.: +39-050-3132300 fax: +39-050-3132301 e-mail: [EMAIL PROTECTED] web: http://www.archicoop.it - 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
opinion - voating
Any one have example Banking software written in PERL or PHP with MySql Database. if you have one mail me or provide me the URL of such software. I don't think there are many banks that don't pay insane amounts for Oracle or IBM to come in and design all their systems. - 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 with MyODBC Access
Hi I recently upgraded MyODBC as you stated on our terminal server and two PCs. Now I tried running the install.bat file but it didn't seem to work so I just looked at the batch file and did it all manually. I believe for some odd reason the variable %windir% wasn't working. Either way the upgrade seem to go over well. The only issue I noticed since upgrading MyODBC to 2.50.39.00 is that now I have two MySQL drivers installed or so it appears. The first driver is MySQL and the second is MySQL Driver. Both show the version at 2.50.39.00 and company as MySQL AB. Is this a problem? The main reason I ask is for some odd reason on our terminal server the users using MyODBC are prompted with the MyODBC dialog box and seems to be missing the password. I've checked the registry and it's in their perfectly. If you enter the password manually when the dialog box appears it works with no problem. I do not want the users knowing this password (even though they could look it up in the registry, smile). How do I stop this dialog popping up and use the password I providing the System DSN profile? Is this issue maybe related to me having to MySQL drivers? -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 6:17 AM To: Adam Douglas Subject: RE: MySQL with MyODBC Access Just download the driver files and copy them to system directory by ovveriting previous files. - 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
ANN: EMS MySQL Manager 1.21 released
Dear Sirs and Madams, EMS HiTech company is announcing the next version (1.21) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml Since now MySQL Manager will be releasing in two editions - Lite and Professional. MySQL Manager Lite is an expensive but effective and powerful tool for MySQL server administration. It includes all MySQL Manager features except of BLOB Viewer/Editor, Visual Query Builder, metadata printing, data export/import and something more. The full list of difference between Lite and Professional editions you can find at http://www.mysqlmanager.com What's new in version 1.21? 1. Database Registration: Database Font Charset parameter was added. Now you can define a character set to represent data in the grid. Charsets available are DOS866, ISO8859-2, KOI8-R, KOI8-U, WIN1250 and WIN1251. 2. Fixed bug with number of records to limit in the Data View. Now this setting works properly. 3. Fixed bug with editing of the field that is a part of primary key. 4. Fixed bug in User Manager. Now users with empty name also can be edited. 5. Some minor bugfixes and improvements. What is the EMS MySQL Manager? EMS MySQL Manager provides you powerful and effective tools for MySQL Server administration and objects management. Its Graphical User Interface (GUI) allows you to create/edit of all MySQL database objects most easy and simple way, run SQL scripts, manage users and administrate users' privileges, visually build SQL queries, extract or print metadata, export/import data, view/edit BLOBs and many more services that will make you work with MySQL server as easy as you want... Best regards, EMS HiTech development team. http://www.ems-hitech.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: .pid file missing
On Thu, 22 Nov 2001 05:56:21 -0800 (PST), Michael Bevan [EMAIL PROTECTED] wrote: I think I erased my .pid file in a misguided effort to reset my password, does anyone know how to re-create it or do I need to do a full SQL re-install? Thanks - Mike No, simple restart the MySQL server. Make sure it's properly been shutdown, then restart it. I will automatically create the pid file. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error when running myql on Linux 7.1
Dana, What I did, to set up a second MySQL on our Linux box, compiled the second copy from source, which gives you a lot more control on how MySQL is installed. then created a my.cnf file with all the relavent settings for the second server, port and socket, pid ...etc.. then put this in the datadir folder. Then when I start up the second server i simple do: safe_mysqld --defaults-file=/path/to/datadir/my.cnf then it starts up the second serve without any problems. We are current running two separate servers. 3.23.40 and 3.23.44 and it's been working fine for about a month now. :) On Thu, 22 Nov 2001 10:38:56 -0600, Dana Sharvit [EMAIL PROTECTED] wrote: Hello, As you probably know mysql comes installed in Linux 7.1 as default. I installed my own mysql server in a different location in the file system, In safe_mysqld I indicated the path in which I want the mysql.sock to be created in but when I start my mysql server I get an error message: Can't start server : Bind on unix socket: No such file or direc tory 06 9:56:26 Do you already have another mysqld server running on socket: /v ar/lib/mysql/mysql.sock ? 06 9:56:26 Aborting the default mysql server on Linux 7.1 is not running but even though I can not run my own mysql server. In order to solve this I created a symbolic link between /var/lib/mysql/mysql.sock to the path of my mysql server and that works fine but I am looking for a better solution - does some one have an idea? Thanks Dana - 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 Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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: replication howto
Hi! On Nov 22, Attila Beno wrote: I have a quick question about replication: how does it process transactions? Does it store all the commands, or does it just store the ones that were commited? Only committed. And: can I use replication with different table fortams on teh master and slave? Yes. Let's say I have innodb tables on the master, for row-level locking (speed). And I just have myisam tables on the slave, which would just be used for backup purposes. Myisam takes up less space. Would this work, or because of inodb transactions, I need to have innodb tables on the slave as well? No - it's a useful trick, indeed. It would work. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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: replication howto
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Thu, 22 Nov 2001, Sergei Golubchik wrote: I have a quick question about replication: how does it process transactions? Does it store all the commands, or does it just store the ones that were commited? Only committed. Let's say I have innodb tables on the master, for row-level locking (speed). And I just have myisam tables on the slave, which would just be used for backup purposes. Myisam takes up less space. No - it's a useful trick, indeed. It would work. Thanks a lot. I think this will be very useful. (Probably for others, too. :)) Attila ... Actual newspaper headline, 1/17/77: Cold Wave Linked to Temperatures - --- Public key: http://civ.hu/attila.asc -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE7/TXADeyfLhmXxQwRAtmuAKCKhwL66jRGLET02WBTgUTG4fq0jwCgkivl ZuUdEuqhIZ9iBxjR4I7ZK64= =zWcf -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to update part of a field ?
Hello all, I've got some e-mails addresses on an e-mails database where one domain has been changed to another. So I have : email1@domain1 email2@domain1 I need to change @domain1 to @domain2 on this e-mail field and keep the user name. Some e-mails of an specific ISP had their domains changed but the usernames remained the same. So I need to update this table that has some hundreds addresses of this particular domain that had been changed. Is there any way to do it through a SQL statement? Thank you, Carlos Fernando. Linux User #207984 - 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
Export just part of a table to a CSV file
Hello all, Usually I back-up my tables importing them to .csv files. What I do is I issue the following command : mysqldump - h localhost -u user -ppassword --tab=/tmp --fields-terminated-by=; database_name table_Name table.csv This creates a file called table.csv by dumping all the contents of table_Name of database_name database and separating their fields with a ;. What I would like to do is to do the same but with an SQL statement. Meaning, I would like to dump just part of the table through a SQL statement. Is there any way to do it? Thank you, Carlos Fernando. - 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
Test
Sorry, new MySql user test. - 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 with MyODBC Access
Hi, -Original Message- From: Adam Douglas [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 22, 2001 6:54 AM To: '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com (E-mail) Subject: RE: MySQL with MyODBC Access Hi I recently upgraded MyODBC as you stated on our terminal server and two PCs. Now I tried running the install.bat file but it didn't seem to work so I just looked at the batch file and did it all manually. I believe for some odd reason the variable %windir% wasn't working. Either way the upgrade seem to go over well. The only issue I noticed since upgrading MyODBC to 2.50.39.00 is that now I have two MySQL drivers installed or so it appears. The first driver is MySQL and the second is MySQL Driver. Both show the version at 2.50.39.00 and company as MySQL AB. Is this a problem? The main reason I ask is for some odd reason on our terminal server the users using MyODBC are prompted with the MyODBC dialog box and seems to be missing the password. I've checked the registry and it's in their perfectly. If you enter the password manually when the dialog box appears it works with no problem. I do not want the users knowing this password (even though they could look it up in the registry, smile). How do I stop this dialog popping up and use the password I providing the System DSN profile? Is this issue maybe related to me having to MySQL drivers? It should be {MySQL} only, might be the .rsp file got the wrong driver name. Any way, that shouldn't cause any problems in the driver behaviour as both of them are listening to the same driver DLL. You can correct it by removing the other one :) PS : Please, don't put everything in a single paragraph, as this is making hard to read. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 6:17 AM To: Adam Douglas Subject: RE: MySQL with MyODBC Access Just download the driver files and copy them to system directory by ovveriting previous files. - 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
Got error 127 from table handler
I'm getting Got error 127 from table handler on specific tables quite regularly, what does this indicate and how do I avoid it ?
Webdav
Hi, Does anyone have any experience in using webdav with apache to update a mysql db? Any pointers? I'd like that when a user uploads a file using webdav to then move the file to a new location on the server and enter the filename and file location into a mysql database. my system is using linux rh, mysql, mod_perl, apache etc. thanks in advance Scott - 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: Got error 127 from table handler
Hi! On Nov 22, Stuart Scamman wrote: I'm getting Got error 127 from table handler on specific tables quite regularly, what does this indicate and how do I avoid it ? % perror 127 127 = Record-file is crashed So - repair your tables. If the error still persists, report the bug. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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: Webdav
On Thu, Nov 22, 2001 at 09:25:47PM +0200, Scott Alexander wrote: Hi, Does anyone have any experience in using webdav with apache to update a mysql db? Any pointers? I'd like that when a user uploads a file using webdav to then move the file to a new location on the server and enter the filename and file location into a mysql database. my system is using linux rh, mysql, mod_perl, apache etc. There are probably WebDAV modules available for Perl/mod_perl. If so, it's just a Simple Matter of Programming. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 77 days, processed 1,690,142,428 queries (251/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to send multiple SQL statements using C API mysql_query?
I would like to send multiple SQL statements using the C API mysql_query. I have a large string with 20 SQL statements. When I call mysql_query with that string, only the first one is processed. Is there a way to do what I'm doing without separating the statements into individual calls to mysql_query? I beleive this is not possible. If it were, it would give lots of people many hours of headache. Imagine a badly written script, where you can escape out from the original query, like update articles set author='$author' If you can make several statements with one query, you could make $author = whatever'; drop database It's STILL dangerous even without being able to insert a separate query. Granted, with a select the attacker could probably only dump your entire database, using something like $author = whatever' or 1 If you have a MySQL-driven web page and putting special characters like single quotes into an input field can draw SQL errors, you've got a BIG problem, unless you really don't care about having your site and/or database hacked (In which case I'd prefer you take it down, as I don't want SPAM relayed through your site showing up in my mailbox.) Quote your input properly (as with mysql_escape_string()) or validate it before feeding it to MySQL. Also, be very careful about allowing stuff INTO your database which will be blatted out unchecked into a web page. It's easy to insert malicious Javascript or an offensive banner ad into even a moderately long text field, like one intended for a Subject: line. Gordon L. Burditt - 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: does each database connect cause mysqld to fork?
In the last episode (Nov 21), Bennett Haselton said: Do you mean processes instead of threads? (ps lists each *process* separately, along with its process ID, but doesn't list separate threads within each process. If mysqld handles each new connection by calling fork(), then I think fork() creates a new process, not a new thread.) Linux's threads implementation creates a process for each thread. -- Dan Nelson [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
How do I count using two tables
Hi Having a bit of bother with this one, wondering if anyone has the answer, I've got two tables one is News items News_IDNewsetc... 1Today in .etc 2Hello world .etc 3Blar di blaretc 4And now time for something else . . 100The last thing and the other is comments on the news items (as well as other things on the web site) TypeComment_IDComment etc... News1What about today then... News1This is still today... News4This parot is dead.. NotNews 4Hello.. What I am trying to get is one SELECT statment that will give me News_IDNews Comment_Count etc... 1 Today in ... 2 2 Hello world. 0 3 Blar di blar0 4 And now ...etc 1 I've tried quite a few SELECTs using LEFT JOIN and HAVING and the best I can do is a news list showing only Items that have Comments so the above would have returned only NEWS_ID 1 and 4 but not giving 2 and 3 were I want 1,2,3,4.100. Please help, sorry if this is kids stuff but I'm only just starting with MySQL. Cheers Karl. - 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: argument to --with-mysql option for PHP
Happy thanksgiving everyone! And I especially thank those involved in MySQL development and other open source projects -- you really make the computer world a better place for all of us! I also have a problem that I hope some can help me with ;-) I wrote earlier in this thread, trying to compile PHP 4.0.6 as a DSO for Apache with MySQL. With helpful feedback from Ravi, I used ./configure with the following options: --with-xml --with-zlib --with-mysql=/usr/local/mysql --with-apxs=/usr/sbin/apxs And it compiled -- but returned a warning. I can't copy and paste the warning because it's on my other machine, but I have transcribed it as verbatim as I can: = WARNING: This library needs some functionality provided by -lmysqlclient. I have the capability to make that library automatically link in when you link to this library. But I can only do this if you have a shared version of the library, which you do not appear to have. = This warning was repeated, and then another warning: = WARNING: libtool could not satisfy all declared inter-library dependencies of module libphp4. Therefore, libtool will create a static module, that should work as long as the dlopening application is linked with the -dlopen flag. = I searched all over my drive for lmysqlclient.so, but could only find lmysqlclient.?a . (I forget the exact letter, it was either lmysqlclient.sa or lmysqlclient.la .) This file was located in the source tree from the build area where I first gnutarred mysql-3.23.44 . I'm not very familiar with the workings of compilers, but I take it that I am missing some library needed for PHP to operate as a DSO in Apache, and that this library is lmysqlclient.so . I'm surprised that it isn't located in my source compile of MySQL. Should I download this file from somewhere else? If I try to run 'make install' without linking this file first, I get the following message at the end of the install: . . . (install messages) . . . cp libs/libphp4.so /usr/libexec/httpd/libphp4.so cp: libs/libphp4.so: no such file or directory apxs:Break: Command failed with rc=1 make[1]: *** [install-sapi] Error 1 make: *** [install-recursive] Error 1 Bash2.05$ Seems that libphp4.so did not get built during the 'make'. And I assume that this happened because the 'make' process could not find the lmysqlclient.so . Am I very far off the mark in this guess? Thanks to any who can help with this quandary! Sincerely, Erik Price --- Ravi Raman [EMAIL PROTECTED] wrote: You're right. ./configure --help for more information. -Original Message- If anyone can tell me which directory I should add, that would be great. I assume that it is '--with-mysql=/usr/local/mysql' , but I wanted to make sure. = Microsoft e[X]tra [P]roprietary -- Is this where you really wanted to go today ? -- http://www.redhat.com/about/opinions/xp.html __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - 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
bin files
So I have found out that mysql creates bin logs of all queries so that it can do rollbacks and such. But is it really necessary for it to maintain these logs forever so that they end up to be 10gigs + for only a few thousand current rows. Ric - 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 Newbie and Access Database
Hello all, I just start up with mysql so I have some stupid questions to ask. right now I have an MS Access database with one table that has 25 fields and like 2000 records in it. I'm trying to move to MySQL in order to have a better DB. I can define the database and the table manually that's not a problem, My problem is how can I export the 2000+ records from the Access DB to MySQL DB. does an export file from access do the job??? I read a little bit about myODBC, does myODBC help me in this situation, does it help me export all the records to the new database??? thank you Gerardo Amaya - 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: bin files
the bin log files are actually files for binary logs fused in replication. To do rollbacks and such, you need to use innodb table types. Innodb has table locking, commits, rollbacks, etc and also special log files to handle the rollbacks. Read more about innodb table types in the Mysql help. Otherwise, you can rotate the bin logs buy doing mysqladmin flush-logs This will create a new bin log file, incrementing the file extension by one. If you are not doing replication, then there is no need to have the bin log files and you can disable them in you /etc/my.cnf (or wherever your my.cnf file is) file by hashing out the line with: log-bin server-id = x (where x is a number) to #log-bin #server-id hope this helps. cheers richard ward Richard Clarke [EMAIL PROTECTED] 11/22/01 11:06PM So I have found out that mysql creates bin logs of all queries so that it can do rollbacks and such. But is it really necessary for it to maintain these logs forever so that they end up to be 10gigs + for only a few thousand current rows. Ric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: query
I think you want to do the following (notice the parentheses next to the mysql function named now): SELECT * FROM Table WHERE col1 = now() AND col2 = now(); Bye, Neil On Wed, 21 Nov 2001, Auri Net SAC wrote: Hi it is possible select * from table where col1 = now and col2=now where col1 and col2 are date type thnaks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
default values
When I do a describe statement, I see some default values assigned automatically to columns in the table. What statement will assign a column to blank, so that there is no default value assigned? - 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 Newbie and Access Database
Hi Jose, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jose Gerardo Amaya Giron Sent: Thursday, November 22, 2001 1:11 PM To: [EMAIL PROTECTED] Subject: MySQL Newbie and Access Database Hello all, I just start up with mysql so I have some stupid questions to ask. right now I have an MS Access database with one table that has 25 fields and like 2000 records in it. I'm trying to move to MySQL in order to have a better DB. I can define the database and the table manually that's not a problem, My problem is how can I export the 2000+ records from the Access DB to MySQL DB. does an export file from access do the job??? I read a little bit about myODBC, does myODBC help me in this situation, does it help me export all the records to the new database??? Yes. You can make use of MyODBC to export tables and/or associted data from MS Access to MySQL. Here is the snippet from new MyODBC manual on how to export data from MS Access to MySQL. Q. Export a table or query to MySQL using MyODBC data source Note: You can only export a table or query to MySQL server, if you have installed the latest MyODBC driver 2.50.38 or grater, else you will experince problems with text and varchar data types. 1. In the Database window (The window that appears when you open an Access database or an Access project. It displays shortcuts for creating new database objects and opening existing objects.), click the name of the table or query you want to export, and then on the File menu, click Export. 2. In the Export Object Type 'Object name' To dialog box, in the Save As Type box, click ODBC Databases (). 3. In the Export dialog box, enter a name for the file (or use the suggested name), and then click OK. The Select Data Source dialog box is displayed; it lists the defined data sources for any ODBC drivers installed on your computer. 4. Click either the File Data Source or Machine Data Source tab, and then double-click the MyODBC data source that you want to export to To define a new data source for MyODBC driver, please follow the instructions from: http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#Installi ng_MyODBC 5. Microsoft Access connects to the MySQL server through MyODBC data source and creates the new table in the server. Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: default values
Mark writes: When I do a describe statement, I see some default values assigned automatically to columns in the table. What statement will assign a column to blank, so that there is no default value assigned? Short answer: you can't. There was a long thread about this a week or two ago, and apparently the lack of default-free columns is due to some internal details, as well at to the paradigm of letting applications verify data instead of having the RDBMS do it. Note though that for strings, ENUMs and SETs you can specify a default of '', the special ENUM value '' and the empty set respectively. Also, columns that can be NULL can have a default of NULL. On an altogether unrelated matter: Your time zone is set to pacific time, but your time reveals that you're somewhere on the American east coast. You might want to correct your TZ. //C - defaults to being tired -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HOW TO : Run wave files stored in BLOB field ???
Hi all, This the first post for me to this lists I appreciate If I take a good picture as I hear... I creat table in MySQL like this CREATE TABLE test ( ItemID INT NOT NULL AUTO_INCREMENT, FirstNameCHAR(50), LastName CHAR(50) NOT NULL, SoundLONGBLOB, PRIMARY KEY (ItemID) ); the Sound field is for storing wave files , it is stored ok now I want to run this wave from this field . I'm trying to use this methode by using ASP with MySQL... == Listenwav.asp File == %@ LANGUAGE=VBSCRIPT % % ' Clear out the existing HTTP header information Response.Expires = 0 Response.Buffer = TRUE Response.Clear ' Change the HTTP header to reflect that an audio is being passed. Response.ContentType = audio/wave StrConnection = driver={MySQL};server=127.0.0.1;database=test Set ADODataConn = Server.CreateObject(ADODB.Connection) ADODataConn.Open strConnection Set rs = ADODataConn.Execute(SELECT Sound FROM Test WHERE ItemID=1 ;) Response.BinaryWrite rs(Sound) Response.End % the HTML File will be == Listen.htm FILE == HTML BODY EMBED src=ListenWav.asp autostart=true loop=false /EMBED /BODY /HTML = this way is not working ... I don't know way ... Can any one tell me way , or how can I do it with another way... NOTE THAT I DO SAME WAY TO DISPLAY IMAGE AND IT IS WORKING FINE !!! Thanks in advance __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - 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: opinion - voating
At 12:45 PM -0500 11/21/01, Auri Net SAC wrote: Hi it is possible select * from table where col1 = now and col2=now where col1 and col2 are date type thnaks Yes, except that it should be now() rather than now. - 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: Gemini compile error
At 9:43 AM +0100 11/22/01, Attila Beno wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 22 Nov 2001, Ashley M. Kirchner wrote: While compiling MySQL+Gemini-3.23.41 i received the following error: System is RedHat 7.1, with their GCC 2.96-85 Same here, althogh the binary version starts up fine. While I'm on the subject, does BDB tables provide the same type of locking that Gemini does? Is there any reason to favor Gemini over BDB? While on the subject: has anyone seen a WORKING gemini table? I've tried 2 different redhat systes, and 3 different debian systems, and always got the same result: starts up fine, dies in about 15 seconds, safe_mysqld tries to bring it up, so it recoveres from the crash, repeats the whole thing a few times, and then no longer recovers. I've not had any problems with GEMINI tables, though I've seen something like what you describe with BDB tables. RedHat 7.0, gcc 2.96-85. - 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: Gemini compile error
Hi Ashley, - Original Message - From: Ashley M. Kirchner [EMAIL PROTECTED] While compiling MySQL+Gemini-3.23.41 i received the following error: [...] System is RedHat 7.1, with their GCC 2.96-85 No idea about Gemini, but we do have an advisory against using gcc 2.96 on RedHat to compile MySQL, it appears to produce faulty code. We currently use gcc 2.95 to create our binary distribution. While I'm on the subject, does BDB tables provide the same type of locking that Gemini does? Is there any reason to favor Gemini over BDB? BDB locks on page level. You'll want to have a look at the InnoDB tables, which provide row-level locking and many other features. See http://www.mysql.com/doc/I/n/InnoDB.html If you're just starting out, I would recommend you grab the latest version from www.mysql.com (3.23.44 or 4.0.0 at the time of writing this message, but 3.23.45 will be out soon). Also, only compile from source if you really need to, otherwise it is recommended to use the binaries as provided by MySQL AB which have been compiled with optimal settings, and tested with our test suite before release. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Export just part of a table to a CSV file
Check out the 'INTO OUTFILE' portion of the SELECT statement. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT -rh Hello all, Usually I back-up my tables importing them to .csv files. What I do is I issue the following command : mysqldump - h localhost -u user -ppassword --tab=/tmp --fields-terminated-by=; database_name table_Name table.csv This creates a file called table.csv by dumping all the contents of table_Name of database_name database and separating their fields with a ;. What I would like to do is to do the same but with an SQL statement. Meaning, I would like to dump just part of the table through a SQL statement. Is there any way to do it? Thank you, Carlos Fernando. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: indexing question
If you have an index consisting of member_id mail_id (opposite order), you'll need just one index. A good explanation of why may be found at: http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html#Multiple-column_indexes -rh I for sure need an index on the mail_id field (the primary key will be between member_id and mail_id), so an index of mail_id AND member_id makes sense. This index would work for queries like: WHERE mail_id = XXX WHERE mail_id = XXX AND member_id = YYY However, that leaves out queries like: WHERE member_id = YYY That is also a query I need to be able to do on a regular basis, and if this query yields 20,000 results, with 5 million rows in the table, it's going to take forever (I assume). So I was thinking about making two indexes: mail_id AND member_id member_id Would this take up way too much disk space? - 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
4.0.0 on Linux: errmsg.sys not found; some docu bugs.
Hi, using the binary distribution mysql-4.0.0-alpha-pc-linux-gnu-i686, installed in the standard location /usr/local, running on Debian GNU Linux, I noticed the following buglets: INSTALL-BINARY and manual.txt both refer to bin/safe_mysqld which doesn't exist; they mean bin/mysqld_safe. --- Symptom: After following all instructions in INSTALL-BINARY and running bin/mysqld_safe in /usr/local/mysql, the server dies immediately. The error log file shows the message /usr/local/mysql/bin/mysqld: Fatal error: Can't find messagefile 'mysql-4.0.0-alpha-pc-linux-gnu-i686/share/mysql/english/errmsg.sys' This file is in /usr/local/mysql-4.0.0-alpha-pc-linux-gnu-i686/share/mysql/english, but apparently the server doesn't look there. Symlink from /usr/local/mysql to /usr/local/mysql-4.0.0-alpha-pc-linux-gnu-i686 is in place. Work around: start mysqld from /usr/local/mysql as bin/mysqld_safe --language=/usr/local/mysql/share/mysql/english --- Symptom: When starting mysql-test-run, the alias test reports fail, the script complains that time was not found, then stops. Reason: the mysql-test-run script uses the time command as $TIME (line 956); this doesn't work in my bash (2.04) since time is a shell builtin. Replacing $TIME by time will fix it and all tests pass. --- The benchmark tests work only with perl and DBI.pm installed; that should be documented somewhere. Thanks, Axel Severity: non-critical Priority: low Category: mysql Class: sw-bug, doc-bug Release: mysql-4.0.0-alpha (Official MySQL binary) Environment: Debian GNU Linux distribution System: Linux justin 2.2.18pre21-compact #1 Sat Nov 18 09:23:46 MST 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs gcc version 2.95.2 2220 (Debian GNU/Linux) Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Jul 5 15:58 /lib/libc.so.6 - libc-2.2.3.so -rwxr-xr-x1 root root 1124904 Jun 10 09:50 /lib/libc-2.2.3.so -rw-r--r--1 root root 2543574 Jun 10 09:52 /usr/lib/libc.a -rw-r--r--1 root root 178 Jun 10 09:52 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared - 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
Upgrade gcc on Linux
Please excuse the OT posting, but I'm am somwhat in a bind and wasn't sure where to post this question. and I've many references to upgrading from the gcc 2.91 to 2.95 I've installed all the dependency for gcc 2.95.1 and when I attempt to install the rpm gcc-2.95.1 I keep getting this message: [justligh@justlightening ~]# rpm -ivh gcc-* Preparing...### [100%] file /usr/bin/egcs from install of gcc-2.95.1-3 conflicts with file from package egcs-1.1.2-30 file /usr/bin/gcc from install of gcc-2.95.1-3 conflicts with file from package egcs-1.1.2-30 file /usr/bin/gcov from install of gcc-2.95.1-3 conflicts with file from package egcs-1.1.2-30 file /usr/bin/i386-redhat-linux-gcc from install of gcc-2.95.1-3 conflicts with file from package egcs-1.1.2-30 file /usr/bin/protoize from install of gcc-2.95.1-3 conflicts with file from package egcs-1.1.2-30 file /usr/bin/unprotoize from install of gcc-2.95.1-3 conflicts with file from package egcs-1.1.2-30 file /usr/i386-redhat-linux/lib/libiberty.a from install of gcc-2.95.1-3 conflicts with file from package egcs-1 .1.2-30 Not being fimilar with rpm's could some one be so kind, reponding off the list, as what is need to upgrade our gcc compilier.. Much appreciated and again, my appologise to the list for the OT posting database mysql Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
remove duplicates
Hi all, Is there anyway to delete the duplicate records in mysql without creating new tables. I am wondering what query will achieve this task where mysql doesnt supports like ROWID and sub queries. I appreciate if some one help me out. thankyou. -malkova. - 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 and encryption
Hi! Ken == Ken Kinder [EMAIL PROTECTED] writes: Ken Monty, is this like a product you're selling? I would like more information, Ken although I haven't gotten to this yet in my security sweep. This is something a customer of our is sponsoring and that we will put into MySQL 4.0 as soon as it's ready. We will probably also make available a patch for 3.23, but we don't have any plans to put this code into the standard 3.23 code tree to not accidently break anything for a lot of users.. We are working on a solution to this which will be available in about 3 weeks. Some of the features of this are: - We will use a strong encryption function: (des_encrypt()/des_decrypt()) ... Regards, Monty - 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
got the error when trying to run mysqld
when I try to run mysqld on Solaris 2.6 there are the errors like this ld.so.1:mysqld fatal : libCrun.so.1 :open failed : No such file or directory please help me , thank you very much - 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
Using ColdFusion with MySQL
Has anyone setup MySQL 3.23.44 with ColdFusion 5.0 Enterprise Edition. I have heard that there may be problems with transactions. I was wondering if anyone knew how to do this, and if they could point me to some reading material. I was also wondering if MySQL 4.0 would include transactions and stored procedures, and if so, when it would most likely be stable. Note I have not used 4.0, and was wondering if it would be advisable to use if I would be populating it with a lot of data, and running intense queries with respect to stability? - 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
Different tables and their purposes
Hey, I was reading over some of the stuff on this list, and I was just wondering, where I could find information on the different types of tables and their purposes since I really don't know this... :/ 1vs0 - Design by Dreams - 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
MERGE tables and INSERT_METHOD
Has anyone else tried to set the INSERT_METHOD for MERGE tables? It keeps throwing a syntax error for me. Following the docs verbatim (http://www.mysql.com/doc/M/E/MERGE.html), here's what I get: output mysql CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, message CHAR(20)); Query OK, 0 rows affected (0.02 sec) mysql CREATE TABLE t2 (a INT AUTO_INCREMENT PRIMARY KEY, message CHAR(20)); Query OK, 0 rows affected (0.00 sec) mysql INSERT INTO t1 (message) VALUES (Testing),(table),(t1); Query OK, 3 rows affected (0.00 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql INSERT INTO t2 (message) VALUES (Testing),(table),(t2); Query OK, 3 rows affected (0.00 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql CREATE TABLE total (a INT NOT NULL, message CHAR(20), KEY(a)) TYPE=MERGE UNION=(t1,t2) INSERT_METHOD=LAST; ERROR 1064: You have an error in your SQL syntax near 'INSERT_METHOD=LAST' at line 1 end_output I checked the release notes/changelog, but there's no mention of the INSERT_METHOD being broken or fixed. I'm running MySQL version 3.23.42-log on RH 7.1. -- coop - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB Compiler error (as well)
Okay, so seeing Gemini failing, it was InnoDB's turn: gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include -DDBUG_OFF -O3 -DDBUG_OFF-DDEBUG_OFF -DUNIV_INTEL_X86 -c sync0sync.c sync0sync.c: In function `sync_gnuc_intelx86_test_and_set': sync0sync.c:187: impossible register constraint in `asm' sync0sync.c:187: impossible register constraint in `asm' sync0sync.c:187: impossible register constraint in `asm' sync0sync.c:1259: confused by earlier errors, bailing out make[4]: *** [sync0sync.o] Error 1 make[4]: Leaving directory `/usr/local/src/Apache/mysql+gemini-3.23.41/innobase/sync' And while I'm sure someone is bound to tell me to stop using RedHat's GCC 2.96 because of bad code, I'm sorry. Everything else that I need/use compiles just fine and I never have problems with them, except MySQL. -- H | Life is the art of drawing without an eraser. - John Gardner + Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 Director of Internet Operations / SysAdmin. 800.441.3873 x130 Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave, #6 http://www.pcraft.com . . .. Boulder, CO 80303, U.S.A. - 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
SQL Problem
Hello Everyone, I wants to find the max. date and Login status of employee for Attendance table. The qurey runs fine but it shows me the wrong status. select max(a.dAtt_Date),a.nLog_Status from tbl_attendance a,tbl_attendance b where a.nEmp_id = 1 and a.nLog_Status = b.nLog_Status group by b.nEmp_id for example :- the data is dAtt_Date nLog_Status - --- 2001-11-20 2 2001-11-22 1 2001-11-23 1 2001-11-24 1 2001-11-24 2 Result is max(a.dAtt_Date) nLog_Status - 2001-11-24 2 2001-11-20 2 Thanks Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: does each database connect cause mysqld to fork?
At 7:14 PM -0800 11/21/01, Bennett Haselton wrote: Each time I open a database handle (in perl code), does that cause a new process to run, a new instance of mysqld? And each time I disconnect the database handle ($dbh-disconnect() in perl code), does that cause the number of running instances of mysqld to go down by one? This is explained in the manual. http://www.mysql.com/doc/L/i/Linux.html says: When using LinuxThreads you will see a minimum of three processes running. These are in fact threads. There will be one thread for the LinuxThreads manager, one thread to handle connections, and one thread to handle alarms and signals. So what you're seeing is the way Linux reports threads as processes. The process list on my Linux server includes several instances of mysqld: server1:/home/bhaselto/web/html$ ps auwx | grep mysqld root 1014 0.0 0.0 16720 ?SW Nov05 0:00 [safe_mysqld] mysql 1037 0.0 3.6 15172 9484 ?SNov05 22:10 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql -- mysql 1039 0.0 3.6 15172 9484 ?RNov05 19:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql -- mysql 1040 0.0 3.6 15172 9484 ?SNov05 0:04 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql -- mysql 4518 0.0 0.0 00 ?Z21:07 0:00 [mysqld defunct] mysql 4519 0.0 3.6 15172 9484 ?R21:07 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql -- so I was wondering if that was the explanation -- I know I have multiple running scripts that use the database at the same time, although I thought they generally didn't leave the handles open that long. -Bennett [EMAIL PROTECTED] http://www.peacefire.org (425) 649 9024 - 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: OS omissions from manual?
At 4:21 PM -0500 11/21/01, Kurt Tappe wrote: Why does the MacOS X build of MySQL 3.23 include a manual.html that contains install instructions for only Linux and Windows? I'm stuck trying to figure out how to install this thing. MacOS has no groupadd command (due to the existence of the NetInfo system), so the manual install instructions are unusable from step #1 as well. Then use NetInfo to add a user and group. http://www.latencyzero.com/macosx/mysql.html http://www.entropy.ch/software/macosx/mysql/ Thanks, -Kurt -- I haven't failed, I've found 10,000 ways that don't work. -- Benjamin Franklin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: HOW TO : Run wave files stored in BLOB field ???
Hi, -Original Message- From: Delphi Guy's [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 22, 2001 2:06 PM To: [EMAIL PROTECTED] Subject: HOW TO : Run wave files stored in BLOB field ??? Hi all, This the first post for me to this lists I appreciate If I take a good picture as I hear... I creat table in MySQL like this CREATE TABLE test ( ItemID INT NOT NULL AUTO_INCREMENT, FirstNameCHAR(50), LastName CHAR(50) NOT NULL, SoundLONGBLOB, PRIMARY KEY (ItemID) ); the Sound field is for storing wave files , it is stored ok now I want to run this wave from this field . I'm trying to use this methode by using ASP with MySQL... == Listenwav.asp File == %@ LANGUAGE=VBSCRIPT % % ' Clear out the existing HTTP header information Response.Expires = 0 Response.Buffer = TRUE Response.Clear ' Change the HTTP header to reflect that an audio is being passed. Response.ContentType = audio/wave StrConnection = driver={MySQL};server=127.0.0.1;database=test Set ADODataConn = Server.CreateObject(ADODB.Connection) ADODataConn.Open strConnection Set rs = ADODataConn.Execute(SELECT Sound FROM Test WHERE ItemID=1 ;) Response.BinaryWrite rs(Sound) Response.End % the HTML File will be == Listen.htm FILE == HTML BODY EMBED src=ListenWav.asp autostart=true loop=false /EMBED /BODY /HTML = this way is not working ... I don't know way ... Can any one tell me way , or how can I do it with another way... NOTE THAT I DO SAME WAY TO DISPLAY IMAGE AND IT IS WORKING FINE !!! I am not quite sure of ASP. As per the comments from another MyODBC user, the following code works fine to play back your wav file. HTML BODY bgsound src=listenwav.asp loop=-1 /BODY /HTML Can you try whether it works with you ? Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mac OS X text encoding
Hi all, I need to read some tab delimited text files into mysql. The files are in Mac Roman (Western) encoding. This encoding support is not there in the default installation of Mysql. Can anybody provide me the pointers as to from where can I get a binary distribution for Mac OS X with support for Mac Roman Western encoding. Any idea on how to configure Mysql if there is none... Thanks for help, With regards, Kundan - 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
Driver problem
Hi! This is Satish. I am using your mysql software for administering my database. We have developed an application using VB as the front end and mysql as the back end on all the windows plaforms(NT, 95,98,2000,ME). The problem where we are facing is while installing the driver. It works fine with NT and not with any other windows platform and we are exhausted hunting for the reason. The installation quits telling that a particular .dll is already running and sometimes quits from the installation. It would be highly appreciable if you would look into the matter and give us a right solution at the earliest since we are struggling with the software very badly. And hope you don't make us to feel bad for selecting your software by delaying the reply. Also, if the mail id what I have chosen for my query is not right suggest me the right mail id/site where I can get the solution immediately. Thank you, Regards, Satish. - 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
Connection Terminated
Hi all I have my mysql database installed on NT. I have written small VB application to upload .txt files into database. If I work from NT to NT is working fine. If I install my vb application on Win98 and having the database at NT then after couple of line reading from the text file. It gives me an error stating Cannot connect to mysql on Server {ip address}. Remember it upload the file and write to the databases after sometime only it gives an error. There is no error in SQL Insert command. Using Novell Netware. What would be the reason for it. I am really struggling to get this done. Thanx for your timely help. Regards Prabu - 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: Driver problem
Hi Satish, -Original Message- From: K. Satish Kumar [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 22, 2001 10:55 PM To: [EMAIL PROTECTED] Cc: Apparsamy perumal Subject: Driver problem Hi! This is Satish. I am using your mysql software for administering my database. We have developed an application using VB as the front end and mysql as the back end on all the windows plaforms(NT, 95,98,2000,ME). The problem where we are facing is while installing the driver. It works fine with NT and not with any other windows platform and we are exhausted hunting for the reason. The installation quits telling that a particular .dll is already running and sometimes quits from the installation. It would be highly appreciable if you would look into the matter and give us a right solution at the earliest since we are struggling with the software very badly. Please read the manual from www.mysql.com/doc (section 8.3.1), which has the detailed information on what needs to be done when the above installation error occurs. http://www.mysql.com/doc/I/n/Installing_MyODBC.html And hope you don't make us to feel bad for selecting your software by delaying the reply. Also, if the mail id what I have chosen for my query is not right suggest me the right mail id/site where I can get the solution immediately. This is also a right place, but use [EMAIL PROTECTED] for any MyODBC related queries. Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compile errors...GCC or MySQL?
Okay, so I decided to test a few things out. If I try to compile mysql+gemini-3.23.41 with no additional options, everything compiles fine, and MySQL works just fine. However, if I add --with-gemini to my configure line, it bombs during compile with: gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../incl -I../msgs -O3 -DDBUG_OFF -c dsmindex.c In file included from dsmindex.c:39: /usr/include/string.h:245: parse error before `(' /usr/include/string.h:245: warning: conflicting types for built-in function `memset' /usr/include/string.h:245: parse error before `int' make[4]: *** [dsmindex.o] Error 1 make[4]: Leaving directory `/usr/local/src/mysql+gemini-3.23.41/gemini/api' And, if I try using --with-innodb, it bombs with: gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include -DDBUG_OFF -O3 -DDBUG_OFF-DDEBUG_OFF -DUNIV_INTEL_X86 -c sync0sync.c sync0sync.c: In function `sync_gnuc_intelx86_test_and_set': sync0sync.c:187: impossible register constraint in `asm' sync0sync.c:187: impossible register constraint in `asm' sync0sync.c:187: impossible register constraint in `asm' sync0sync.c:1259: confused by earlier errors, bailing out make[4]: *** [sync0sync.o] Error 1 make[4]: Leaving directory `/usr/local/src/mysql+gemini-3.23.41/innobase/sync' Okay, so why does it compile, and function just fine when no options are specified, and it blows up miserably whenever I try to use either Gemini or InnoDB? System is still RH 7.1, with GCC 2.96 (no, it hasn't changed since I posted earlier, and I'm not about to go through the hassle of downgrading my GCC just because MySQL can't compile properly, when every other application does - I find it hard to justify pointing a finger at GCC for this.) -- H | Life is the art of drawing without an eraser. - John Gardner + Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 Director of Internet Operations / SysAdmin. 800.441.3873 x130 Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave, #6 http://www.pcraft.com . . .. Boulder, CO 80303, U.S.A. - 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
corrputed tabel questions...database,sql,query,table
database,sql,query,table database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I have a tabel that seems to be corrupted. Is there a way to fix it? It is running on a Lynx box. Thank you Jim R. - 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: Connection Terminated
Hi Prabhu, -Original Message- From: Prabhu Venkata [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 22, 2001 11:14 PM To: '[EMAIL PROTECTED]' Subject: Connection Terminated Hi all I have my mysql database installed on NT. I have written small VB application to upload .txt files into database. If I work from NT to NT is working fine. If I install my vb application on Win98 and having the database at NT then after couple of line reading from the text file. It gives me an error stating Cannot connect to mysql on Server {ip address}. This means that, the driver is not able to connect to the server specified using either the m/c name or IP address. Check your network and/or ISP issues. Are you able to ping to the specified host/IP ? Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com Remember it upload the file and write to the databases after sometime only it gives an error. There is no error in SQL Insert command. Using Novell Netware. What would be the reason for it. I am really struggling to get this done. Thanx for your timely help. Regards Prabu - 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