Security of MySQL
Hello, My System is Linux Red Hat 6.2 and my MySQL is 3.23.41 ( *.tar.gz , sources package )... So, can you help me to set the security of the Database System ? The following compile and installation steps : ./configure \ --with-charset=big5 --with-extra-charsets=complex make make install So, how can I set the security of MySQL ? Thank for your help ! Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Security of MySQL
Chapter 4 in the manual is a good place to start! http://www.mysql.com/doc/M/y/MySQL_Database_Administration.html -Ursprungligt meddelande- Fran: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Skickat: den 21 november 2001 09:55 Till: [EMAIL PROTECTED] Amne: Security of MySQL Hello, My System is Linux Red Hat 6.2 and my MySQL is 3.23.41 ( *.tar.gz , sources package )... So, can you help me to set the security of the Database System ? The following compile and installation steps : ./configure \ --with-charset=big5 --with-extra-charsets=complex make make install So, how can I set the security of MySQL ? Thank for your help ! Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
problem with security and user access
after editing the tables below , i'm still not able to access the Bisimis Database below with the user behrens, just getting the errormessage below. I've tried it with any combination of user/db/host but can't see the supposed logic error i've made,i'm stuck,anyone there to help me? thanks usertable = | Host| User | Password | Select_priv | Insert_priv | Upda... | ws8 | behrens | [##] | N | N| N | % | behrens | [##] | N | N| N | localhost | behrens | [##] | N | N| N -- Db table Host | Db | User | Se...| In...| Up...| Del... | Cre... | Dro...| | % | Bisimis | behrens | Y| Y| Y| Y| Y | Y --- Hosttable = | Host | Db | Select_priv | Insert_priv | Update_priv | D... | ws8 | Bisimis | Y | Y | Y | Y | | localhost | Bisimis | Y | Y | Y | Y --- behrens@ws8:/home/behrens mysql --user=behrens -p Bisimis Enter password: * ERROR 1044: Access denied for user: 'behrens@localhost' to database 'Bisimis' behrens@ws8:/home/behrens - Before posting, please check: http://www.mysql.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
Is DATE NOT NULL DEFAULT NOW() legal??
Hi there. I'm getting stuck on what seems only too simple to me: CREATE TABLE Waverley.MemberPrice ( PriceID TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, Price FLOAT(5,2) NOT NULL, ActivePrice TINYINT UNSIGNED NOT NULL DEFAULT 1, CreatedDate DATE NOT NULL DEFAULT NOW(), DeActivatedDate DATE, DeActivatedBy TINYINT UNSIGNED NOT NULL DEFAULT 0 ); I get an Error 1064 on the NOW(). If I take the DEFAULT NOW() out, then it works perfect. I'm using 3.22.32, if that helps. Thanks if you can help. Peter. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database Replication problem
Jim Lucas wrote: just wondering, when you start the database replicating, the bin files start counting at .000 host-bin.001 host-bin.002 host-bin.003 ... host-bin.999 what happens when you reach .999? does it start over at .001 and over-write you initial files, or does it continue on? It will become .1000 -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on QNX6_10 (newest RTP)
Hi. I'm ought to install QNX on my workstation. I know that there are binaries and compilable sources available. But what about MySQL and PHP? An alternative for MySQL would be pgSQL (bin and src available too), but PHP seems to be lost in the world of realtime operating systems for good. Can anyone help me? gruß, Adrian Skupien -- Adrian Skupien Web-Entwickler E-Mail: [EMAIL PROTECTED] Friedrich-Ebert-Strasse 153 42117 Wuppertal Fon +49 (0)202 69 50 306 Fax +49 (0)202 69 50 299 Didn't take a look at http://www.erster.de yet ?! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Is DATE NOT NULL DEFAULT NOW() legal??
No, that is not legal. From the manual: Default values must be constants. This means, for example, that you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE. http://www.mysql.com/doc/C/R/CREATE_TABLE.html -Ursprungligt meddelande- Från: Pete, Rose Kristina [mailto:[EMAIL PROTECTED]] Skickat: den 21 november 2001 10:25 Till: [EMAIL PROTECTED] Ämne: Is DATE NOT NULL DEFAULT NOW() legal?? Hi there. I'm getting stuck on what seems only too simple to me: CREATE TABLE Waverley.MemberPrice ( PriceID TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, Price FLOAT(5,2) NOT NULL, ActivePrice TINYINT UNSIGNED NOT NULL DEFAULT 1, CreatedDate DATE NOT NULL DEFAULT NOW(), DeActivatedDate DATE, DeActivatedBy TINYINT UNSIGNED NOT NULL DEFAULT 0 ); I get an Error 1064 on the NOW(). If I take the DEFAULT NOW() out, then it works perfect. I'm using 3.22.32, if that helps. Thanks if you can help. Peter. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and encryption
Hi! Ken == Ken Kinder [EMAIL PROTECTED] writes: cut Ken I would like to know if anyone has some advice on encrypting credit cards Ken myself, as it's something I'm going to be needing to look into for my own Ken purposes. 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()) - The credit cards will be crypted in the data files. Just getting access to the data files will not make it possible to decrypt the credit cards. - The 'salt' used for encryption can either be stored in a file on the server (as a default value for the des_xxx() functions) or specified in the SQL statement. This enables a customers to do search in the customer database for his entry based on his credit card number without having to know the 'salt' SELECT * from customer_database WHERE credit_card=des_encrypt(his-used-credit-card); - To decrypt things, the MySQL user need to have certain privileges (for using the default key) or specify the used 'salt' to des_decrypt() We will write a full documentation for this as soon we got this implemented. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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
Query Execution Time Perl/DBD
Hi. How do I get the query execution time from Perl/DBD? MySQL client returns this in the console window. Is this value available through the Perl DBD interface? Thanks. Gordan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
synchronising mysql and access2k data
Hi, Has anybody had experience of trying to synchronise an access 2000 db with a mysql db? If so could you enlighten me as to where I can get further information/drivers to enable me to do this. TIA Regards Dean - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 when inserting a time with fraction
Description: I have a table 'spoken_text' with a field 'start_time'. When I do an INSERT (from within 'mysql') with a fractional part in the seconds field, SOMETIMES this inserted values is corrupted. How-To-Repeat: tpdmmr% mysql -u vip -p vip Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 43994 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql status -- mysql Ver 11.12 Distrib 3.23.33, for sun-solaris2.7 (sparc) Connection id: 43994 Current database: vip Current user: [EMAIL PROTECTED] Current pager: stdout Using outfile: '' Server version: 3.23.36 Protocol version: 10 Connection: dis.tpd.tno.nl via TCP/IP Client characterset:latin1 Server characterset:latin1 TCP port: 3306 Uptime: 215 days 2 hours 27 min 47 sec Threads: 1 Questions: 3885677 Slow queries: 269 Opens: 534 Flush tables: 1 Open tables: 64 Queries per second avg: 0.209 -- mysql desc spoken_text; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | reference | varchar(50) | | | | | | language | tinyint(3) unsigned | | | 1 | | | xml_text | text| YES | | NULL| | | start_time | time| YES | | NULL| | | end_time | time| YES | | NULL| | | archive| varchar(50) | | MUL | | | | asset_id | varchar(10) | | MUL | | | | segment_id | varchar(10) | | | | | | keyid | varchar(50) | | PRI | | | | time_stamp | timestamp(14) | YES | | NULL| | | classification | varchar(50) | YES | | NULL| | | title | varchar(255)| YES | | NULL| | | issue_date | datetime| YES | | NULL| | ++-+--+-+-+---+ 13 rows in set (0.00 sec) mysql INSERT INTO spoken_text (keyid, archive, asset_id, segment_id, reference, language, xml_text, start_time, end_time, classification) VALUES ('HWtest.16777602.ocr25','HWtest', '16777602','ocr25','16777602.ocr25','2','oud-CIA-di Wo', '00:11:25.159','00:00:3.68',''); mysql SELECT segment_id,start_time FROM spoken_text WHERE keyid='HWtest.16777602.ocr25'; +++ | segment_id | start_time | +++ | ocr25 | 15:09:00 | +++ 1 row in set (0.00 sec) Fix: Insert with '00:11:25' only, no fractional part. Submitter-Id: [EMAIL PROTECTED] Originator: Organization: Harry Wedemeijer TNO Institute of Applied Physics Phone : +31 15 2692274P.O. Box 155 Fax : +31 15 26921112600 AD Delft Email : [EMAIL PROTECTED] The Netherlands MySQL support: none Synopsis: Bug when inserting a time with fraction Severity: serious Priority: medium Category: mysql Class: Release: mysql-3.23.33 (Official MySQL binary) Environment: System: SunOS tpdmmr 5.7 Generic_106541-17 sun4u sparc SUNW,Ultra-2 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /opt/SUNWspro/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O3 ' CXX='gcc' CXXFLAGS='-O3 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1707532 Oct 5 19:09 /lib/libc.a lrwxrwxrwx 1 root root 11 Mar 1 2001 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1125056 Oct 5 19:09 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1707532 Oct 5 19:09 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Mar 1 2001
Re: Query Execution Time Perl/DBD
The obvious way to do this would be to get the time before and after the execution and then make a simple diff (after - before) I guess that is how the mysql client does it (butI'm not sure) I do not think that mysql itself provides this information.. how to get the time in Perl/DBD I do not know. but in java it would be long tb = System.currentTimeMillis(); // do the sql-statement long diff = System.currentTimeMillis() - tb; - Original Message - From: Gordan Bobic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 12:49 PM Subject: Query Execution Time Perl/DBD Hi. How do I get the query execution time from Perl/DBD? MySQL client returns this in the console window. Is this value available through the Perl DBD interface? Thanks. Gordan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: innodb and use of indices
Hi! I forwarded the email to Monty if he has time to look at index usage. The speedup .43 - .44 may be due to better optimization of SQL queries, or due to the table dumps and imports you made. The way to defragment InnoDB tables, or tables in any database, is from time to time to dump and reimport them. That can give a significant performance boost. Regards, Heikki -Original Message- From: nsabbi [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, November 21, 2001 11:37 AM Subject: innodb and use of indices HI, I have two problems: 1) I have the following table: desc users; +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+---+ | username | varchar(128) | | PRI | | | | password | varchar(128) | YES | | NULL| | | email| varchar(128) | | | | | | usa | int(11) | YES | | 0 | | +--+--+--+-+-+---+ 4 rows in set (0.00 sec) mysql show keys from users; +---++--+--+-+---+- +--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +---++--+--+-+---+- +--++-+ | users | 0 | PRIMARY |1 | username| A | 14 | NULL | NULL | | +---++--+--+-+---+- +--++-+ 1 row in set (0.00 sec) filled with 1579 records. when I launch explain select * from users order by username asc; +---+--+---+--+-+--+--+ + | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+--+--+ + | users | ALL | NULL | NULL |NULL | NULL | 14 | Using filesort | +---+--+---+--+-+--+--+ + 1 row in set (0.00 sec) mysql says it doesn't use any index, contrarily to what stated in the manual: Indexes are used to: ... Sort or group a table if the sorting or grouping is done on a leftmost prefix of a usable key (for example, ORDER BY key_part_1,key_part_2 )... Is it a bug or a decision of mysql to ignore the PK? I realized of this problem because it took ages to make such a simple select on such a little table. I remember there was a command to force the use of an index in a query, but I don't remember the syntax, any help? 2) reinstalling 3.23.44 from scratch (erasing 3.23.43 and the directories of data and logs) gave me an enormous speed boost (1/3 the time to make a select on 500K records). I wonder if this is only due to the upgrade from .43 to .44 or if a periodical cleanse will always give me these results. I'd like to know if the cleaning of logs is beneficial because of the way Innodb is designed, and what other tricks can help me, if any. Thanks, Nico - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Execution Time Perl/DBD
On Wednesday 21 Nov 2001 12:11, Christian Andersson wrote: The obvious way to do this would be to get the time before and after the execution and then make a simple diff (after - before) I guess that is how the mysql client does it (butI'm not sure) I do not think that mysql itself provides this information.. I was kind of hoping that the DBD object would have a special property where this can be read. Thanks. Gordan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HUGE Table Help
Hi All, I'm considering making a huge table, by that I mean approx. 26 millions records which will be static data, no updates, or deletes, etc. will be performed on this table, only select statements. The schema on the table will be as follows.. The address fields will be 56 characters long and the post code 7 characters. Address 1 Address 2 Address 3 Address 4 Address 5 Address 6 Address 7 Post Code At a guess the raw data may be in the region of 9GB. My question is, if I was to do a search on the Post Code (never on any address fields) what sort of performance can I expect from a Dual Zeon 933Mhz CPUs running Windows 2000 Pro Server with 512MB RAM? This is based on the fact the the post code field will be indexed and perhaps an additional index that indexes the first two characters of the post code and therefore narrows down the search to specific records to begin with, ie. OX16 0TH, index this and then create an index with the characters OX... Any advice on this or am I in a sinking boat? Many thanks, Kevin Smith - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AIX Binary Installation Problems
Right, It seems to be good to be tried but your server is down I thing. -- Cyrille Bollu - Software Development Engineer AWTCE - Navigation Department Tel. +32 2 389 25 14 Fax. +32 2 389 12 13 mailto:[EMAIL PROTECTED] I haven't read through any of the MySQL mailing lists in a while. Now that I do I see that lots of the AIX related questions involve problems with /usr/local/lib/libz.a as part of the ZLib compression library. The pre-compiled ZLib on http://www.bull.de/pub/ fails for me with the [shr.o] missing problems others have spoken of, etc... What I did was to download the source for ZLib and compile/install it and MySQL works just fine now. So, if it will help anyone the libz.a file which is working fine for me is downloadable at: http://216.98.81.199/libz.a I'd install zlib-1.1.3.2.exe from the Bull AIX Binary site and then replace libz.a with this one. Have done so on a half dozen machines and it's running fine everywhere. ... You're welcome - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
a select n a regexp expression
Hello, I'm always with my access to mysql port. I noticve that access can dispaly a â but it s like a a. So I make this query to select some specials row from my database : select ort from localite_ortsnamen where ort REGEXP ^([A-Za-z]|[àâäåáãçéèêëîïíñõôöóùúûüÿÅÅÀÂÄÇÉÈÊËÎÏÑÔÖÛÜß', -])+$=0; I'd like to add the possibilite from the ort column to have char like (),-' , but it doesn't work i try to escape these cars with a \, but nothing. So how can I do this ? thanks. _ 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
Re: Delete Match Against
Hi! On Nov 20, Karl J. Stubsjoen wrote: Hello, I am trying to perform the following delete command: delete from my_table where match(keywords,title,description) against('this_word') When I perform a similar select and count with the above query, I come up with 47 records found. However, when I issue the above delete command, no records are deleted. Is there a limitation to issuing the delete command with the Match and Against syntax in a where clause? Thank you! Karl It's a bug - thanks for spotting this. It'll be fixed in the next version. 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: localhost problem
On Wed, 21 Nov 2001, Pafo wrote: i still cant get pass this problem, i have now uninstalled PWS and still i cant access why why why why? http://www.pafo.net/mysql4.gif i am running, win98, p-III 1000, 512ram, the latest mysql, using tiny personal firewall and i am connected thru a network card in my computer to the internet, all the time. Try logging in with mysql -u root, then read up in the manual on the grant system for adding other users. Sincerely, Jan -- Mr. Jan-Aage Bruvoll IT Project Manager 20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich Zurich office: +41 1 307 4293, fax: +41 1 307 4281 Office/fax: +44 2072408283 Mobile: +44 7740291600 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 JOIN syntax question
On Wednesday 21 November 2001 03:01, James O'Brien wrote: I have been trying to perform a join with several tables and I am having no joy. error messages would increase the understanding of exactly what joy you aren't having ;-) Can some one send me a query (just a select * is fine) for these tables the ID's i'm using below aren't the real column names but they will do for the purpose of this email. select * from table1 left join table2 on table1.id=table2.id table2 left join table3 on table2.id1=table3.id2 and table2.id2=table3id2 table3 left join table4 on table3.id3=table4.id3 table3 left join table5 on table3.id4=table5.id4 table3 left join table6 on table3.id5=table6.id5 table3 left join table7 on table3.id6=table7.id6 Have you tried something like this?: select * from table1 left join table2 on table1.id=table2.id left join table3 on table2.id1=table3.id2 and table2.id2=table3id2 left join table4 on table3.id3=table4.id3 left join table5 on table3.id4=table5.id4 left join table6 on table3.id5=table6.id5 left join table7 on table3.id6=table7.id6 HTH -- Ian Barwick - Developer - [EMAIL PROTECTED] akademie.de asp GmbH - http://www.akademie.de To query tables in a MySQL database is more fun than eating spam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: problem with security and user access
On Wednesday 21 November 2001 10:10, behrens wrote: after editing the tables below , i'm still not able to access the Bisimis Database below with the user behrens, just getting the errormessage below. I've tried it with any combination of user/db/host but can't see the supposed logic error i've made,i'm stuck,anyone there to help me? thanks Have you flushed the privileges after changing the tables? FLUSH PRIVILEGES -- Ian Barwick - Developer - [EMAIL PROTECTED] akademie.de asp GmbH - http://www.akademie.de To query tables in a MySQL database is more fun than eating spam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: synchronising mysql and access2k data
Use myODBC to use an ODBC connection. If you are using a hosting provider on a Unix box, more than likely this will not work Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: dean browett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 5:55 AM To: [EMAIL PROTECTED] Subject: synchronising mysql and access2k data Hi, Has anybody had experience of trying to synchronise an access 2000 db with a mysql db? If so could you enlighten me as to where I can get further information/drivers to enable me to do this. TIA Regards Dean - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Newbie query
Hi, A v. basic question from a mySql newbie: I want to update a table based on the contents of another table. The SQL I am trying to execute is: update servers set servers.responsecount=servers.responsecount+1 where servers.gameid = lastsnapshot.gameid; ie: Increment a responsecount for rows where the gameid in the servers table matches the gameid in the lastsnapshot table. I am getting a Unknown table lastsnapshot error from mySql. Can someone point me in the right direction for this. Thanks, Charles. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Nusphere is spamming me
Hi! Sandeep == Sandeep Murthy [EMAIL PROTECTED] writes: Sandeep Have been spammed too by NuSphere earlier on.. so junked my earlier mail id Sandeep and switched to the present one... Sandeep let all the subscribers carry a vote to hv this spammer banned from this Sandeep list... Sandeep sandeep As you probably know, we don't allow spams to be posted to [EMAIL PROTECTED] (In some extreme cases we have agreed to forward spam-like information when we think the information is of general nature that we think it will benefit a large part of MySQL users, but we have been very restricted with this). The problem in this case is that the spams are not posted through the public MySQL lists, but harvested from email posted to this list and is thus almost impossible to control. I have now unsubscribed all @nusphere.com addresses from this list to make it a bit harder for NuSphere to get email addresses; Unfortunately this will not help in the long run because it's so easy to generate 'fake' email addresses for this purpose :( Thanks for all the support and the interesting links that has been forward to us regarding this thread! Regards, Monty CTO of MySQL AB PS: If anyone has some other interesting links or information that concerns NuSphere's recent behavior, please forward them to: [EMAIL PROTECTED] As it is likely that we will soon be in court regarding this, we are thankful for all information we can get! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AIX Binary Installation Problems
Hi dear mysql-users, Just to inform you that this solution still works (today the 21th november 2001). Just note that the address has changed to http://216.184.67.245/libz.a Regards, Cyrille mailto:[EMAIL PROTECTED] I haven't read through any of the MySQL mailing lists in a while. Now that I do I see that lots of the AIX related questions involve problems with /usr/local/lib/libz.a as part of the ZLib compression library. The pre-compiled ZLib on http://www.bull.de/pub/ fails for me with the [shr.o] missing problems others have spoken of, etc... What I did was to download the source for ZLib and compile/install it and MySQL works just fine now. So, if it will help anyone the libz.a file which is working fine for me is downloadable at: http://216.98.81.199/libz.a I'd install zlib-1.1.3.2.exe from the Bull AIX Binary site and then replace libz.a with this one. Have done so on a half dozen machines and it's running fine everywhere. ... You're welcome - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
a select n a regexp expression
Hello, I'm always with my access to mysql port. I noticve that access can dispaly a â but it s like a a. So I make this query to select some specials row from my database : select ort from localite_ortsnamen where ort REGEXP ^([A-Za-z]|[àâäåáãçéèêëîïíñõôöóùúûüÿÅÅÀÂÄÇÉÈÊËÎÏÑÔÖÛÜß', -])+$=0; I'd like to add the possibilite from the ort column to have char like (),-' , but it doesn't work i try to escape these cars with a \, but nothing. So how can I do this ? thanks. You should either use a double backslash \\( \\ or put the special symbols inside a character class [-)('abc]. In this case, to avoid syntax errors, the dash (-) shoud be at the beginning of the class. select a(bc regexp [)(x-s] gives you a syntax error, because the dash is interpreted (wrongly) as range operator notice that select a-bc regexp [)(x-z] will execute without errors, but the dash in this is a range operator, not a character to match. It means: match a parenthesis, or lowercase letters from x to z. Therefore it will return 0. select a(bc regexp [-)(ba)]; returns 1. select a(bc regexp \\( ; returns 1 select a(bc regexp [-'(]; returns 1; select a(bc regexp ( gives you an error. Giuseppe Maxia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: problem with security and user access
Ian Barwick wrote: Have you flushed the privileges after changing the tables? FLUSH PRIVILEGES -- Ian Barwick - Developer - [EMAIL PROTECTED] akademie.de asp GmbH - http://www.akademie.de To query tables in a MySQL database is more fun than eating spam yes i did countless times, i'm working on a local Machine without Admin rights, so i could not add mysql as a user nor GroupAdd mysql (as in the Manual) nor were i am able to chown -R root /.../.. chown -R mysql/../../var chgrp -R mysql/.../... Might that be responsible for my problems (i annihilated the whole server and started anew, i'm just a student charged with building a Library-Database for an institute, so that is no real prob,but to no avail, i still got the same problems) Greetz janB [EMAIL PROTECTED] == a different set of mind - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: localhost problem
On Wed, 21 Nov 2001, Pafo wrote: am still getting the same message http://www.pafo.net/mysql5.gif Try without the password. As below, mysql -u root. On Wed, 21 Nov 2001, Pafo wrote: i still cant get pass this problem, i have now uninstalled PWS and still i cant access why why why why? http://www.pafo.net/mysql4.gif i am running, win98, p-III 1000, 512ram, the latest mysql, using tiny personal firewall and i am connected thru a network card in my computer to the internet, all the time. Try logging in with mysql -u root, then read up in the manual on the grant system for adding other users. Sincerely, Jan -- Mr. Jan-Aage Bruvoll IT Project Manager 20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich Zurich office: +41 1 307 4293, fax: +41 1 307 4281 Office/fax: +44 2072408283 Mobile: +44 7740291600 Sincerely, Jan -- Mr. Jan-Aage Bruvoll IT Project Manager 20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich Zurich office: +41 1 307 4293, fax: +41 1 307 4281 Office/fax: +44 2072408283 Mobile: +44 7740291600 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: localhost problem
It seems at least one of your username and/or password is not as you might think. You should find the my.ini file, which is either should be in C:\Windows for M$ Windows'98, and change your username-password info. After relaoding mysql, it should function. Regards ? ferhat ? - Original Message - From: Pafo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 4:55 PM Subject: Re: localhost problem am still getting the same message http://www.pafo.net/mysql5.gif regards pafo - Original Message - From: [EMAIL PROTECTED] To: Pafo [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 2:34 PM Subject: Re: localhost problem On Wed, 21 Nov 2001, Pafo wrote: i still cant get pass this problem, i have now uninstalled PWS and still i cant access why why why why? http://www.pafo.net/mysql4.gif i am running, win98, p-III 1000, 512ram, the latest mysql, using tiny personal firewall and i am connected thru a network card in my computer to the internet, all the time. Try logging in with mysql -u root, then read up in the manual on the grant system for adding other users. Sincerely, Jan -- Mr. Jan-Aage Bruvoll IT Project Manager 20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich Zurich office: +41 1 307 4293, fax: +41 1 307 4281 Office/fax: +44 2072408283 Mobile: +44 7740291600 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
newbie question re: (re)starting MySQL
Just recently started seriously studying the infernal trio of Apache, MySQL PHP and got off to a decent start, but for reasons unknown can no longer get MySQL to start up from the DOS prompt. I keep getting a Can't initialize InnoDB as innodb_data_file_path is not set message when I enter the C:\mysql\binmysqld --standalone command. This command had previously worked without problems; now it doesn't. The only possibility I can think of offhand is that my subsequently experimenting with WinMySQLadmin may have somehow disabled being able to start up MySQL from the DOS prompt (which I want to continue to utilize for the sake of learning proper command-line procedures in anticipation of our pending migration to Linux as our primary OS). Perhaps this is a long shot and I've missed the mark entirely in trying to decipher what isn't congealing at present. Would appreciate whatever guidance (debugging?) that the more experienced users may have to offer. Thanks in advance. :-) mhw (-: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: problem with security and user access
behrens wrote: Ian Barwick wrote: Have you flushed the privileges after changing the tables? FLUSH PRIVILEGES -- Ian Barwick - Developer - [EMAIL PROTECTED] akademie.de asp GmbH - http://www.akademie.de To query tables in a MySQL database is more fun than eating spam yes i did countless times, i'm working on a local Machine without Admin rights, so i could not add mysql as a user nor GroupAdd mysql (as in the Manual) nor were i am able to chown -R root /.../.. chown -R mysql/../../var chgrp -R mysql/.../... Might that be responsible for my problems (i annihilated the whole server and started anew, i'm just a student charged with building a Library-Database for an institute, so that is no real prob,but to no avail, i still got the same problems) Greetz janB [EMAIL PROTECTED] == a different set of mind - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Hello, My System is Linux Red Hat 6.2 I compiled and installed MySQL : ./configure \ --with-charset=big5 --with-extra-charsets=complex make make install So, how can I set the security ( user access ) to protect my Database System ? Thank for your help ! Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Delete Match Against
Wooohooo! that is the first bug i ever found! Do I get any points : ) Karl www.excelbus.com ..opportunity knocking.. -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 6:33 AM To: Karl J. Stubsjoen Cc: MySql list Subject: Re: Delete Match Against Hi! On Nov 20, Karl J. Stubsjoen wrote: Hello, I am trying to perform the following delete command: delete from my_table where match(keywords,title,description) against('this_word') When I perform a similar select and count with the above query, I come up with 47 records found. However, when I issue the above delete command, no records are deleted. Is there a limitation to issuing the delete command with the Match and Against syntax in a where clause? Thank you! Karl It's a bug - thanks for spotting this. It'll be fixed in the next version. 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
I've now had an extended dig around this mailing list's archive, and it I conclude mySql can not perform this type of update directly. Instead I should create a temp table, select into the temp table and then use that to do a REPLACE INTO command. Can someone confirm my conclusion is correct? Thanks, Charles. -Original Message- From: Charles Allen [mailto:[EMAIL PROTECTED]] Sent: 21 November 2001 14:29 To: Mysql (E-mail) Subject: Newbie query Hi, A v. basic question from a mySql newbie: I want to update a table based on the contents of another table. The SQL I am trying to execute is: update servers set servers.responsecount=servers.responsecount+1 where servers.gameid = lastsnapshot.gameid; ie: Increment a responsecount for rows where the gameid in the servers table matches the gameid in the lastsnapshot table. I am getting a Unknown table lastsnapshot error from mySql. Can someone point me in the right direction for this. Thanks, Charles. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 install Solaris 2.8 (PC) 3.23.39 (Please read)
I have downloaded MySql binary for Solaris 2.8 (PC) 3.23.39 from your web. After I installed, I found out that the file 'mysql_install_db' under scripts directory doesn't contain anything. The size of this file is zero. So basically, I couldn't initialize the user table in mysql database and get the daemon to be started. Could you please tell me why that file is empty? Is it a bug or I have missed something. The first couple of times when I untar the install file, it gave me directory checksum error. But after I tried several times using root, the install seems went well and didn't output any error message. Please let me know ASAP since I want to use MySQL in our current project. Thanks for your help! Jie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and use of indices
On Wed, 2001-11-21 at 05:19, Heikki Tuuri wrote: The way to defragment InnoDB tables, or tables in any database, is from time to time to dump and reimport them. That can give a significant performance boost. That is actually not entirely true. For MyISAM tables, one simply needs to run OPTIMIZE TABLE table_name from time to time. I think the end result is the same, but it's atomic. Does OPTIMIZE TABLE work for InnoDB? Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Wait for 4.1, it will have multi-table updates in it. Until then, you'll have to use two separate queries. Steve On Wed, 2001-11-21 at 07:28, Charles Allen wrote: Hi, A v. basic question from a mySql newbie: I want to update a table based on the contents of another table. The SQL I am trying to execute is: update servers set servers.responsecount=servers.responsecount+1 where servers.gameid = lastsnapshot.gameid; ie: Increment a responsecount for rows where the gameid in the servers table matches the gameid in the lastsnapshot table. I am getting a Unknown table lastsnapshot error from mySql. Can someone point me in the right direction for this. Thanks, Charles. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Can't Compile DBD::mysql
All, I'm having the same problem as Jose. SCO 5.0.5, gcc 2.95.3, Pthreads 3.5 (skunkware's). Perl was compiled using gcc. Msql-Mysql-modules-1.2219 is what I'm trying to install, but can't. Make finds my libgcc.a, and libmysqlclient files ... gcc -c -I/usr/local/lib/perl5/site_perl/5.005/i386-sco/auto/DBI -I/sysco /usr/local/mysql/include -I../dbd -I/usr/local/lib/perl5/site_perl/5.005/i386-sc o/auto/DBI -I/usr/local/lib/perl5/5.00503/i386-sco -U M_XENIX -D PERL_SCO -D PER L_SCO5 -melf -I/usr/local/include -O2 -DVERSION=\2.0419\ -DXS_VERSION=\2 .0419\ -fpic -I/usr/local/lib/perl5/5.00503/i386-sco/CORE -DDBD_MYSQL mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs LD_RUN_PATH=/sysco/usr/local/mysql/lib:/lib:/usr/local/lib/gcc-lib/i686 -pc-sco3.2v5.0.6/2.95.3 ld -o ../blib/arch/auto/DBD/mysql/mysql.so -G -L/usr/l ocal/lib dbdimp.o mysql.o -L/sysco/usr/local/mysql/lib -L/sysco/usr/local/my sql/lib -lmysqlclient -lm -L/usr/local/lib/gcc-lib/i686-pc-sco3.2v5.0.6/2.95.3 - lgcc chmod 755 ../blib/arch/auto/DBD/mysql/mysql.so cp mysql.bs ../blib/arch/auto/DBD/mysql/mysql.bs chmod 644 ../blib/arch/auto/DBD/mysql/mysql.bs Manifying ../DBD::mysql.0 Manifying ../Bundle::DBD::mysql.0 Manifying ../Mysql.0 mkdir blib/script cp dbimon blib/script/dbimon /usr/bin/perl -I/usr/local/lib/perl5/5.00503/i386-sco -I/usr/local/lib/p erl5/5.00503 -MExtUtils::MakeMaker -e MY-fixin(shift) blib/script/dbimon BUT, make test fails ... make test PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib -I/usr/loca l/lib/perl5/5.00503/i386-sco -I/usr/local/lib/perl5/5.00503 -e 'use Test::Harnes s qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/00baseinstall_driver(mysql) failed: Can't load '../blib/arch/auto/ DBD/mysql/mysql.so' for module DBD::mysql: dynamic linker: /usr/bin/perl: reloca tion error: symbol not found: getrusage at /usr/local/lib/perl5/5.00503/i386-sco /DynaLoader.pm line 169. I'm out of ideas. The README's two hints didn't pan out (nor did using --static --config switches with the Configure command). And yes, this is an install from source, not binary. Any ideas anyone ? Cheers, Jo-an - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and use of indices
Hi! On Wed, 2001-11-21 at 05:19, Heikki Tuuri wrote: The way to defragment InnoDB tables, or tables in any database, is from time to time to dump and reimport them. That can give a significant performance boost. That is actually not entirely true. For MyISAM tables, one simply needs to run OPTIMIZE TABLE table_name from time to time. I think the end result is the same, but it's atomic. Does OPTIMIZE TABLE work for InnoDB? Sorry, no. ALTER TABLE can be used to rebuild the table, but essentially it is equivalent to a dump and reimport. Steve Regards, Heikki -- Order commercial MySQL/InnoDB support at https://order.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: insert/delete locking with innodb
Hi! If I have a process inserting into an innodb table in 200 insert chunks. i.e. it commits after every 200 inserts, must another process, which wants to delete data from this table, wait for the next commit on the insert end? If not is there any reason why my process is doing this. Do you have an index which guides the delete so that it will not need to look at the new inserted rows? Ric Regards, Heikki -- Order commercial MySQL/InnoDB support at https://order.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: Running two servers on the same box
when you run mysqld, use: /path/to/one/mysqld --bind-address=10.0.0.10 /path/to/two/mysqld --bind-address=10.0.0.11 Guillaume Monfort wrote: Hello there, i would run two distinct mysql servers on the same computer. i know it's possible using 2 differents ports but it's not what i want. the point is that i have 2 interfaces (2 IP's) and i wish to run on instance of mysql binded to say 10.0.0.10 and the other on to 10.0.0.11 of course, both servers will have differents logs and bases directory. any way to set this ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Joe Ellis http://www.lithodyne.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
RE: Nusphere is spamming me
Thanks for taking the time to clarify the situation. It appears that my response did not however convince the judge or jury on this manner and I've been bannished from the list. Rather interesting development. Britt... -Original Message- From: Michael A. Peters [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 5:20 PM To: Britt Johnston Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Nusphere is spamming me I would like to offer my very deepet apologies. This is what happened- About a year ago or so (maybe longer) when NuSphere was new I tried their product and did not want to use my regular e-mail address to register, so I used my username@host e-mail address on my linux box. In fact, it was a completely different box than I am using now, but the IP address was the same. I never used that e-mail address for anything. About three weeks ago I installed a clean system and then about a week ago, the Sylpheed gtk+ mail client. I was completely unaware that Sylpheed also incorporates the local system mailbox in its inbox. No one has an e-mail to my username@host address in that time. Until Nusphere did. Looking at the headers of the mail I got, though, that is the e-mail address to which the e-mail from Nusphere was sent. They did not steal my new e-mail address. This is what the header of the message says: Return-Path: [EMAIL PROTECTED] Return-Path: [EMAIL PROTECTED] Received: from pscgate.progress.com (pscgate.progress.com [192.77.186.1]) by c36988-a.ptbrg1.sfba.home.com (8.11.6/8.11.6) with ESMTP id fAJMwtg28381 for [EMAIL PROTECTED]; Mon, 19 Nov 2001 14:58:57 -0800 That is what happened. My deepest apologies to NuSphere and the MySQL list for this mix up. I jumped to a conclusion I should not have. On Tue, 20 Nov 2001 16:48:24 -0500 Britt Johnston [EMAIL PROTECTED] mentioned: Michael, et al: I want to assure everyone that there is no attempt to spam anyone on this email list, this email list is a valuable community service and not to be abused. Regardless, I'm sorry that anyone even has that impression. If you have any concerns after reading this please feel free to contact me directly. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Need help with SELECT 2 tables from choice of 3
Hi there I need help :-)) If anybody could be so kind and help me... I have 3 tables: OldMembers Memebers Data In Data there is a field Member_ID. Now in this field all members bigger than 100.000 are old ones and must be taken from the OldMembers table (both tables are not using same data so I can not one from both). If Member_ID is smaller than 100.000 the data from Members is taken. I can not join all 3 tables because a member is either a member of Member or OldMember, never of both. I would need in mySQL query something like IF, but not to make a value of yes or no, but something like IF Member_ID 100.000 then ELSE ... I have 1000 records in Data table and I need to have Usernames either from one or from the second Member table. I can not do that... SQL doesn't seem to have such strong programming language to make complex sentance. I tried using IF and put a result string like part of SQL query, like AND MEMBER.MEMBER_ID = Data.Member_ID or AND OLDMEMBER.MEMBER_ID = Data.MEMBER_ID and the inserting the result (I called it thequery) into WHERE part but doesn't work... I am really stuck... The only way to think is: Simply take all 1000 records without join and inside a for...next loop in ASP look what the ID_MEMBER of record is and make SELECT statement inside this loop. Now I am not sure how efficient is this... Means every record from 1...1000 would open a new recordset from the members or oldmembers table. There must be another way directly from the SQL query. I looked everything on Internet about this problem and couldn't find any solution. Could you just point me to any direction, is this possible or not? Thank you a 1000 times... 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
Re: Re: Can't Compile DBD::mysql (fwd)
-- Forwarded message -- Date: 21 Nov 2001 18:17:22 - To: Boyd Lynn Gerber [EMAIL PROTECTED] Subject: Re: Re: Can't Compile DBD::mysql Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: 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: Did you search the FAQ? http://www.zenez.com/cgi-bin/scoprogfaq/faq.pl or http://zenez.pcunix.com/cgi-bin/scoprogfaq/faq.pl I think your answer is there Good Luck, -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 3748 Valley Forge Road, Magna Utah 84044 Office 801-250-0795 FAX 801-250-7975 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Size of blobs?!
Hello! How do I get the size of a blob? I want to do something like this: SELECT * FROM blob_table WHERE size(blob_column) 1024; Best regards Sven -- --- ANDURAS AG - solutions for the NET http://www.anduras.de Linux Server-Systeme - Linux Services - HighEnd Linux - Crossmedia [EMAIL PROTECTED] - Tel: ++49 (0)851/49050-33 - Fax: ++49 (0)851/49050-55 --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need help with SELECT 2 tables from choice of 3
OldMembers Memebers Data 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. Thomas, 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
[Installation of grant tables failed!]
Description: /usr/local/mysql/bin # cd .. # ./configure NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! To help you a bit, I am now going to create the needed MySQL databases and start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory. Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 011121 20:15:29 Warning: setrlimit couldn't increase number of open files to more than 60 011121 20:15:29 Warning: Changed limits: max_connections: 50 table_cache: 64 ./scripts/mysql_install_db[292]: 15249 Memory fault(coredump) Installation of grant tables failed! Submitter-Id: [EMAIL PROTECTED] Originator: Organization: organization of PR author (multiple lines) MySQL support: [none |] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.44 (Official MySQL binary) Environment: System: HP-UX leonardo B.10.20 A 9000/871 2014209786 two-user license Some paths: /usr/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include -O3' CXX='gcc' CXXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti -O3 ' LDFLAGS='' LIBC: -r-xr-xr-x 1 binbin1863680 Nov 10 1999 /lib/libc.1 -r--r--r-- 1 binbin2456532 Nov 10 1999 /lib/libc.a lrwxr-xr-x 1 root sys 15 Jun 10 1996 /lib/libc.sl - /usr/lib/libc.1 -r-xr-xr-x 1 binbin1863680 Nov 10 1999 /usr/lib/libc.1 -r--r--r-- 1 binbin2456532 Nov 10 1999 /usr/lib/libc.a lrwxr-xr-x 1 root sys 15 Jun 10 1996 /usr/lib/libc.sl - /usr/lib/libc.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --with-pthread --with-lib-ccflags=-fpic --with-named-thread-libs=-ldce --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
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
Question on Indexing
Hi Group, I am using a database and want to index it for better performance. The datatypes for the coloums i am indexing(multicolumn indexing) are: varchar and timestamp I came to know that changing the datatype from varchar to char effects the performane a lot. I would like to know, has any body tyed this and would share his experience. Thanks a lot Manjeet *NEW* over 2200 active jobs at Yahoo! Careers *NEW* Visit http://in.careers.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
argument to --with-mysql option for PHP
Hello all, I have a question that might be better suited to the PHP community, but I thought that it was also relevant to the MySQL community (and I'm already on this mailing list!! :-) I am compiling PHP 4.0.6 as a dynamic module (apxs) for Apache 1.3.22 on my Darwin 1.4.1 system (Mac OS X 10.1.1). I am successfully running a source install of MySQL 3.23.44 (installed in /usr/local/mysql). After downloading and decompressing the source code for PHP, I have used the following options in ./configure: ./configure --with-xml --with-zlib --with-mysql --with-apxs=/usr/sbin/apxs I omitted the argument to '--with-mysql' because I was unsure of which directory to assign to this option. It seemed to configure just fine, but then at the end it displayed this warning: ++ |*** WARNING *** | || | You chose to compile PHP with the built-in MySQL support. If you | | are compiling a server module, and intend to use other server | | modules that also use MySQL (e.g, mod_auth_mysql, PHP 3.0, | | mod_perl) you must NOT rely on PHP's built-in MySQL support, and | | instead build it with your local MySQL support files, by adding| | --with-mysql=/path/to/mysql to your configure line.| ++ as I would like to later see about installing mod_perl or other DSOs for Apache, I didn't want to use the built-in MySQL support. But I'm not sure what path to specify to the '--with-mysql' option. Here is a list of my /usr/local/mysql directory: localhost:~/Downloaded/builds/build-php-4.0.6/apache_mod_php-6-2/php$ ls -lF /usr/local/mysql total 0 drwxr-xr-x 36 root mysqlgrp 1180 Nov 16 18:45 bin/ drwxr-xr-x 3 root mysqlgrp 264 Nov 16 18:44 include/ drwxr-xr-x 3 root mysqlgrp 264 Nov 16 18:44 info/ drwxr-xr-x 3 root mysqlgrp 264 Nov 16 18:44 lib/ drwxr-xr-x 3 root mysqlgrp58 Nov 16 18:45 libexec/ drwxr-xr-x 3 root mysqlgrp 264 Nov 16 18:45 man/ drwxr-xr-x 9 root mysqlgrp 264 Nov 16 18:45 mysql-test/ drwxr-xr-x 8 mysqladm mysqlgrp 264 Nov 21 09:56 mysqladm/ drwxr-xr-x 4 mysqladm mysqlgrp 264 Nov 21 09:59 run/ drwxr-xr-x 3 root mysqlgrp58 Nov 16 18:45 share/ drwxr-xr-x 23 root mysqlgrp 738 Nov 16 18:45 sql-bench/ drwx-- 7 mysqladm mysqlgrp 264 Nov 21 09:59 var/ 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. Thank you, Erik Price PS: Just to re-clarify about my system, it is: Darwin 1.4.1 running beneath Mac OS X 10.1.1 Apache 1.3.22 with DSO capability enabled MySQL 3.23.44 (source install) installed in /usr/local/mysql = 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
FLUSH TABLES
If I use a FLUSH TABLES command, what will happen to others that might be in the middle of using a table? I have a PHP application running on PHP 4.0.3 that doesn't seem to close tables properly, and I am constantly having trouble with the mySQL server crashing on me. I shut down the server, ran myisamchk on all tables, and I had a range of messages from: myisamchk: warning: 1 clients is using or hasn't closed the table properly to myisamchk: warning: 185 clients is using or hasn't closed the table properly ...depending on the table. But almost every table had at least 1 of these messages And I know that those tables are not in use at the time. So I'm thinking that it might be good to add a FLUSH TABLES command to the bottom of every page that uses mySQL. But this means that FLUSH TABLES would be run at least about 5-10 times each minute. Is that going to burden the server? - Jonathan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 0 Records Affected
I am passing an SQL statement through to Mysql, in certain circumstances (not very often), the information within the statement is the same as what is in the database, therefore 0 records are affected. This is great from a speed perspective, but I want to know that 0 records were affected because the information was the same and not something else. Anyway of doing his? http://www.bitbybit.dk/mysqlfaq/faq.html#ch8_4_0 -- and your API's equivalent of mysql_info(). You can also specify a variable for client_flag when doing a mysql_real_connect(), forcing MySQL to return the number of matched rather than affected rows. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Location in a text field?
I'm new to the list, and I cannot find out whether this question has been asked before (I'm sure it is) I have a table called 'paragraph' and one called images: paragraph: id ; text ; author ; images: url; subscript; I want my PHP to insert a IMG tag in a specified place in the text (like one normally does in html). But how must I set this up? Has anyone done it before? (Must be..) Are there standard and often used ways of doing these kind of things? I thought of making a column imglocation in 'paragraph' type INT giving the number of words/characters after wich the image needs to be inserted. But it seems to me this is not the way to go. Any tutorials on this online? And where? Thanx for reading, Ber - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL-4 compile / configure error
Towards the end of running the end of the configure script (./configure --prefix=/usr/local/mysql - and yes I know I can optimise better than this), I get: creating ./config.status creating Makefile sed: file conftest.s1 line 6: Unterminated `s' command creating os/Makefile sed: file conftest.s1 line 6: Unterminated `s' command creating ut/Makefile sed: file conftest.s1 line 6: Unterminated `s' command creating btr/Makefile sed: file conftest.s1 line 6: Unterminated `s' command creating buf/Makefile sed: file conftest.s1 line 6: Unterminated `s' command creating com/Makefile sed: file conftest.s1 line 6: Unterminated `s' command etc ... it goes on on but you get the idea. I'm running Slackware 8 with Autoconf 2.13 (not sure if this is relevant, but anyway I had to downgrade it to be able to compile Enlightenment 0.17 cvs) Anyone know what's happening? Alternatively, has anyone made a package for Slackware? The rpms segfault on executing. Please email me if you want more info (I tried attaching the config.log but apparently it's too big...). I'm subscribed to the digest - but that will take a day, and I'd like to get this show on the road [;)] Thanks in advance! Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Lost
Hello all, I have just notice that the new Mysql3.23.44.rpm is different. I download the rpm installed it (rpm -ivh Mysql ) installed fine, started the mysql deamon but when i tried to set a passwd for root i could not find mysqladmin it tells me that its located /usr/bins/mysqladmin but I look in the directory I did not see it Well I also download the binary package. I unzip it and untar it . Went into the directory and ran this command. ./configure hit enter all it did was start mysql deamon. Its not like befor I guess I'm going to read the doc on the site to configure and install mysql the right way. But if anyone know a good site to read the doc can you please let me know Thank you - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fulltext performance
Hi! On Nov 21, Mike Hunt wrote: All we want is for something like SELECT * FROM book WHERE MATCH(author) AGAINST ('stephen') AND MATCH(author) AGAINST ('king') LIMIT 100 /* these queries are ALWAYS limited like this */, a pretty normal kind of query, to return in an acceptable fast time; SELECT * FROM book WHERE MATCH(author) AGAINST (trollope') LIMIT 100 already does. It's certainly possible in some products - whether in MySQL or not is something I'd really like the answer to. It's in MySQL since 4.0.1 only :-( 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
indexing question
I am going to have a table called mail_queue, that is going to store the member id, the mailing id, and the date. Each time a new mailing is setup (usually daily), another 100,000 rows (one for each member) will be added to the table. When a member reads the mailing, that row will be removed from the table. This is the most normalized way to set this up, and allows me to: *) Make sure members don't get credit for reading the same mailing twice *) Not allow members who aren't allowed credit for a specific mailing don't get credited *) See how many people read each mailing (by determining how many mailings were sent, and subtract the number of rows left in the table for that mailing id) My question is about indexing. I know a lot about indexing, and using left-most indexes, etc...since this table will have millions of rows, I'm wondering what kind of index I should use? 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? Sincerely, Daren Cotter CEO, InboxDollars.com [EMAIL PROTECTED] http://www.inboxdollars.com (507) 382-0435 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database Replication problem
Thanks for the reply. Jim - Original Message - From: Rafal Jank [EMAIL PROTECTED] To: Jim Lucas [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 1:25 AM Subject: Re: Database Replication problem Jim Lucas wrote: just wondering, when you start the database replicating, the bin files start counting at .000 host-bin.001 host-bin.002 host-bin.003 ... host-bin.999 what happens when you reach .999? does it start over at .001 and over-write you initial files, or does it continue on? It will become .1000 -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
OS omissions from manual?
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. 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
Fw: LOAD_FILE does not work
I have been trying to load the textual contents of a file from my hard drive space into a field (Description) of my mySQL table (Software) using the follwing query. The query runs succfessfully, however, none of the contents are loaded into the field, in fact, the Description field is not updated at all: UPDATE Software SET Description = LOAD_FILE(/usr2/home/khan/www/cgibin/protecting/Describe/description_file) WHERE ID = 9 I have used single and double quotes around the file name without success. In the mySQL documentation, it says that I need FILE privileges. I asked my ISP to give me these privileges and still it did not work. I am pretty sure the ISP is using PHP 4. Please provide any leads you may have. The permissions on the description_file is 777. Sharaaz Khan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
i'm using mysql 3.23.43 on Windows 98 platform running on apache server 1.3.22 with php4 Sometimes (most often) this pc crashes (windows miracles) and if i was using mysql, i mean if i was logged in and moving data from my webpage, or if the winmysqladmin.exe was running, then after reboot, the user, or db or host tables in the mysql database screw up, then i must reinstall mysql Darkyle www.firequetzal.com Darkyle www.firequetzal.com _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LOAD_FILE does not work
I have been trying to load the textual contents of a file from my hard drive space into a field (Description) of my mySQL table (Software) using the follwing query. The query runs succfessfully How do you know that it's successful? What success/error codes (if any) are returned? cut ISP to give me these privileges and still it did not work. I am pretty sure the ISP is using PHP 4. Knowing the MySQL version is probably a lot more interesting. Make a PHP script containing just the line ? phpinfo(); ? and load it into your browser. That will give you information on both. Please provide any leads you may have. The permissions on the description_file is 777. What about the rest of the path? Is that readably by MySQL as well? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
parallel processing in mysql
Does anyone know whether mysql supports parallel processing? I searched the documentation on mysql.com, but didn't find it mentioned thanks AOD __ 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
Fw: LOAD_FILE does not work
UPDATE Software SET Description = LOAD_FILE(/usr2/home/khan/www/cgibin/protecting/Describe/description_file) WHERE ID = 9 You have to make sure that not only can mysql read the file, but it also has permissions to the directories that the files are in. Typically your home directory on your server may not be world readable, but for mysql to access it, it must be. Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Migrating...
Hello. I am running a MySQL server (3.23.43) on WinME, and another server (same version) on libc6 Linux. The server on WinME is a development server, or rather has been until now, and the Linux one is my production server. At this time the Linux one is completely empty with the exception of the defaults, and I would like to migrate the WinME one over onto the Linux system and then drop the one on WinME from my line of development (I don't really need it). In looking through the documentation I have noticed that I could do the following: 1) Uni-direction Replication - a bit of a pain just for a transfer. 2) Dump to a file, and load 3) Back-up Re-load Or I could just rebuild the entire thing. I would like to have the migration be as simple as possible, and am wondering what method is the best way to do that. Could someone please help? It would be greatly appreciated. Thanks in advance. Benjamen R. Meyer --- E-mail: [EMAIL PROTECTED] Web: http://bmeyer67.resnet.calvin.edu/ --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Fw: LOAD_FILE does not work
On Wed, 21 Nov 2001 17:02:29 -0500, Christopher Book [EMAIL PROTECTED] wrote: UPDATE Software SET Description = LOAD_FILE(/usr2/home/khan/www/cgibin/protecting/Describe/description_file) WHERE ID = 9 You have to make sure that not only can mysql read the file, but it also has permissions to the directories that the files are in. Typically your home directory on your server may not be world readable, but for mysql to access it, it must be. Chris Plus I believe you have to have FILE privileges enabled in the mysql.user table. I had a similar problem with a client, and after granting FILE privileges, it worked perfectly! :) 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: Migrating...
Hi. I had the same problem awhile back. What i did was just copy the db files to the linux server provided the mysql versions are exactly the same and the db structures are the same it works. Otherwise mysqldump and read it into the new db:) //Uffe Witness wrote: Hello. I am running a MySQL server (3.23.43) on WinME, and another server (same version) on libc6 Linux. The server on WinME is a development server, or rather has been until now, and the Linux one is my production server. At this time the Linux one is completely empty with the exception of the defaults, and I would like to migrate the WinME one over onto the Linux system and then drop the one on WinME from my line of development (I don't really need it). In looking through the documentation I have noticed that I could do the following: 1) Uni-direction Replication - a bit of a pain just for a transfer. 2) Dump to a file, and load 3) Back-up Re-load Or I could just rebuild the entire thing. I would like to have the migration be as simple as possible, and am wondering what method is the best way to do that. Could someone please help? It would be greatly appreciated. Thanks in advance. Benjamen R. Meyer --- E-mail: [EMAIL PROTECTED] Web: http://bmeyer67.resnet.calvin.edu/ --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LOAD_FILE does not work
- Original Message - From: Carsten H. Pedersen [EMAIL PROTECTED] To: Sharaaz Khan [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 1:52 PM Subject: RE: LOAD_FILE does not work I have been trying to load the textual contents of a file from my hard drive space into a field (Description) of my mySQL table (Software) using the follwing query. The query runs succfessfully How do you know that it's successful? What success/error codes (if any) are returned? When running the query manually from the mysql utitlity, I get the following: Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 cut ISP to give me these privileges and still it did not work. I am pretty sure the ISP is using PHP 4. PHP version 4.06. mySQL Client API version 3.23.32 Knowing the MySQL version is probably a lot more interesting. Make a PHP script containing just the line ? phpinfo(); ? and load it into your browser. That will give you information on both. Please provide any leads you may have. The permissions on the description_file is 777. What about the rest of the path? Is that readably by MySQL as well? I ran throught the entire path and all have read access, except for /usr2/khan/www and below. I don't think it is a good idea to have the world have access to all me text files in my web site. Do you? Please let me know if you have any other suggestions. Sharaaz / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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
Re: LOAD_FILE does not work
Thank you all for your suggestions. I used the /tmp directory on my ISP which has permissions to all and it work. Thanks, Sharaaz - Original Message - From: Sharaaz Khan [EMAIL PROTECTED] To: Carsten H. Pedersen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 2:08 PM Subject: Re: LOAD_FILE does not work - Original Message - From: Carsten H. Pedersen [EMAIL PROTECTED] To: Sharaaz Khan [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 1:52 PM Subject: RE: LOAD_FILE does not work I have been trying to load the textual contents of a file from my hard drive space into a field (Description) of my mySQL table (Software) using the follwing query. The query runs succfessfully How do you know that it's successful? What success/error codes (if any) are returned? When running the query manually from the mysql utitlity, I get the following: Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 cut ISP to give me these privileges and still it did not work. I am pretty sure the ISP is using PHP 4. PHP version 4.06. mySQL Client API version 3.23.32 Knowing the MySQL version is probably a lot more interesting. Make a PHP script containing just the line ? phpinfo(); ? and load it into your browser. That will give you information on both. Please provide any leads you may have. The permissions on the description_file is 777. What about the rest of the path? Is that readably by MySQL as well? I ran throught the entire path and all have read access, except for /usr2/khan/www and below. I don't think it is a good idea to have the world have access to all me text files in my web site. Do you? Please let me know if you have any other suggestions. Sharaaz / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and encryption
Monty, is this like a product you're selling? I would like more information, although I haven't gotten to this yet in my security sweep. On Wednesday 21 November 2001 06:27 am, Michael Widenius wrote: Hi! Ken == Ken Kinder [EMAIL PROTECTED] writes: cut Ken I would like to know if anyone has some advice on encrypting credit cards Ken myself, as it's something I'm going to be needing to look into for my own Ken purposes. 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()) - The credit cards will be crypted in the data files. Just getting access to the data files will not make it possible to decrypt the credit cards. - The 'salt' used for encryption can either be stored in a file on the server (as a default value for the des_xxx() functions) or specified in the SQL statement. This enables a customers to do search in the customer database for his entry based on his credit card number without having to know the 'salt' SELECT * from customer_database WHERE credit_card=des_encrypt(his-used-credit-card); - To decrypt things, the MySQL user need to have certain privileges (for using the default key) or specify the used 'salt' to des_decrypt() We will write a full documentation for this as soon we got this implemented. 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
How Does One Install MYSQL?
I tried following the directions that came with the book mysql/php database applications. I am told that after installing mysql, one checks to make sure the installation was correct by invoking the mysql daemon (c:\mysql\binmysqld). That did nothing there is a piucture in the book that shows a screen shot of the correct deal. Of course, there is no suggestions if the installation did not go right. Please help, Joe Wilk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 running mysql from the command line
I hope I'm not being really stupid, but this does not seem to work: mysql -h localhost -u xxx -p I get the command line usage error. It appears I can't use any other option if I use the -h. This works fine mysql -u xxx -p I'm running mysql version 3.23.43-nt Glenn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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?
Hi, From previous message (I don't run linux), I believe that linux ps lists all threads, and mysqld does create a thread for each connection. Regards Quentin -Original Message- From: Bennett Haselton [mailto:[EMAIL PROTECTED]] Sent: Thursday, 22 November 2001 4:15 p.m. To: [EMAIL PROTECTED] Subject: does each database connect cause mysqld to fork? 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? 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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?
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.) -Bennett At 04:39 PM 11/22/2001 +1300, Quentin Bennett wrote: Hi, From previous message (I don't run linux), I believe that linux ps lists all threads, and mysqld does create a thread for each connection. Regards Quentin -Original Message- From: Bennett Haselton [mailto:[EMAIL PROTECTED]] Sent: Thursday, 22 November 2001 4:15 p.m. To: [EMAIL PROTECTED] Subject: does each database connect cause mysqld to fork? 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? 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. [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: replication setup
I've set up replication with a master and two slaves, all running 3.23.43, and it works like a charm. Except for... When the master goes down, the slave tries to reconnect after 60 seconds, but just once. That shouldn't be. I have the same problem here with the same version! I expected it to retry until it can connect, because when the master comes up again, it should catch up on updates and everything would work like it should. That should be. But when the master goes down for a period exceeding 60 seconds (well, the timeout interval), the slave thread exits and never tries to start replicating again, unless I manually do a SLAVE START on all the slaves. Is there a way to make a slave hammer the master indefinitely, until it can connect? I've read the manual several times, and found no clue... What does the slave's error log say? Can we see replication items listed in the slave's my.cnf file? error log: 011104 11:02:34 Error reading packet from server: Lost connection to MySQL server during query (read_errno 22,server_errno=2013) 011104 11:02:34 Slave: Failed reading log event, reconnecting to retry, log 'db2-bin.001' position 51733535 011104 11:03:04 Slave thread: error re-connecting to master: Lost connection to MySQL server during query, last_errno=2013, retry in 60 sec 011104 11:04:04 Slave thread killed during or after a reconnect done to recover from failed read 011104 11:04:04 Slave thread exiting, replication stopped in log 'db2-bin.001' at position 51733535 my.cnf : [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16K set-variable= max_allowed_packet=1M set-variable= thread_stack=64K set-variable= table_cache=4 set-variable= sort_buffer=64K set-variable= net_buffer_length=2K server-id = 2 master-host = db2.sayhi.net master-user = don't tell master-password = don't tell master-port = 3306 Any hint? Arne - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Dear All You all are working on Database for Long time. In your opinion Which one is best 1. MySql or 2. Oracle Mamun - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
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
opinion - voating
Dear All 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. Thanking you Mamun Murtaza Sheriff SDNP Bangladesh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Table Locking...
(PHP-DB folks, ignore this top question - unless you want to answer) Which type of DB/Table provides table locking while a process is altering data? I don't care for locking while using SELECTs, but I do need locking when something's being INSERTed or UPDATEd, so I won't get two processes trying to do the same darned thing at the same time. (MySQL folks, ignore this bottom question - unless you want to answer) I'm somewhat lost on how to do the following: I'm trying to go through a table and check for a particular information. If it doesn't exist, then go ahead and issue an INSERT with the relevant data. The next time another process comes along, it'll obviously find the information and issue an UPDATE instead. But, what happens if I get two processes running at the same time, trying to find information that does not exist yet? If both issue a SELECT and find the information not there, both will try to issue an INSERT, where really I want one of those processes to wait for the first one to finish doing whatever it needs to do, prior to continuing. (all of this is being done in PHP by the way). Does anyone have any suggestions for this scenario (or am I just blowing smoke out my arse and there's something else, internally, that I'm not aware of?) When (and how) to issue some sort of wait state for one process while the other's finishing what it needs to do, then restart the second process (which should re-check for existing information, and not blindly issue another INSERT right after the first one). -- W | I haven't lost my mind; it's backed up on tape somewhere. + Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 IT Director / SysAdmin / WebSmith . 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