mysql.sock
i've fix itthanksi've got another problem... when i rebooted the system...i can't anymore connect to the mysql database ...error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' thanks, rizal Megan Payne wrote: It is looking for the DBD perl module and can't find it. Have you installed it? Megan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Raymund D. Nones Sent: Monday, May 14, 2001 5:38 AM To: [EMAIL PROTECTED] Subject: Can't locate DBD/mysql.pm Everytime i connect to my database using perl i get this error message : install_driver (mysql) failed: Can't locate DBD/mysql.pm in @INC Can anyone help me ? Thanks. rizal -- If you think your playing too much, play more -Tilde -- If you think your playing too much, play more -Tilde
how to creat stored procedure ??
Hi, i am a new userof mySQL, however i have experience inMSSQL server. ihave difficulties on creating stored procedure, triggers and views in mySQL. /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the addressee indicated in this Message (or responsible for delivery of this Message to such person),you are hereby notified that any dissemination, distribution, printing or copying of this Message or any part thereof is prohibited. Please delete this Message if received in error and advise the sender by return e-mail. Opinions, conclusions and other information in this Message that do not relate to the official business of this company shall be understood as neither given nor endorsed by this company. This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) *Scanner Engine powered by Norman Virus Control \--/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Keep restarting. help pls
Could anyone pls help ? I have installed mysql-3.23.38-1 into my linux server (SuSe) 6.4 Kernel 2.2.14 It keep dying and restart itself. Here is the Error log file listing: Number of processes running now: 2 mysqld process hanging, pid 16852 - killed mysqld process hanging, pid 16851 - killed 010523 15:59:10 mysqld restarted Number of processes running now: 2 mysqld process hanging, pid 16882 - killed mysqld process hanging, pid 16881 - killed 010523 15:59:10 mysqld restarted .. I tried to start it by running mysqld and got the following error: root@ns2:/usr/sbin ./mysqld Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 010523 15:28:08 Aborting 010523 15:28:08 ./mysqld: Shutdown Complete Also, when i start it using mysql start. it keep looping the following messages: Number of processes running now: 2 mysqld process hanging, pid 21837 - killed mysqld process hanging, pid 21836 - killed 010523 16:36:13 mysqld restarted /usr/bin/safe_mysqld: line 274: 21864 Segmentation fault $NOHUP_NICENESS $l edir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OP TION --pid-file=$pid_file --skip-locking $err_log 21 Number of processes running now: 2 mysqld process hanging, pid 21867 - killed mysqld process hanging, pid 21866 - killed 010523 16:36:13 mysqld restarted /usr/bin/safe_mysqld: line 274: 21894 Segmentation fault $NOHUP_NICENESS $l edir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OP TION --pid-file=$pid_file --skip-locking $err_log 21 Number of processes running now: 2 mysqld process hanging, pid 21897 - killed mysqld process hanging, pid 21896 - killed 010523 16:36:14 mysqld restarted Is there anyone know how to fix this problem ? THX
Re: how to creat stored procedure ??
Neither triggers, views or stored procedures are supported by MySQL. However you can write your application in a way so that you don't need either of them. Alice wrote: Hi, i am a new user of mySQL, however i have experience in MSSQL server. i have difficulties on creating stored procedure, triggers and views in mySQL. -- Frank Schröder [EMAIL PROTECTED] AirFlash Engineering Europe www.airflash.com AirFlash Inc.
RE: why does it not work
On 22-May-01 Adrian D'Costa wrote: snip Thanks. Now I am into another problem. I am not sure whether it is php or mysql. Though it works in the command prompt of mysql. Below is the snippet of my php script. What I am trying to do is to randomly display a scroll from the special table. This happens when the page is loaded or refreshed. // sql statement $searchStmt = select special.contid, special.cityid, special.curr1, special.catalogo, special.hf, special.curr2, special.vitofferta, special.fh, special.club, special.stars, city.city,RAND as r from special,city where DATE_SUB(special.periodo, INTERVAL 3 DAY) '$tdate' and city.id=special.cityid order by r limit 1 ; var timerID=null var run=false count = 10 // counter of cycles ScrollSpeed = 800; // milliseconds between scrolls ScrollChars = 1;// chars scrolled per time period function Stop() { if(run) clearTimeout(timerID) run=false } function Start() { Stop(); Marquee() } function Marquee() { var msg = document.forms[0].message.value; var tmp = msg.substring(0,ScrollChars); msg = msg.substring(ScrollChars) + tmp; document.forms[0].message.value = msg; if(count200) { timerID = setTimeout('Marquee()',ScrollSpeed); run= true; count++; } } !-- end -- /script form ?php while($row = mysql_fetch_object($result)) Do you plan on executing a mysql_query() some time before this ? snip -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do 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
Re: Possible UPDATE bug
[EMAIL PROTECTED] writes: Description: When updating a table after it has been selected with a LEFT JOIN, some UPDATE queries execute normally without actually updating the data, unless the data to be updated is selected normally first. This script is written in mod_perl, using DBI::mysql to connect to the database. The following are the tables referenced by the query: mysql desc dealer; +--+---+--+-+-++ | Field| Type | Null | Key | Default | Extra | +--+---+--+-+-++ | dealer_id| int(8)| | PRI | NULL| auto_increment | | dealer_code | varchar(5)| | | || | group_id | int(8)| | | 0 || | emp_id | int(8)| | | 0 || | address_id | int(8)| | | 0 || | dealer_name | varchar(200) | | | || | dealer_state | int(8)| | | 0 || | dealer_zip | varchar(5)| | | || | dealer_contact_fname | varchar(100) | YES | | NULL|| | dealer_contact_lname | varchar(100) | YES | | NULL|| | dealer_URL | varchar(200) | YES | | NULL|| | dealer_email | varchar(100) | YES | | NULL|| | dealer_password | varchar(100) | YES | | NULL|| | dealer_ph1 | varchar(25) | YES | | NULL|| | dealer_ph2 | varchar(25) | YES | | NULL|| | dealer_fax | varchar(25) | YES | | NULL|| | active | enum('Y','N') | | | N || +--+---+--+-+-++ 17 rows in set (0.00 sec) mysql desc dealer_lead_method; +---++--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---++--+-+-+---+ | dealer_id | int(8) | | PRI | 0 | | | method_id | tinyint(4) | | PRI | 0 | | | method_parameters | text | YES | | NULL| | +---++--+-+-+---+ 3 rows in set (0.00 sec) mysql desc tlkp_dealer_lead_method; +-+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-++ | method_id | tinyint(4) | | PRI | NULL| auto_increment | | method_name | varchar(50) | YES | | NULL|| +-+-+--+-+-++ 2 rows in set (0.00 sec) mysql desc tlkp_address; ++--+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-++ | address_id | int(8) | | PRI | NULL| auto_increment | | export | int(8) | | | 0 || | address_addr_1 | varchar(200) | YES | | NULL|| | address_addr_2 | varchar(200) | YES | | NULL|| | address_city | varchar(200) | YES | | NULL|| | address_state | int(8) | | | 0 || | address_zip| varchar(5) | YES | | NULL|| | address_plus4 | varchar(4) | YES | | NULL|| | cdate | int(8) | | | 0 || ++--+--+-+-++ 9 rows in set (0.01 sec) mysql desc tlkp_state; ++--+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-++ | state_id | int(8) | | PRI | NULL| auto_increment | | state_abbr | char(2) | YES | | NULL|| | state_name | varchar(100) | YES | | NULL|| ++--+--+-+-++ 3 rows in set (0.00 sec) The select with join: my $q = SELECT * FROM dealer, tlkp_address, tlkp_state LEFT JOIN dealer_lead_method ON dealer.dealer_id = dealer_lead_method.dealer_id LEFT JOIN tlkp_dealer_lead_method ON dealer_lead_method.method_id
Re: AW: Another signal 11 dump ...
Stephan Skusa writes: What?? ... no I haven't ... It's slightly a problem doing exact logs ... cause this Database-Server crashes every 2-4 Days ... and does about 600,000 Queries an hour ... I generated a mysqld.sym ... if anybody needs this ... I'll send it ... I think this Mailinglist does not accept this large mailings ... ;o) Hi! Please try to build a repeatable test case. We can't do much without it. We need a query that will always crash mysqld and tables involved. Check your tables for corruption, because it can sometimes be a cause of crashing. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Strange error message for create-select query
alex writes: Hi ppl! I've a strange problem - I'm creating HEAP-type table and filling it with the result of select query from a relatively big table (containing ~2187000 records). The resulting error message is the following Got error code 127 from table handler And that's all :0) I'm just wondering what's the english for 127 :0) Any help will be appritiated :0) Alexander Komratov Hi! Have you properly set MAX_ROWS when creating HEAP table ?? Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: DBD::MySQL Help!!
If this was the binary install, I had the same problemso I compiled from source.problem went away. Hi, Im trying to do the CPAN install of DBD::MySQL, Im running OpenBSD 2.7 --- I know this is prolly not the best list for this question, but its the only related list im currently subscribed to... When I do the install it askes me what db to test on and i put test, localhost for host, then i put root as the test user and my root sql users pw for the password, it does some stuff then it runs the make test and this is what happens... Any help?? Running make test PERL_DL_NONLAZY=1 /usr/local/bin/perl -I../blib/arch -I../blib/lib -I/usr/local/lib/perl5/5.6. 1/OpenBSD.i386-openbsd -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/00base/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/00basedubious Test returned status 1 (wstat 256, 0x100) t/10dsnlist./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/10dsnlist.dubious Test returned status 1 (wstat 256, 0x100) t/20createdrop../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/20createdrop..dubious Test returned status 1 (wstat 256, 0x100) t/30insertfetch./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/30insertfetch.dubious Test returned status 1 (wstat 256, 0x100) t/40bindparam.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40bindparam...dubious Test returned status 1 (wstat 256, 0x100) t/40blobs.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40blobs...dubious Test returned status 1 (wstat 256, 0x100) t/40listfields../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40listfields..dubious Test returned status 1 (wstat 256, 0x100) t/40nulls.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40nulls...dubious Test returned status 1 (wstat 256, 0x100) t/40numrows./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40numrows.dubious Test returned status 1 (wstat 256, 0x100) t/50chopblanks../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/50chopblanks..dubious Test returned status 1 (wstat 256, 0x100) t/50commit../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/50commit..dubious Test returned status 1 (wstat 256, 0x100) t/60leaks...skipped test on this platform t/ak-dbd/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/ak-dbddubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 1-90 Failed 90/90 tests, 0.00% okay t/dbdadmin../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/dbdadmin..dubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 1-20 Failed 20/20 tests, 0.00% okay Failed Test Status Wstat Total Fail Failed List of Failed --- - t/00base.t 1 256?? ?? % ?? t/10dsnlist.t 1 256?? ?? % ?? t/20createdrop.t 1 256?? ?? % ?? t/30insertfetch.t 1 256?? ?? % ?? t/40bindparam.t1 256?? ?? % ?? t/40blobs.t1 256?? ?? % ?? t/40listfields.t 1 256?? ?? % ?? t/40nulls.t1 256?? ?? % ?? t/40numrows.t 1 256?? ?? % ?? t/50chopblanks.t 1 256?? ?? % ?? t/50commit.t 1 256?? ?? % ?? t/ak-dbd.t 1 25690 90 100.00% 1-90 t/dbdadmin.t 1 25620 20 100.00% 1-20 1 test skipped. Failed 13/14 test scripts, 7.14% okay. 110/110 subtests failed, 0.00% okay. *** Error code 2 Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216/mysql (line 737 of Makefile). *** Error code 1 Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216 (line 732 of Makefile). /usr/bin/make test -- NOT OK Running make install make test had returned bad status, won't install without force Running install for module DBD::mysql Running make for J/JW/JWIED/Msql-Mysql-modules-1.2216.tar.gz Is already unwrapped into directory /root/.cpan/build/Msql-Mysql-modules-1.2216 Has already been processed within this session Running make test Won't repeat unsuccessful test during this command Running make install make test had returned bad
design question.
Ok, im working on a dynamic site with php and mysql. I allow people to upload csv files that I process via cron job and php script to get the data from the files into a table in my DB. My first thought was to read through each file line by line and do an insert for each line checking for validity of content prior to the insert. This works fine for 200k records but after that I mysql gets fussy and gives me 127 errors when I do selects etc and downright blows up if I get over 1 million records.this is all with a good test file for the import. I tried flush tables after every file import which increased the script run time 5x and I still had the same problem. My question now is, should I come at this from a different angle, read through the import files, validate the content and write the content to a new file and then use load data infile for one big input file or perhaps just validate the contents of the uploaded files and then do a load data infile for each of them? Anyways, my goal is to get around the apparent insert limitations I am running up against. - Larry Hotchkiss - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Installation Trouble
I installed the RPM from the MySQL site. I finally have it installed and the server appears to be running, but I have none of the access tools to get to the databases. I am setting this machine up in another country, so all is done via command line through ssh, that means I can't use any X tools (argh). Any help on why /usr/bin/mysql and /usr/bin/mysqladmin are missing would be of great assistance. Thanks in advance! Sean -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 22, 2001 9:27 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Installation Trouble Firstly, if you have installed RH's mysql RPM , I strongly suggest you remove it, download the latest one from the MySQL web site, both client and server, and install that version instead. BTW you don't need Perl to install mysql. If the mysql's rpms come up with a Perl dependency problem then it is a bug in the RPMs. Just install, skipping dependency check. If you want, you can then download a GUI for it, also available from the mysql web site. Oh and don't forget the mysql manual, it's your best friend. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 23, 2001 5:37 Subject: Installation Trouble I installed the RPM of 3.23 on RH 7.1 today. Everything seemed to go OK (once I got Perl in the right place), but now I don't have any client tools to access any of the databases or run sql queries. Any suggestions? Sean Tibbetts Do nothing which is of no use. Miyamoto Musashi Sean Tibbetts Web Technologies Group CFC-OTS (502) 573-3850 ext. 201 Do nothing which is of no use. Miyamoto Musashi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Cold Fusion Express
Hi. I am new to this list and I am having some problems. I have set up a small personal server at my house to set up a site for family and such. I am by trade a cold fusion developer. On the server at home I have a cold fusion express application server running on a win2k box using iis as my web server. I would like to use MYSQL as my db however my odbc settings in the cold fusion administrator does not have a driver listing for it. Will one of the other drivers work or m I stuck using access at the house? Any help would be greatly appreciated. Tim Heald Application Development http://www.schoollink.net/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Performance tweaking
I have developed a ftp searchengine, which uses a database for backend data storage. While mysql is indeed the fastest db for my needs, I wish to improve the searchtime a bit further. A typical query would be SELECT id, field FROM table WHERE field LIKE '%query%' I understand that the use of LIKE '%...' disencourages the use of indexes. Fulltext indexes are not useful either, since I want to be able to match any substring of 'field' with no regard to word boundaries. The database is about 1 mio. rows and 5 colums. Field is a varchar(255). What can be done to optimize? I have considered placing the data in memory, since speed is of more concern than data integrety. Have anybody tried that? I am very open to suggestions. Best regards Anders Johannsen Denmark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Cold Fusion Express
Perhaps MyODBC would help you out... http://www.mysql.com/downloads/api-myodbc.html Don't know for sure but it's probably worth a look :-) HTH Jon -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: 23 May 2001 13:57 To: [EMAIL PROTECTED] Subject: Cold Fusion Express Hi. I am new to this list and I am having some problems. I have set up a small personal server at my house to set up a site for family and such. I am by trade a cold fusion developer. On the server at home I have a cold fusion express application server running on a win2k box using iis as my web server. I would like to use MYSQL as my db however my odbc settings in the cold fusion administrator does not have a driver listing for it. Will one of the other drivers work or m I stuck using access at the house? Any help would be greatly appreciated. Tim Heald Application Development http://www.schoollink.net/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
fulltext match against score
Hi, I'm trying to switch my database searching over to the Fulltext method, but I'm having some problems. The search function works with single words, but when I search for multiple words I'm getting hundreds of results with no relevence to what I'm looking for. The score on these results is low, and I'm wondering if there is an established score value at which a cut can be made. It looks like query results that matched all of the search words are above 4, and after that it drops off pretty quickly. Any help would be great. If anyone can just explain how the score value is calculated that would be of great help. Thanks, John Gerstenslager - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Porting Access to MySQL
Hi, You can use DBTools (http://dbtools.vila.bol.com.br). It's free, for Win32 and imports from MSAccess, Paradox, xBase and ODBC databases. []'s Crercio O. Silva -Original Message- From: Mitchell [mailto:[EMAIL PROTECTED]] Sent: terça-feira, 22 de maio de 2001 19:43 To: [EMAIL PROTECTED] Subject: Porting Access to MySQL Hi, I have a user who want to move there database from Access to MySQL. Are there tools available to make the conversion simple, or what is the best way of going about this? 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.sock
Raymond, Make sure the mysql server is running. If it is running.. check permissions on the file. If there are ok.. find where mysql puts your mysql.sock file and add a symbolic link from it to /var/lib/mysql/mysql.sock -C -Original Message- From: Raymund D. Nones [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 10:26 AM To: Megan Payne; [EMAIL PROTECTED] Subject: mysql.sock i've fix itthanksi've got another problem... when i rebooted the system...i can't anymore connect to the mysql database ...error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' thanks, rizal Megan Payne wrote: It is looking for the DBD perl module and can't find it. Have you installed it? Megan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Raymund D. Nones Sent: Monday, May 14, 2001 5:38 AM To: [EMAIL PROTECTED] Subject: Can't locate DBD/mysql.pm Everytime i connect to my database using perl i get this error message : install_driver (mysql) failed: Can't locate DBD/mysql.pm in @INC Can anyone help me ? Thanks. rizal -- If you think your playing too much, play more -Tilde -- If you think your playing too much, play more -Tilde - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 bug
Downloaded latest version of MySQL for Win95 (3.23.38-win) on May 21st. After mysqld command this is the response: C:\cd mysql|cd bin|mysqld Innobase: Assertion failure in thread 4293273545 in file M:\mysql-3.23\innobase\ os\os0file.c line 187 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 010523 15:51:48 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 010523 15:51:48 Aborting InnoDB: Warning: shutting down not properly started database 010523 15:51:51 C:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete Can someone help me ? Thanks Claudio
RE: Sun-Solaris 2.6 binary
Jermey, I would really appreciate that. Our sysadmin said it'll take another few days before I can get the latest gnu compiler. Thanks, -eva- -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 22, 2001 3:47 PM To: Eva Hammel Cc: '[EMAIL PROTECTED]' Subject: Re: Sun-Solaris 2.6 binary On Tue, May 22, 2001 at 02:59:17PM -0400, Eva Hammel wrote: Hi, We are running on a SunOS 5.6 Generic_105181-25 sun4u sparc SUNW,Ultra-5_10 platform. I noticed that there is not a binary file for 2.6. Is there anyway way for you guys to generate one for us. If not, I can probably build one on a SunOS 5.6 Generic_105181-23 sun4m sparc SUNW,SPARCstation-20 machine that I have access to. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 2 days, processed 19,937,677 queries (79/sec. avg) THIS TRANSMISSION, INCLUDING ANY ATTACHMENTS OR FILES, CONTAINS AIRNET COMMUNICATIONS CORPORATION CONFIDENTIAL AND PROPRIETARY INFORMATION WHICH MAY BE OTHERWISE EXEMPT FROM DISCLOSURE. The information is intended to be for the exclusive use of the individual or entity named above. If you are not the intended recipient, be advised that any disclosure, copying, distribution or other use of this information is strictly prohibited. If you have received this transmission in error, please notify us by telephone at 1-321-984-1990 or by email to [EMAIL PROTECTED] immediately and do not read, print or save this information in any manner. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help with a semi-complex select statement..
I have 4 tables, named: players - stores player id, name, team id teams - teamid, teamname goals - goals scored, player id, team id penalty - penaltys accumulated, player id What I'm trying to do is write a query to get the top 10 from any category and display them. I can do them individually fine, like so: SELECT players.PLAYERID, players.FIRSTNAME, players.LASTNAME, SUM(penalty.PENALTYMINUTES) as TTPM FROM players, penalty where (penalty.PLAYERID = players.PLAYERID) GROUP BY PLAYERID ORDER BY TTPM DESC LIMIT 10 but when I try to get the goal total as well or something and add another table to the from statement, I appear to be getting too many rows back as the numbers are inflated about 10 times what they should be .. the query I'm working with is: SELECT teams.TEAMNAME, players.PLAYERID, players.FIRSTNAME, players.LASTNAME, SUM(penalty.PENALTYMINUTES) as TPM, COUNT(goals.SCORER) as TGOALS FROM players, penalty, teams, goals where (penalty.PLAYERID = players.PLAYERID AND players.TEAMID = teams.TEAMID AND goals.SCORER = players.PLAYERID AND goals.TEAMID = teams.TEAMID) GROUP BY PLAYERID ORDER BY TPM DESC LIMIT 10 I'm not sure how I would go about re-writing it to get it to work properly, and humbly beg for assistance. Thanks, Chad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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:innodb bug
Claudio, in the source distribution the macro __NT__ is defined. That makes it work only on NT and 2000. You should compile without __NT__ . See a posting by Miguel about 5 days ago. Regards, Heikki Downloaded latest version of MySQL for Win95 (3.23.38-win) on May 21st. After mysqld command this is the response: C:\cd mysql|cd bin|mysqld Innobase: Assertion failure in thread 4293273545 in file M:\mysql-3.23\innobase\ os\os0file.c line 187 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 010523 15:51:48 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 010523 15:51:48 Aborting InnoDB: Warning: shutting down not properly started database 010523 15:51:51 C:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete Can someone help me ? Thanks Claudio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
nothing append
I am using mysql 3.22.32 on solaris. when i start safe_mysqld , two process start : safe_mysqld and mysqld. But when i try to access to the database with an http request, or with mysql (the command line) nothing append ... there is nothing in var/server.err do you have an idee or where to search . Thanks Ben. P.S : with http request it's not the message when the server is not started ( Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146) ) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
works in SQL not on page
When I execute this in mysql it works fine, but when I execute it on a web page it gives a Not Unique table/alias 'sporttable' I would expect errors if 'playerpayment' was in my FROM clause but as you can see it is not. Note my example: INSERT INTO playerpayment ( Family_ID, Player_ID, Player_Fee, Sport_ID ) SELECT playertable.Family_ID, playertable.pid, sporttable.Category_1_Fee, sporttable.sid FROM sporttable, playertable WHERE sporttable.sid = playertable.SportRegistered AND (((playertable.Grade)=sporttable.Category_1_Grade_Start And (playertable.Grade)sporttable.Category_2_Grade_Start)) GROUP BY playertable.Family_ID, playertable.pid, sporttable.Category_1_Fee, sporttable.sid; mysql running on W2K-Advanced version: 3.23.33 TIA Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 (mail filter bologna: sql,database,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
Remote connect failure
Hi, I just installed mysql 3.23.37 on a FreeBSD 4.2 server. The access to the db works fine from the command line with -h=localhost option but when the localhost is replaced with the IP address it doesn't. I've added an entry in the user table with the IP address restarted mysqld. The entries in the user table are identical except for the host field. Thanks in advance, Lisa - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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:innodb bug
At 18:10 23/5/2001 +0300, Heikki Tuuri wrote: Hi, Claudio, in the source distribution the macro __NT__ is defined. That makes it work only on NT and 2000. You should compile without __NT__ . See a posting by Miguel about 5 days ago. If you don't have the VC++ compiler use mysqld-max.exe instead of mysqld.exe on Win9x and ME machines. Don't forget also to create first the log and data directories for InnoDB and write on my.ini/my.cnf the key variables for InnoDB. Regards, Miguel Regards, Heikki Downloaded latest version of MySQL for Win95 (3.23.38-win) on May 21st. After mysqld command this is the response: C:\cd mysql|cd bin|mysqld Innobase: Assertion failure in thread 4293273545 in file M:\mysql-3.23\innobase\ os\os0file.c line 187 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 010523 15:51:48 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 010523 15:51:48 Aborting InnoDB: Warning: shutting down not properly started database 010523 15:51:51 C:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete Can someone help me ? Thanks Claudio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil ___/ Development Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with Update to 3.23.38
HI, I got the following problem with apache_1.3.20 + modssl-2.8.4-1.3.20 + openssl-0.9.6a + php-4.0.5 + mysql-3.23.38. After I upgrade the system, I can only connect to mysql server via the consle window. But, I am not able to use the php-mysql command to connect to the server via the web, the following error messages pop-up. Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/shuncheong/require/Password.php on line 1 Please tell me is this a bug or something else. I have tried to reboot the server. Thank you Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Problems with sum() in a query.
I'm gaving a problem with adding several sums together when using a group by clause. The table I have looks like this: school_id int school_name varchar sport varchar cost_a float(9,2) cost_b float(9,2) cost_c float(9,2) The real table is normalized, figured it would make for a simpler example this way, so you don't have to tell me ;) Each school has records for several diffrent sports I'm trying to query for the total amount spent for each school with the following query. SELECT school_name, (sum(cost_a)+sum(cost_b)+sum(cost_c)) as total FROM schools GROUP BY school Sir, the obvious error is that school is not a column in your table. Try grouping by school_id. Bob Hall With the desired result school_1 125000.00 school_2 234642.12 school_3 98433.45 But I get zero's for the total column. If I query for only one school I get the correct numbers: SELECT school, (sum(cost_a)+sum(cost_b)+sum(cost_c)) as total FROM schools WHERE school='myschool' GROUP BY school If I query for a few schools (school_id3) sometimes I get unusual numbers, 17.24 for one example. I'm not sure what's happening with these queries so I have to ask. Am I doing the query wrong? Is SQL or mySQL not able to handle this query? Or did I find a bug in mySQL? -- Jeff Bearer, RHCE Webmaster PittsburghLIVE.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 Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak MySQL list magic words: sql query database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Documentation for using MySQL with WebMail
Could someone point me to where I could find documentation for incorporating MySQL with WebMail? http://www.linuxdoc.org/LDP/solrhe/Securing-Optimizing-Linux-RH-Edition- v1.3/webmlimp.html walks you through installing WebMail, but it assumes you are using PostgreSQL. Any help would be appreciated. Bill Tangren - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
longblob
Hello everyone, I have mySQL 3.23 running on win2000 and encounter the odd problem: longblob-type field is treated as blob-type since I cannot put data more than 64kb in size into that field. Any suggestions are highly appreciated. Best of luck, Yuriy Zubarev __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.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: Problems with sum() in a query.
The errors are in the example below not in the code that i'm working with. the group by would be school_name or school_id otherwise the query would error and I wouldn't be experiencing the oddities that I am. What it seems to be is that if I want to preform math on 2 sum functions, (+-*/) it will work if I select only one of the values in the group by field. I desire to see a list of all the distinct values of the group by field and the results of the math on the sum functions for each value, this does not work correctly. To me it seems like a bug in mysql, but I don't want to blame anybody untill I'm sure that my query is constructed correctly. Bob Hall wrote: I'm gaving a problem with adding several sums together when using a group by clause. The table I have looks like this: school_id int school_name varchar sport varchar cost_a float(9,2) cost_b float(9,2) cost_c float(9,2) The real table is normalized, figured it would make for a simpler example this way, so you don't have to tell me ;) Each school has records for several diffrent sports I'm trying to query for the total amount spent for each school with the following query. SELECT school_name, (sum(cost_a)+sum(cost_b)+sum(cost_c)) as total FROM schools GROUP BY school Sir, the obvious error is that school is not a column in your table. Try grouping by school_id. Bob Hall With the desired result school_1 125000.00 school_2 234642.12 school_3 98433.45 But I get zero's for the total column. If I query for only one school I get the correct numbers: SELECT school, (sum(cost_a)+sum(cost_b)+sum(cost_c)) as total FROM schools WHERE school='myschool' GROUP BY school If I query for a few schools (school_id3) sometimes I get unusual numbers, 17.24 for one example. I'm not sure what's happening with these queries so I have to ask. Am I doing the query wrong? Is SQL or mySQL not able to handle this query? Or did I find a bug in mySQL? -- Jeff Bearer, RHCE Webmaster PittsburghLIVE.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
Advice on Random Numbers
I need to generate a RANDOM UNIQUE number for every new record. Is there an easy way to accomplish this inside of mySQL. TIA Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 (mail filter bologna: sql,database,query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Advice on Random Numbers
On Wed, May 23, 2001 at 02:22:02PM -0400, Dave Carter spake thusly: *] I need to generate a RANDOM UNIQUE number for every new record. Is there an *] easy way to accomplish this inside of mySQL. *] The way I do this for session ids is through a perl function that I wrote a long time ago. Essentially I create a really long string of mixed case alpha characters and numeric digits. I suppose you could use the same method from perl for record numbers. -- -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ Peter L. Berghold[EMAIL PROTECTED] Schooner Technology Consulting http://www.berghold.net Unix Professional ServicesPerl Perl/CGI mod_perl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help needed
Hi there all, A little bit of a silly question here, I am used to using PHP Myadmin. What the problem is I have just been learning the command for creating etc.. using telnet, but I have a 2.5mb sql file that I need to run. The questions are; 1: How do I run this file via telnet 2: If I have to upload it where do I upload it to Your help appreciated as always. Barry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Advice on Random Numbers
*] I need to generate a RANDOM UNIQUE number for every new record. Is there an *] easy way to accomplish this inside of mySQL. *] The way I do this for session ids is through a perl function that I wrote a long time ago. Essentially I create a really long string of mixed case alpha characters and numeric digits. I suppose you could use the same method from perl for record numbers. Hmm. As a coincidence, I just rewrote a function kind of like this about 15 minutes ago. It basically does (mod_perl): my $id; while (1) { $id = int(rand(40)); my $sth = $dbh-prepare(INSERT INTO tab (id) VALUES ($id)); if ($sth-execute) { $sth-finish; last; } $sth-finish; # try again } return $sid; This ONLY works if id is a UNIQUE (ie, PRIMARY) key. It relies on the query failing to determine whether it's taken or not. This wouldn't scale very well if you need to create a million records per minute, or plan to store more than 100,000 records at a time, because at that point, it becomes easier to brute force guess a valid one. At about 40,000,000, the chances become 1 in 100 that the INSERT will fail. At 400,000,000, they're 1 in 10. Also, it can't tell the difference between real error and a duplicate key error. A bail out scheme after say, 10 tries wouldn't be a bad idea. -- Michael Bacarella [EMAIL PROTECTED] Technical Staff / System Development, New York Connect.Net, Ltd. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: DBD::MySQL Help!!
I had the same problem too. If you go to CPAN and then go to DBD::Mysql, click on the ftp site to Jochen Wiedmann's directory and scroll past the one that says DBD-Mysql-yada to the one that says Msql-Mysql-modules-1.2216.tar.gz and install that one instead, it should work. Worked like a charm for me - on RedHat. Megan Hi, Im trying to do the CPAN install of DBD::MySQL, Im running OpenBSD 2.7 --- I know this is prolly not the best list for this question, but its the only related list im currently subscribed to... When I do the install it askes me what db to test on and i put test, localhost for host, then i put root as the test user and my root sql users pw for the password, it does some stuff then it runs the make test and this is what happens... Any help?? Running make test PERL_DL_NONLAZY=1 /usr/local/bin/perl -I../blib/arch -I../blib/lib -I/usr/local/lib/perl5/5.6. 1/OpenBSD.i386-openbsd -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/00base/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/00basedubious Test returned status 1 (wstat 256, 0x100) t/10dsnlist./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/10dsnlist.dubious Test returned status 1 (wstat 256, 0x100) t/20createdrop../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/20createdrop..dubious Test returned status 1 (wstat 256, 0x100) t/30insertfetch./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/30insertfetch.dubious Test returned status 1 (wstat 256, 0x100) t/40bindparam.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40bindparam...dubious Test returned status 1 (wstat 256, 0x100) t/40blobs.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40blobs...dubious Test returned status 1 (wstat 256, 0x100) t/40listfields../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40listfields..dubious Test returned status 1 (wstat 256, 0x100) t/40nulls.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40nulls...dubious Test returned status 1 (wstat 256, 0x100) t/40numrows./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40numrows.dubious Test returned status 1 (wstat 256, 0x100) t/50chopblanks../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/50chopblanks..dubious Test returned status 1 (wstat 256, 0x100) t/50commit../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/50commit..dubious Test returned status 1 (wstat 256, 0x100) t/60leaks...skipped test on this platform t/ak-dbd/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/ak-dbddubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 1-90 Failed 90/90 tests, 0.00% okay t/dbdadmin../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/dbdadmin..dubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 1-20 Failed 20/20 tests, 0.00% okay Failed Test Status Wstat Total Fail Failed List of Failed -- - - t/00base.t 1 256?? ?? % ?? t/10dsnlist.t 1 256?? ?? % ?? t/20createdrop.t 1 256?? ?? % ?? t/30insertfetch.t 1 256?? ?? % ?? t/40bindparam.t1 256?? ?? % ?? t/40blobs.t1 256?? ?? % ?? t/40listfields.t 1 256?? ?? % ?? t/40nulls.t1 256?? ?? % ?? t/40numrows.t 1 256?? ?? % ?? t/50chopblanks.t 1 256?? ?? % ?? t/50commit.t 1 256?? ?? % ?? t/ak-dbd.t 1 25690 90 100.00% 1-90 t/dbdadmin.t 1 25620 20 100.00% 1-20 1 test skipped. Failed 13/14 test scripts, 7.14% okay. 110/110 subtests failed, 0.00% okay. *** Error code 2 Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216/mysql (line 737 of Makefile). *** Error code 1 Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216 (line 732 of Makefile). /usr/bin/make test -- NOT OK Running make install make test had returned bad status, won't install without force Running install for module
byte[] in mysql DB?
All, In order to save very large strings (fully-formatted HTML) in a mysql column, I have run it through java.util.zip's GZIP classes. The result of this process is a byte[] of variable length. I have as yet been unsuccessful at saving and retrieving this byte[]. (My column is currently a blob. I am converting each byte to a char and then adding the char to a string and inserting the string to the blob. I am in no way committed to the blob type, and would actually like to avoid the byte[] - string translation if possible.) At any rate, If anyone has any good strategies for storing a byte[] in a mysql column, please forward those ideas. Live happy, code clean, David T. MacKenzie eSpecto, Inc. o. (513) 352-0020 f. (513) 352-0040 [EMAIL PROTECTED] http://www.eSpecto.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 it not work
You didn't show the code where the mysql_query() is done. Further, you have RAND as r coded in your select statement, not RAND( ) as r. Is this live code? Cheers, Kent (filter feeder: database) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem starting Mysql
I keep getting this message in the mysql .err file I have no id as to what to do or even look at. 010519 11:57:54 mysqld started /usr/sbin/mysqld: ready for connections 010520 4:02:33 /usr/sbin/mysqld: Binlog closed, cannot RESET MASTER Status information: Current locks: key_cache status: blocks used: 1 not flushed: 0 w_requests: 0 writes: 0 r_requests: 0 reads: 0 handler status: read_key:0 read_next: 0 read_rnd 0 read_first: 0 write: 0 delete 0 update: 0 Table status: Opened tables: 0 Open tables:0 Open files: 0 Open streams: 0 010521 3:11:43 /usr/sbin/mysqld: Normal shutdown 010521 3:11:44 /usr/sbin/mysqld: Shutdown Complete 010521 03:11:44 mysqld ended Best regards, Richard mailto:[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
Mysql Bug Report about Latin5 in 3.23.38max
Mysql Bug Report about Latin5 in 3.23.38max I downloaded Mysql Win32 sources and saw that : in share directory , in Index file there is #30 latin5 line. but in directory this file does not exist. all other files are correct and exist but there is not latin5 file??? Yusuf Incekara Regards
RE: mysql.sock file
At 05:48 PM 05/22/2001, Angerer, Chad wrote: Dennis, do a find / -name mysql.sock 2/dev/null to find exactly where mysql puts this file.. My rpm install put it in /var/lib/mysql/mysql.sock Find where your mysql.sock file is and make a symbolic on it pointing to /tmp/mysql.sock ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock Also check your file permissions. Make sure the mysqld user has access to this directory. Yes, we've done that, but because the tmp directory may get scrubbed on shutdown or boot, it has to be done on each boot. I wondered if I could find out whethers its still SUPPOSED to be there, at which point permissions would be something to consider. thanks, Dennis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 many queries per second do you get?
Hello, I was just looking at my MySQL databse using mytop and saw that I was getting over 60 queries per second. Can people give me an idea of how many queries per second they get? Thanks, Nathan Hendler Tucson, AZ USA http://retards.org/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 tell when I need more memory?
How does one know if their database server needs more memory? I have several tables around 600,000+ rows that are being joined. I have 512MB of memory. Is there a rule of thumb, or a good way to calculate how much memory my database server needs. Can I run my bigest query through some sort of benchmark to see how much memory it consumes? Thanks, Nathan Hendler Tucson, AZ USA http://retards.org/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.sock file
At 04:47 PM 05/23/2001, Angerer, Chad wrote: Well.. not sure if this is right but if you start up the mysqld server on startup the mysql.sock should be created in that directory always, so the symbolic link will always point to the same place. Otherwise.. I believe the directory will be in your my.cnf file.. and you can change that to point to the correct path. I hope I am moving along the right path here. Ah, does anyone know what the setting in my.cnf would be? That would be ideal. Dennis -C -Original Message- From: Dennis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 23, 2001 3:37 PM To: Angerer, Chad; [EMAIL PROTECTED] Subject: RE: mysql.sock file At 05:48 PM 05/22/2001, Angerer, Chad wrote: Dennis, do a find / -name mysql.sock 2/dev/null to find exactly where mysql puts this file.. My rpm install put it in /var/lib/mysql/mysql.sock Find where your mysql.sock file is and make a symbolic on it pointing to /tmp/mysql.sock ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock Also check your file permissions. Make sure the mysqld user has access to this directory. Yes, we've done that, but because the tmp directory may get scrubbed on shutdown or boot, it has to be done on each boot. I wondered if I could find out whethers its still SUPPOSED to be there, at which point permissions would be something to consider. thanks, Dennis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication involving now() is sketchy if the two server clocks differ.
Description: replication involving now() is sketchy if the two server clocks differ. How-To-Repeat: Have a replicating server with a different clock (or timezone!) than the primary server. Do an insert or update or anything involving now() and it'll get weird, since the second server may or may not have the same kind of data. Replicated data should not use now() but should instead have the value calculated by now(). Fix: Submitter-Id: submitter ID Originator: Organization: tani hosokawa river styx internet MySQL support: email support Synopsis: now() shouldn't be used in the replication/logs Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.31 (Official MySQL binary) Environment: System: Linux .x.xxx 2.2.19 #4 Tue May 1 12:20:47 PDT 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/i686-pc-linux-gnu/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium -fomit-frame-pointer' CXX='gcc' CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -fe lide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx 1 root root 13 Sep 24 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x 1 root root 4101836 Sep 5 2000 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 19533408 Apr 16 1999 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Apr 16 1999 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --ena ble-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared Perl: This is perl, version 5.005_03 built for i686-linux ~ -- tani hosokawa river styx internet - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help with a semi-complex select statement..
hi. i would suggest doing this in 2 queries, one to get the penalties, and one to get the goals...as you can only really get the top 10 for one of them. if you want the top 10 leaders in penalty minutes, and the goals scored for that player, you can join the goals table in there as well and SUM() those up... select teams.TEAMNAME, players.PLAYERID, players.FIRSTNAME, players.LASTNAME, SUM(penalty.PENALTYMINUTES) as TPM from players left join penalty on players.PLAYERID = penalty.PLAYERID, teams where players.TEAMID = teams.TEAMID group by players.PLAYERID order by TPM desc limit 10; (this may or may not work/parse properly, as i didn't actually try it, YMMV, etc.etc.etc.) -ravi. -Original Message- From: Chad Day [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 23, 2001 10:59 AM To: [EMAIL PROTECTED] Subject: Help with a semi-complex select statement.. I have 4 tables, named: players - stores player id, name, team id teams - teamid, teamname goals - goals scored, player id, team id penalty - penaltys accumulated, player id What I'm trying to do is write a query to get the top 10 from any category and display them. I can do them individually fine, like so: SELECT players.PLAYERID, players.FIRSTNAME, players.LASTNAME, SUM(penalty.PENALTYMINUTES) as TTPM FROM players, penalty where (penalty.PLAYERID = players.PLAYERID) GROUP BY PLAYERID ORDER BY TTPM DESC LIMIT 10 but when I try to get the goal total as well or something and add another table to the from statement, I appear to be getting too many rows back as the numbers are inflated about 10 times what they should be .. the query I'm working with is: SELECT teams.TEAMNAME, players.PLAYERID, players.FIRSTNAME, players.LASTNAME, SUM(penalty.PENALTYMINUTES) as TPM, COUNT(goals.SCORER) as TGOALS FROM players, penalty, teams, goals where (penalty.PLAYERID = players.PLAYERID AND players.TEAMID = teams.TEAMID AND goals.SCORER = players.PLAYERID AND goals.TEAMID = teams.TEAMID) GROUP BY PLAYERID ORDER BY TPM DESC LIMIT 10 I'm not sure how I would go about re-writing it to get it to work properly, and humbly beg for assistance. Thanks, Chad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Request for feature: making SELECT FROM ... IS NULL mirror LAST_INSERT_ID
I've been arguing with MS Access lately. Fortunately, I won. But only because I had the source to MySQL available. Here's the situation: (If you're looking for the feature request, skip to the end of the e-mail. This message is a summary of a series of message posted on the MyODBC list. I'm posting here in hopes the MySQL developers, or at least one, will read it.) I am using attached tables. If you are using attached tables in Access, it will not allow you to use the statement SELECT LAST_INSERT_ID() *EVEN* if you tell it to make it a passthrough query. It tries to parse it and bombs saying it is an unknown function. Poppycock! OK, we can always try SELECT id FROM table_name WHERE ID IS NULL So, I did. If I do a manual insert, i.e. db.execute(insert query), and then open a recordset selecting the NULL id, I can get the new ID. GREAT! Or so I thought. Access has a glitch, though...well, many actually. :) Then I went about inserting a record via recordset.addnew, adding data, then recordset.update. Then when I tried to select the NULL id, it gave me an empty recordset. HUH!? So, I went and turned on logging**, and found out after an insert via recordset commands, Access issues a query to get the new record using the IS NULL construct. *AND THEN* MySQL resets the last insert id when that query is issued. Not exactly sure why, as you can do a SELECT LAST_INSERT_ID() as many times as you want. So, since Access already used IS NULL, I can't. So there has to be a way to disable that, right? Right. I grep'ed the source, and found this at line 3062 of sql/sql_select.cc: thd-insert_id(0);// Clear for next request Well, I commented that out, recompiled, and now SELECT id FROM table_name WHERE id IS NULL mirrors the behavior of SELECT LAST_INSERT_ID() So, I can SELECT id FROM table_name WHERE id IS NULL as many times as I need/want to, and it will return the proper value. Very nice. So, that was my problem, and the solution. Could these be changed in the official distribution? Or at least a compile time option? I see no reason why the SELECT NULL behavior cannot mirror the behavior of LAST_INSERT_ID. Thanks very much for a great product! And thanks for making the source available! That saved me a VERY large headache! j- k- **MySQL logs are a LIFESAVER! Especially when all Access will tell you is ODBC Call Failed !! :) -- Joshua Kugler Associated Students of the University of Alaska Fairbanks Information Services Director [EMAIL PROTECTED] 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Best Choice?
Hi everyone! I'm going to be working on a Honors Project and I'm wondering if I've chosen the best set of tools. The software I am designing is intended to be installed on isolated Win32 machines (hopefully will be ported to Linux and/or WWW app someday). I have chosen to use Visual C++ and MySQL together, and I would like to know if anyone sees any problems with this. I know MySQL++ should work with VC, but can I use something like InstallShield to seamlessly bundle the MySQL client and server with my application? I don't want the users to have to do anything technical. By the way, my software will be free, so that's not an issue. Thanks! Mike Hagedon Tucson, AZ _ Get your FREE download of MSN Explorer at http://explorer.msn.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
Mysql Compile Problem ..
Hey, After configuring MySQL 3.23.36 (first using Apachetoolbox but then just compiling it from the downloaded source). I have run into this problem. Any ideas? I'm running RedHat 7.0 on an X86 box. Making all in libmysql make[2]: Entering directory `/export/home/mrichard/Apachetoolbox-1.5.27/src/mysql-3.23.36/libmysql' /bin/sh ../libtool --mode=link gcc -O6 -DDBUG_OFF -rdynamic -o libmysqlclient.la -rpath =/opt/mysql/lib/mysql -version-info 10:0:0 libmysql.lo net.lo violite.lo password.lo get_password.lo errmsg.lo my_init.lo my_static.lo my_malloc.lo my_realloc.lo my_create.lo my_delete.lo mf_tempfile.lo my_open.lo mf_casecnv.lo my_read.lo my_write.lo errors.lo my_error.lo my_getwd.lo my_div.lo mf_pack.lo my_messnc.lo mf_dirname.lo mf_fn_ext.lo mf_wcomp.lo typelib.lo safemalloc.lo my_alloc.lo mf_format.lo mf_path.lo mf_unixpath.lo my_fopen.lo my_fstream.lo mf_loadpath.lo my_pthread.lo my_thr_init.lo thr_mutex.lo mulalloc.lo string.lo default.lo my_compress.lo array.lo my_once.lo list.lo my_net.lo charset.lo hash.lo getopt.lo getopt1.lo getvar.lo my_lib.lo strmov.lo strxmov.lo strnmov.lo strmake.lo strend.lo strnlen.lo strfill.lo is_prefix.loint2str.lo str2int.lo strinstr.lo strcont.lostrcend.lo bchange.lo bmove.lo bmove_upp.lo longlong2str.lo strtoull.lo strtoll.lo llstr.lo ctype.lo dbug.lo -lz -lcrypt -lnsl -lm libtool: link: only absolute run-paths are allowed make[2]: *** [libmysqlclient.la] Error 1 make[2]: Leaving directory `/export/home/mrichard/Apachetoolbox-1.5.27/src/mysql-3.23.36/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/export/home/mrichard/Apachetoolbox-1.5.27/src/mysql-3.23.36' make: *** [all-recursive-am] Error 2 Thanx! Mike Richards Network Administrator Harmony Integrated Systems www.hi.ca
Re: Problem with Update to 3.23.38
This is no bug. This is usually a result of 1. The mysql server not starting. 2. Incorrect permissions. 3. socket file is in the wrong place and yes, you can define the location of the socket file. RTFM for this. - Original Message - From: Mark Lo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 23, 2001 23:55 Subject: Problem with Update to 3.23.38 HI, I got the following problem with apache_1.3.20 + modssl-2.8.4-1.3.20 + openssl-0.9.6a + php-4.0.5 + mysql-3.23.38. After I upgrade the system, I can only connect to mysql server via the consle window. But, I am not able to use the php-mysql command to connect to the server via the web, the following error messages pop-up. Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/shuncheong/require/Password.php on line 1 Please tell me is this a bug or something else. I have tried to reboot the server. Thank you Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Bug Report - Installation on MacOS X (10.0.3 Build 4P13)
Machine: PPC G3 (Rev. A iMac), 288 MB RAM Problem occurred when running 'make install'. It configured fine (Configure command: ./configure --prefix=/usr/local/mysql-3.23.38) and compiled fine. However, 'make install' exited as follows: . . . /usr/bin/install: run-all-tests and /usr/local/mysql-3.23.38/sql- bench/run-all-tests are the same file /usr/bin/install -c server-cfg /usr/local/mysql-3.23.38/sql- bench/server-cfg /usr/bin/install: server-cfg and /usr/local/mysql-3.23.38/sql- bench/server-cfg are the same file /usr/bin/install -c crash-me /usr/local/mysql-3.23.38/sql- bench/crash-me /usr/bin/install: crash-me and /usr/local/mysql-3.23.38/sql- bench/crash-me are the same file /usr/bin/install -c copy-db /usr/local/mysql-3.23.38/sql-bench/copy-db /usr/bin/install: copy-db and /usr/local/mysql-3.23.38/sql-bench/copy-db are the same file make[2]: *** [install-benchSCRIPTS] Error 1 make[1]: *** [install-am] Error 2 make: *** [install-recursive] Error 1 [localhost:/usr/local/mysql-3.23.38] This happened both with and without the --low-memory flag in configuring. Other info: Compilation info: CC='cc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxr-xr-x 1 root wheel 15 May 22 22:13 /usr/lib/libc.dylib - libSystem.dyl\ ib System: Darwin localhost 1.3.3 Darwin Kernel Version 1.3.3: Fri May 4 13:46:54\ PDT 2001; root:xnu/xnu-124.8.obj~1/RELEASE_PPC Power Macintosh powerpc Some paths: /usr/bin/perl /usr/bin/make /usr/bin/cc Maybe you could release a binary for Mac OS X (non-server). Thanks, Dustin Li - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
newbie question
Dear, I apologize if this question stupid. I was see many question about MySQL file system with the word INNODB, MyISAM and other. I wonder which the best type to use in Linux because I did not know more about Unix file system. So, I was install mysql by default and I want to know which db type installed in my sytem Sommai Fongnamthip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
weird indexing behavior in presense of limit
I have a very large table, where one of the columns is color enum(red, blue, black) The distribution of values is 90% black, 8% blue, and 2% red. I want to be able to randomly select 10 rows matching a certain color from the table. Of course, select * from my_table where color = black order by rand() limit 10 is very slow because the huge table has to be sorted before the first 10 rows are selected. So what I did was create another column randomkey, wich is filled with random integers in the range [0 .. 10^6]. Then I added an index (column, randomkey). The following query usually works: select * from users where color = black and randomkey [random value] limit 10 However, the problem here is that only the first part of the index (column, randomkey) is used sometimes. So, if randomkey is 40, mysql basically looks through 40 rows before it finds randomkey 40. Would anybody have a clue about why this happens? I thought limit forced the use of all available indices. Thanks, Andrey
BerkleyBD compat
using berkleydb3.2.9 with patch1 and patch2 when compiling MySQL 3.23.38 I add --with-berkeley-db --with-berkeley-db-includes=/usr/local/BerkeleyDB.3.2/include --with-berkeley-db-libs=/usr/local/BerkeleyDB.3.2/lib so it configure and the complains about wrong version wanting 3.2.9a and finding 3.2.9 wassup with this ? do i need edit version in headers ? I tried this first without the pathches also with same results I seem to call have the same problem last time i tried to use BerkleyDB because i don't want to use the prebuild binaries. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Can't connect to local MySQL server through socket '' ( 111) error
Hi there, Where do I find mysql.sock file? I couldn't find it under mysql or mysql-gui directory. Thanks Wei --- Sinisa Milivojevic [EMAIL PROTECTED] wrote: Jausions, Philippe writes: Hi, Just wondering how to get through that Can't connect to local MySQL server through socket '' (111) error message with MySQL GUI for Linux (RedHat 7.0). I configured mysqlgui through ~/.my.cnf and client configuration file. I tried the static and semi-static binary versions. If I put a socket parameter (/var/lib/mysql/mysql.sock as shown in mysqladmin variables. I also tried a /tmp/my.sock just in case...) then the GUI crashes with a core dumped. If I leave the SQL command on connect (or socket) blank, then it just gives me the connection error message (Yes, I'm being prompted for the password...) I read a lot of the messages in this mailing list, they all seem to refer to misconfigured files. I must be blind... Connection with the regular mysql client works fine. If anyone could help? Thanks. Hi! You should put /var/lib/mysql/mysql.sock in the specified field . But you should also use only static version of mysqlgui on RH 7.*, due to some problems on RH 7.*. This combination should work. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\ Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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! Auctions - buy the things you want at great prices http://auctions.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
database directory permissions (unix)
is there any way to (config file or something) to preset what a database directory's permissions are when it is created (i want the database's directory to have permissions of 755 for a program that i'm writing, but it appears to default to 700)... i know i can write a script to perform this operation at regular intervals, but i'd prefer it done immediately upon the creation of a new database... any ideas??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 it not work
On Wed, 23 May 2001, Don Read wrote: !-- end -- /script form ?php while($row = mysql_fetch_object($result)) Do you plan on executing a mysql_query() some time before this ? Actually it is executed before this. This scripts works fine on my local host running php 4.0.1pl2. Every time I refresh the page a different record appears. This is what I want. I was told that order by RAND() does not work on mysql 3.22 but a work around was RAND() as r and order by r. I tried this on the online mysql server from the command line it works but not thru php3 online. Take a look at vvmm.net TIA Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Porting Access to MySQL
hello all this is to inform u that i am running mysql 3.23.26 on linux 7.1 redhat but some problem with the mysql demon i am not able to stop the service through /etc/inet.d/mysqld it is showing serviece failed can any aone help me Thanking You, CBayScribe SysAdmin, CBayScribe Support.