Re: sql diff for mysql
On Fri, 2003-03-14 at 17:19, Florent Martineau wrote: Hi, I'm searching for a mysql diff tool to update my database when changing structure and so. Does anybody outthere knowing such a tool ? As much I know, there is no such tool exists. I am doing myself some version control of SQL tables after their dumpout with mysqldump. You might be also interested in my SQLFS project on http://www.sqlfs.org. This must enable full control of any database in future with common tools like cvs, grep, diff, sed and so on. Currently it can do read-only access for demo usage only. Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in CNN
Just found story about MySQL in CNN: http://www.cnn.com/2003/TECH/ptech/03/12/fortune.ff.open.source/index.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: CFLAGS=-march=k6 ?
On Wed, 2003-03-19 at 03:27, Daniel Kasak wrote: Anyone know whether this is a bad idea or not (gcc-2.95.3)? I previously (MySQL-4.0.5 or so) built a server with -march=k6 which seemed to run OK apart from crashing when I did a very particular select on one table, but I was never sure whether that was because of a damaged table or because of my CFLAGS. So is it safe? It is safe. At least until you do not hit some compiler bug. But bad side-effect is that with -march compiler uses non-compatible optimizations. This code may not work anymore on any other processor. This is what differs it from -mcpu flag. If you look into configure scripts of MySQL, you see -march commented out because same reason. Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Off topic help, SSL and form posts
On Tue, 2003-03-11 at 04:15, Scott Haneda wrote: I have run into a problem where data is truncated when sending to MySql via a SSL connection, I can not determine whether this is my server or just the protocol, I hope the later, as I know web* 4, which is what I am using will never get it fixed. Anyone with php and apache running SSL, would you mind creating a simple html form textarea and trying to post more than 4000 or so bytes of data to either a database or just echo the data back, I nice test would be to see about 10k of data go through. Of course, if someone knows already this is a SSL issue and just is how it is, let me know, thanks. This is probably browser HTML understanding or PHP issue and surely have nothing to do with SSL. To find out, what is going on, add such PHP in top of your code: ?php print(pre); print_r($_REQUEST); print(/pre); ? After submit you will see, what PHP got from form. I am not HTML guru, but there were values for input and textarea tags affecting their maximum allowable size named something like size and maxlength. I is possible that browser uses some default is they are not defined. Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Using ssh tunnel and mysql
On Mon, 2003-03-10 at 22:01, Pete Harlan wrote: On Mon, Mar 10, 2003 at 11:32:06AM -0600, Paul DuBois wrote: Whether it's a feature or not, it's not always so easy to figure out what to do. If you specify -h localhost, it can be argued that you really want the socket even if you specify the port. It can be argued conversely that if you specify the port, you should use TCP/IP even if you specify -h localhost. That is, if the user specifies both, it's ambiguous what the user really wants. But localhost is a DNS name that only happens to resolve to 127.0.0.1. MySQL breaks this DNS abstraction by treating localhost as a keyword, different from 127.0.0.1, which goes against the principle of least surprise. (It confused me, anyway.) This is an optimization. MySQL client makes assumption that you want to connect locally and uses fastest available way - UNIX socket. Of course, this decision can be agreed or disagreed. Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 setting up DES_ENCRYPT on MySQL 3.23.46
On Thu, 2003-03-06 at 17:52, tommy liu wrote: anyways, yes I did run # ./configure --with-vio --with-openssl --prefix=/usr/local/mysql and also tried the max version I also ran mysql_fix_privilege_tables.sh (one along 3.23.46 source)because we have MySQL 3.23.46 but I don't think it did anything because the tables did not change before and after running the script. am I missing something ? Hard to say. I do not remember all details from this development. I suspect, something was missing in 3.23.x series at all. Can you try latest 4.0.x-Max ? It is highly possible that 3.23 does not contain working SSL code and it was switched off from somewhere. I am running 4.0.10 on pretty high volume server with complicated configuration and had no problems. mysql show status; +--++ | Variable_name| Value | +--++ ... | Questions| 225583189 | ... | Uptime | 2289866| +--++ I believe 4.0 will work for you. Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 4.0.x and SSL replication thoughts.
On Fri, 2003-03-07 at 17:56, Dan Geist wrote: If I understand the process, the act of replication is a simple connect via a dedicated and persistent thread on the slave which which registers No, it is not simple. It is not very complicated also but bit unusual. Usually SSL layer stuff uses different port for SSL (remind HTTP port 443 instead of port 80). For MySQL it was requirement to stay compatible with all current stuff - port number and fallback to non-SSL connection. This is difference no 1 - MySQL client connects to server as every usual client with SSL mode off. Client sends handshake packet with special few bytes named capabilities. If client capabilities have HAVE_SSL flag, server responds with own flags including HAVE_SSL. After that without loosing connection all handshake is made again but now with SSL turned on. This is not very common way to do things. There are tricks around ACL-s. Some places must check if cipher and certificates are good enough for some operation. Replication uses separate code and all things need to be incorporated there. MySQL server will act as client and even has special MySQL client library code (which is not equal to common libmysqlclient code) in mini_client.c file. If someone will hack it, replication over SSL becomes possible. Sorry, I do not remember all details about MySQL code. I can take a look and implement missing functionality within decent time if some interested party will pay for this job. Perhaps there's a particular issue involved, or perhaps developers just don't have the time to dedicate to the feature. I'm just wondering so I can adjust my plans accordingly. I do not know current plans of MySQL AB, but you can influence on them if you buy support. Other option to support community is to provide good quality patch to MySQL AB. Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: encrypted password
On Tue, 2003-02-11 at 15:39, Curtis Maurand wrote: The manual suggests that the password function is really for intenal mysql functions. Ideally you should use the encode or md5_encode functions. update user set password=encode('password', 'salt') where user = 'your_user'; Unless manual does not say, what method is used for encode(), I would prefer MD5() which is known to be good enough. I remember something about encode from source code. If I remember properly it was home-made algorithm and home-made algorithms are always known to be keep-away algorithms.=20 If you need security, always hire expert to analyze your needs and suggest exact ways to improve it. Even smaller mistake can void all efforts to secure something. Most security problems I have seen are results of doing security without knowing about topic. Often they lead to headlines as it was in CNN few months ago: hackers stoled credit reports of 15000 people. Use MD5() or SHA1() for one-way hashing where result never needs to be decrypted (usually passwords) Use DES_ENCRYPT() for encrypting data if you want to decrypt it at some point. Surely do not use PASSWORD() anywhere. Tõnu sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: encrypted password
On Wed, 2003-02-05 at 13:53, Kamara Eric R-M wrote: INSERT into tbl_name (username,password) values ('user',PASSWORD('passwd')); and when authenticating the user you can do something like SELECT username from tbl_name where passwd=PASSWORD('$pass'); and in this case $pass is the variable holding the password entered on the webpage. NEVER use the PASSWORD() function! It is totally insecure and still in MySQL in historical reasons. Use function MD5() instead. Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: What is the best known practice for insertion...?
On Mon, 2003-01-20 at 09:15, Zysman, Roiy wrote: Hi All, I'm trying to insert multiple lines to a table with 3 col. All 3 of them are a part of the primary key. But while inserting the data , sometime occurs the situation where I want to insert an already exist entry with the same keys. And mysql barfs out that this key already exist in the table. The solution to it would be probably to query for each entry that I'm about to insert if that entry exists , but it looks like it would be an enormous overhead. I'm asking this question on a _performance_ context . What is the best way , ignore the error messages mysql barfs out or query each entry for existences before inserting it ? If SQL is well optimized, then parsing of SQL commands is most time consuming task and can't be well optimized. To avoid this you must reduce number of SQL commands to SQL server. This is why I suggest trying INSERT and check for result. Double queries mean half speed. Another way is of course using replicated copy where to run queries and INSERT data on master. Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Secure Replication
On Fri, 2003-01-17 at 08:51, Ivan Hoo wrote: is there any way you can implement a secure replication via ssh or sth else? Who can implement? As user you can use SSH tunnel with it. There are many tutorial about making SSH tunneling in the internet. I believe if MySQL will have some kind of transport security, it will be SSL (as industry de facto standard for similar things). As usually - if somebody is really interested for new features then they can be speed up if you do the deal with MySQL AB. Otherwise you are one of 5 million MySQL users and MySQL AB develops things in order of own priorities and this is understandable. Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Initiating secure connection to MySQL4 from PHP
On Mon, 2003-01-13 at 23:48, David Rock wrote: Hello, This is discouraging after I spent most of the weekend getting OpenSSL working with our MySQL 4 server. Unfortunately I can't use Stunnel to secure the connection between our website and our MySQL server because our ISP will not allow me to run the Stunnel daemon on their servers. They have a web server farm and claim that they would need to configure Stunnel for me on each of their servers in the farm. How do people typically handle setting up Stunnel to secure their connections from a public ISP to their MySQL server? Is it possible that I only need to run the Stunnel daemon on my MySQL box? Securing the connection between a public ISP and a privately-hosted MySQL server seems like something that many people would have overcome by now. Am I really at the mercy of my ISP on this? Usually SSL can be used with separate wrapper program on any side. But this is usually. SSL handshake is different in MySQL because compatibility issues. Even when doing handshake with SSL enabled MySQL client, first packet is sent without encryption. There is a byte or two having bits named Client capabilities. If client want to establish SSL connection it raises bit I want SSL, server responds with similar structure Server capabilities having server can do SSL. Only after that all negotiation gets repeated with SSL turned on. This is why it is impossible to use stunnel on client side only and use native SSL of MySQL server (or opposite). In case of serious interest I can develop some separate piece of code which allows to fake first MySQL handshake packet or handle this issue somehow but it does not look serious idea to me :). Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Secure Replication
On Tue, 2003-01-14 at 20:47, Jeremy Zawodny wrote: has anyone been able to setup ssl secure replication for mysql? I don't believe you can do that yet. There's now way to specify the necessary credentials in the slave setup. how do i know whether the replication is actually done over ssl? There are many variables about SSL shown in SHOW STATUS output. They also include cipher currently in use and other similar stuff. This is right way to detect SSL usage because SSL has also ciphers which have no actual encryption at all. Paranoid people must verify if key length in use is long enough. Also I must note that using SSL without having appropriate ACL structure is nonsense. You must use GRANT blahblah REQUIRE SSL CIPHER blahblah. Then MySQL server just won't allow nonencrpyted connection. Otherwise default fallback mechanism will work. You'd have to sniff the network traffic and see. This is always must be done :) there seem to be a lack of documentation on this part. Mostly because it can't be done (that I'm aware of). I think so too. Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MySQL4 SSL certificate required?
On Thu, 2003-01-09 at 17:40, David Rock wrote: Hello, Can someone give me a some overview information regarding using SSL with MySQL version 4? I want to setup a 128bit SSL connection between our website hosted at an ISP and our MySQL (on FreeBSD) server which is hosted in our office. Basically I want the same level of security that we currently have between a web browser and our website. Does this require us to purchase another certificate from a CA similar to the one we already have installed at our ISP or can MySQL use the same one? Is a certificate even needed to do this? Do we need to install a certificate on the MySQL server? Any guidance is greatly appreciated. Do not purchase anything. You don't have to. Look http://www.mysqldeveloper.com/4.x-bk_tree/SSL/NOTES for use by example. You can use as long keys as you want and openssl supports. You need openssl to be installed (usually it is on every Linux, do not know about FreeBSD). I wrote original SSL part of MySQL and not sure if something have changed from this time. Shown file contains cutpaste from my console when I set MySQL up and running with SSL. Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [OT] LEGAL information about MySQL.
All who haven't read GPL FAQ, go and read it: http://www.fsf.org/licenses/gpl-faq.html Current discussion is covered beginning from: http://www.fsf.org/licenses/gpl-faq.html#ModifiedJustBinary http://www.fsf.org/philosophy/free-sw.html Also, discussion here reminded me MySQL vs Progress case when subsidiary of Progress named NuSphere violated MySQL AB rights in similar way as defended now by some persons. It is very similar to current discussion, so I think it is correct to include Eben Moglen's point of view here: http://www.gnu.org/press/mysql-affidavit.html Tonu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [OT] LEGAL information about MySQL.
On Sat, 2002-11-30 at 14:46, Pae Choi wrote: If MySQL plays so dirty, go with PostgreSQL. It's been known to be better and more acceptable in all platforms. Ex, they have triggers, etc that MySQL does not have. FUD. I pointed to information of FSF and people not related to MySQL. Seems like you name FSF understanding about GPL dirty. I can't agree with you. Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ssl support in mysql
On Fri, 2002-11-29 at 13:23, Giannis Vrentzos wrote: Hello. Can somebody tell me how can i enable ssl support in mysql? All is in manual. And manual is included with MySQL distribution and http://www.mysql.com. Always. In case of security-specific questions not covered in manual, come back and tell what you haven't found and you get answer from list plus manual gets updated. Tõnu (Did this SSL part) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LEGAL information about MySQL.
On Fri, 2002-11-29 at 14:59, Darney Lampert wrote: Hi, I'm beginner in maillist and my english is limited.. I want know about LEGAL MySQL software information. On www.mysql.com page, in download section I read that: You need to purchase commercial non-GPL MySQL licenses: If you distribute MySQL Software with your non open source software, If you want warranty from MySQL AB for the MySQL software, If you want to support MySQL development. distribute MySQL Software with means that my application (non open source) can use mysql if I not distribute MySQL with my application? In very brief: GPL licence protects original author of software from competing against own software. For example if somebody integrates MySQL into their software and starts to sell it, this is not allowed because then MySQL authors have do not have access to parts added to MySQL. You can integrate non-GPL software with GPL one only if: You never distribute it or You provide source code under GPL back to community. On all other cases you do not have this right under GPL licence. If you still want to integrate GPL and non-GPL software you need ask authors permission to use software under different conditions. In MySQL this means you have to pay for it and this seems fair to me. Tonu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: converting from foxpro to mysql ???????
On Wed, 2002-11-27 at 17:05, toby z wrote: ok guyz i need some inside info . plz help me with: 2. if i ve to conver a db in foxpro to mysql or sql which one should i preffer and y pz do nt use thz hax0r w0rdz It is really hard to read. Many people here do not speak english natively and even just using plain english is complicated. I am not going to read further about your problem. Sorry. Tonu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.0.1 SSL config - a shot in the dark
On Sat, 15 Jun 2002, Clay Loveless wrote: I've been trying to figure out how to set up SSL support in mysql-4.0.1 ... The online documentation is pretty sparse on the subject. Here's what I've got so far -- and so far this is *NOT* working. I'm putting it out here so that someone else may be able to fiddle around on their end and help figure out how to get this working. This part of MySQL is written by me and I am sure it worked :) 3. EDIT my.cnf ON CLIENT SERVER I added these values to my.cnf: [ssl] key = (LONG public key value - 394 chars - copied from server.crt) cert = ca.crt ca = (Organization Name answer from the Q A session while doing the first ca.key generation) capath = /usr/local/etc/mysqlssl nono, a lot of errors here. I am pretty sleepy and can do smaller mistakes right now but mistakes I see: section [ssl] is wrong. MySQL server uses [mysqld] section, command line - client [client] but nobody read [ssl] section! Everything should be added under those common sections - values key and ca are wrong. Should be ssl-key, ssl-ca and so on... So far, this hasn't worked ... But at least MySQL runs without errors, so I believe I've got the my.cnf variable names correct. Page 390 of the new Managing Using MySQL (O'Reilly) book provided some clues for doing this ... In reference to C functions, it says: 'key' contains an SSL public key 'cert' contains the filename of a certificate 'ca' contians the name of the certificate authority 'capath' contains the directory containing the certificate Hmm this is not the first time when O'Reilly publishes bad and misguiding book about MySQL. I personally suggest to avoid them. Paul DuBois one is good example. There is a file in MySQL source tree I wrote about using SSL connections with MySQL: http://www.mysqldeveloper.com/4.x-bk_tree/SSL/NOTES I hope they work for you. There are some pregenerated example key/certificate files included. You may try with then first to ensure that your command-line stuff works first. Like I said, this hasn't worked yet -- I'm still getting SSL is not in use when I connect via the mysql client. No errors appear in the error log. Any questions more which I can help to solve - please ask but keep discussion Cc:-d in this list. Also any sponsorship offers for developing SSL around replication are welcome. I am sure someone needs it :) Tonu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to increase max connections above 1024 in Linux
On Thu, 13 Jun 2002, Patrick Hsieh wrote: Hello, I want to raise the max connections in mysql. Due to the linux limix thread limitation, I can only increase the number to around 1024. How can I break the limitation? This is topic of glibc (assuming you are using kernel 2.4 at least). Look into links (I found them with Google right now): http://www.volano.com/linuxnotes.html http://www.mysqldeveloper.com/4.x-bk_tree/Docs/glibc-2.2.5.patch Tonu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: security paranoia
On Tue, 11 Jun 2002, MikeParton wrote: Where in the MySQL docs does it discuss DES_ENCRYPT/DES_DECRYPT support? Alternatively (and I am posting this to the php lists), anyone know where, or if, I can get pre-compiled libmcrypt library for php 4.2.1? http://www.mysql.com/doc/M/i/Miscellaneous_functions.htmlin the middle of page you cane find documentation about it. I do not know is there is a ready libray fo PHP but it is technically very easy to load any .so library into PHP and use it from Linux. So if you konw library you need then probably you can use them with dlopen() or whatever this function name was. Tonu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Foreign key integrity pb ?
On Wed, 12 Jun 2002, Christophe BRAM wrote: I'm using MySQL Max 4.0.1 CREATE TABLE TableTwo ( Id int NOT NULL auto_increment, FK_TableOne int NOT NULL REFERENCES TableOne(Id), PRIMARY KEY (Id) ) TYPE=InnoDB; -- How can this work without having beforehand created the table TableOne ??? Normally it should result in an error, shouldn't it ? MySQL does not use or check REFERENCES in any way. It just ignores them. MySQL does not give error on REFERENCES because compatibility but it still do nothing with this knowledge. References is one thing MySQL does not want to do as it reduces speed of DB. Tonu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: table is read only when DB copied from Win to UNIX
On Wed, 12 Jun 2002, Francisco Reinaldo wrote: Fine, I can see the database, show tables works, selects works. The whole nine yards? Nope! I cannot insert any values in that database. I get the following error: Table xxx is read only. I have checked the OS permission for that directory and I have given full persmission (write, read and execute). Also I have checked MySQL permissions, adding full permission for all users to that database but nothing. It looks like the problem is at the table level because when I manually add a new table to the MySQL UNIX, the inserts work. The only reason this can happen is wring permission bits no tables. Internally there is no way to make MyISAM (I assume you use them) read-only. Look as which user mysqld runs and make tables writable to that user. Tonu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: security paranoia
On Tue, 11 Jun 2002, Ray wrote: looking for something like encrypt(str, protected_str) and decrypt (crypt_str, private_str) and probably a make_key_pair() its not a vital part of my current project, but i'm sure someone will get cracked into (again) and then there will be another wave of secerity scares. (which again will die when they find out it was something silly like the employee who they where firing at the end of the week was the 'hacker') also, i can't seem to find much documentation on using ssl/x509 with mysql, anyone know of any good sites for this information? ENCRYPT/DERYPT are bad functions as they use some homemade algorithm. Can't suggest using it. Use DES_ENCRYPT/DES_DECRYPT instead. And this is the best what MySQL has at moment. These functions use 3DES symmetric algorithm encryption, so this is maybe not what you search for. But there is nothing else not counting MD5() hash function. MySQL supports SSL and X509 but for client-server connections. Any documentation you find describes related items. If you can provide exact idea what you want and sponsor this project I can write patch for MySQL adding new functions which support asymmetric encryption as you asked. But currently they won't exist there. Tonu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: license...
On Tue, 11 Jun 2002, Colin Faber wrote: According to the Arguments document this isn't true. The API's are published under the LGPL license and are not governed by the same restrictions as the server it self. 3.23.x API is LGPL 4.x is API is GPL 3.23.x and 4.x servers are both GPL Owner can always give out separate license for anybody, so if GPL does not fit you, ask MySQL AB for other license. But if you benefit from this, they also want to have a share. Sounds reasonable to me. Tonu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Advise Requested: Troubleshooting Perl/Mysql/Sendmail Performance
On Tue, 11 Jun 2002, Keith Smith (E-mail) wrote: The system: a perl mailing list tool which accepts add/deletes via emails (sendmail piped) and then updates the backend database accordingly. The problem: once about 10 or more emails arrive, I begin to get performance problems from the Linux box. The drive is on continuously, the system is unresponsive, and its difficult to determine where the bottleneck is occurring. (eg. a sendmail issue, perl code is inefficient, mysql performance issues, system resources, etc.). Low volumes ( 10) of email operate flawlessly. I figured a good way to begin was to instrument the various mysql activities to see how long they were taking is this a good approach? Any advise on different approaches? First, MySQL part of question: If you ever suspect, with any MySQL related application that MySQL is slow, run: mysqladmin processlist You should see at least some SQL queries in-process. Run it many times. Try to see what queries are usually waiting and they show exactly where you have bottleneck in MySQL. If there is no running queries then result is clear - It is not MySQL topic. Second, If there is a 10 mails coming in and there is a big and bad framework behind it, you may overload easily just launching too many processes to run. I have seen same problem with e-mail system which always launced procmail to process every mail he got. When 20 mails arrived simultaneously, system started to suffer. As easy it is. I do not know your system details but incoming mails+big machinery behind them may be a bad idea. Try to receive mails as they come (you can't do much against this) but process already received mails from some queue one by one with some delay between each query. You can work out some good throttles which stop processing queries if load goes over some limit or whatever like this. Tonu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: A Proprietary MySQL Business Model
On Mon, 27 May 2002, Solomon John HART wrote: How much third party software is incorporated into the non-GPL version of MySQL. Obviously the included software can't itself be under the GPL. How does MySQL get around this? Does MySQL have contracts with contributors instead of contributions being under the GPL? It seems like an interesting business model and one that deserves attention. Some keypoints: 1. There is some non-GPL code in MySQL. But this software uses less restrictive licences than GPL. Public Domain for example, so you should not be worried about it. There is no reason to get around it. 2. Yes, MySQL has contracts with all needed parties. I also wrote some code to MySQL and have signed contract. 3. Yes, it is interesting model in software world but actually it is not so new model at all. For example if you get free ticket to cinema then you don't expect receive free DVD too ? :). This is dual licencing and any author of any inntelectual property is allowed to do so. GPL is privilege, not limitation (for users) and does nut put handcuffs on authors hands. Tonu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Configuring MySQL 4.0.0 with SSL shortens idle timeout horribly
On Wed, 2001-10-31 at 21:53, [EMAIL PROTECTED] wrote: Description: Configuring MySQL 4.0.0 with --with-ssl causes the server to act as though interactive_timeout and/or wait_timeout were set to approximately 6 seconds, although the variables seem to have normal values. Thank you for bug report. I will reproduce and fix it. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Räpina, Estonia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access Denied
On Sun, 2001-10-28 at 13:52, Anoop Gupta wrote: Error: 1045 - Access denied for user: 'root@' (Using password: NO) Can you please help me out for the same.. Check out the manual. There are some good chapters about this: http://www.mysql.com/doc/A/c/Access_denied.html http://www.mysql.com/doc/R/e/Request_access.html http://www.mysql.com/doc/G/R/GRANT.html -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Räpina, Estonia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL licencing [id:fns]
On Mon, 2001-10-29 at 05:41, Gabor Penoff wrote: Hi folks, We'd like to distribute a commercial software - written by ourselves - and we'd like to use MySQL as the SQL server solution. The question is: do we need to buy MySQL server licence or not? I read the MySQL licening page sometimes, but it's still not clean to me. We will use MySQL as a SQL server platform - but we san use a Postgres or any other standard SQL server instead of MySQL. In my opinion we do not need a MySQL server licence in this case - because our application is not depending directly on MySQL. Opinions? If you want really official answer, mail to [EMAIL PROTECTED] I forward current posting there. Those people are responsible about related topics. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Räpina, Estonia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL performance and limit
On Fri, 2001-10-05 at 09:52, José León Serna wrote: Hello: I want to setup a machine with 3000 databases, each database will have 41 tables. Does MySQL support this configuration? What machine do you think will support this configuration? The purpose is to create a website with PHP+MySQL, is this possible? This should be no problem for MySQL. Everything is depending how to you use MySQL. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Windows Threads Support
On Fri, 2001-10-05 at 08:35, Manish Mehta wrote: Hello, Windows support 2000 threads by default (with the help of thread library). Then what a mean of max_connection = 100 because MySQL One each connection on differente thread. Is i able to increase the max_connection limit. Yes, you can change any variables shown with SHOW VARIABLES. MySQL reads default values from my.cnf file -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Encryption
On Fri, 2001-10-05 at 06:48, Manish Mehta wrote: hello, Is MySQL Support Encryption ? Depends what yo mean. Database encryption? No. Use crypted filesystem for this. Encryption functions? Partially yes. We have ENCRYPT() and MD5() functions. Encrypted communication? Yes, from 4.0.0 MySQL will support SSL secured connections. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Max Database
On Fri, 2001-10-05 at 06:21, Manish Mehta wrote: Hello Everyone, We are using MySQL as backend. What is Maximum size of MySQL Database? There is not limit on database size. Meanwhile there is a lot of limits which come from operating system you use. You have to read more: http://www.mysql.com/doc/T/a/Table_size.html -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL performance and limit
On Fri, 2001-10-05 at 12:13, Carl Troein wrote: It seems to be pretty popular to have a large number of databases, but I guess it's mostly due to having a large number of users. In pthe project I'm working on now we have 3 databases, 2 of which are mysql and test. However, some of our tables will grow quite big (several gigabytes). Will MyISAM be the best table type for those, or under what circumstances will/won't it be? Also, what file system (for linux) do you recommend? ReiserFS or ext3 or something else? There is no universal solution. HEAP tables are fast as they are only in memory, MyISAM tables are fast when used for reading, InnoDB is best on heavy use with concurrent writes. InnoDB and DBD are different in locking scheme, so depending on context DBD can beat InnoDB. Anyway usually we suggest to make decision between MySQL and InnoDB. BTW, this is unique in MySQL - you can have tables mixed to be transactional (InnoDB) and nontransactional (MyISAM) and use them mixed in same query. All other SQL-s (as much I know) have transactions on every table even if user don't need this. But usually tables contain different information, they have different usage and this affects things :) I do not know about ext3 much but rumours talk that it is just some kind of add-on on top of ext2. We have compared ext2 and ReiserFS when latter came out and ReiserFS was in some tests 30% faster in writes. Also ReiserFS can handle issues with directories containing 1 files much faster. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Windows Threads Support
On Fri, 2001-10-05 at 13:24, Jared Richardson wrote: Yes, you can change any variables shown with SHOW VARIABLES. MySQL reads default values from my.cnf file Actually, on Windows, it seems to read the c:\winnt\my.ini file, not the my.cnf file. My.cnf is used on the *nix versions. I only point this out as I wasted time looking for the my.cnf file! :) Sorry, I am using only unix systems. My fault. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL performance and limit
On Fri, 2001-10-05 at 17:06, David Turner wrote: BTW, this is unique in MySQL - you can have tables mixed to be transactional (InnoDB) and nontransactional (MyISAM) and use them mixed in same query. All other SQL-s (as much I know) have transactions on Oracle's Global Temporary Tables don't write to redo or rollback, and on normal tables you can alter table tablename nologging to shut transaction logging off. Thank you for information. As you see I have not much Oracle knowledge :( -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB Tables/Databases
On Fri, 2001-10-05 at 23:59, Benjamin Pflugmann wrote: Hi. Heikki, please correct me, if I say something stupid. ;-) On Fri, Oct 05, 2001 at 10:07:04AM -0700, [EMAIL PROTECTED] wrote: Deryck, others: I'm doing some reading on InnoDB and am pretty ignorant on the subjets. Can someone explain why would InnoDB be faster than MySQL? Please note that InnoDB also belongs to MySQL. What you probably mean is the MYISAM table type. InnoDB is just another table type. Well, table handler InnoDB is part of software MySQL. To be politically correct I have to say that company Innobase OY doesn't belong to MySQL AB :). InnoDB is by nature totally independent project which just contributing to MySQL. If you use transactions, InnoDB will be a lot slower than MYISAM tables. InnoDB seems to be faster, if you disable commits (or at least the disk flushes connected with that). I think, one of the main reasons that it can be faster than MYISAM tables is that it preallocates disk space. InnoDB is faster on write concurrency! This is the difference. Much smarter row-level locking. This gives the speed. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: IDE-RAID QUESTION
On 19 Sep 2001 12:25:35 -0700, Michael Tam wrote: Hi all, I realize IDE-RAID is relatively micky mouse to those SCSI-RAID but I would like to know if there is any beneficials running MySQL over IDE-RAID and is there any configuration I need to optimize MySQL to utilize the RAID?? RAID by itself doesn't mean much. You prorably have to define which exact RAID level you mean. Raid0 (striping), raid1 (mirroring), other raids? Of course, RAID0 can give double speed on whatever disks, RAID1 gives redundancy, and so on. RAIDx is usually right thing to go. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: REMOVE NOW THIS IS THE SECOND TIME
On 09 Sep 2001 21:24:51 +, Mourad de Riche wrote: Is he drunk or something? Report to a federal law? No, he is from United States. According to Sklyarov case they think that world consists only from them and everyone should follow their rules, even when not being U.S citizen nor located on U.S soil. Tõnu BTW, sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Notice about seconds overroll - S7K bug
(This is third attempt to post. always failed in some reason) I would like to make your attention on bug which was introduced tonight and can affect some people who are using (var)char field to store timestamp data. It is not worst security bug. It affects only people who already had bug in their code. Just now this bug become visible/exploitable. This is not MySQL bug. This is how people use their database. Also similar situation can be found in other software. I would like to inform people in public list as maybe some people have to search similar problems. The problem: Computers store time and date usually as integer value representing amount of seconds from 1 January 1970. Tonight it overrolled from 9 to 10. Possible bug and exploit relies on fact that some people have used character type of field to store this seconds information (we have already such case) example: mysql create table session (expire varchar(100) not null); Query OK, 0 rows affected (0.31 sec) mysql insert into session values (7), (8), (9), (10), (11); Query OK, 5 rows affected (0.00 sec) Records: 5 Duplicates: 0 Warnings: 0 mysql mysql select * from session; ++ | expire | ++ | 7 | | 8 | | 9 | | 10 | | 11 | ++ 5 rows in set (0.00 sec) mysql Let's assume that this table contains values we use somewhere to authenticate users. After user logs in, we write down session expiry time and later we check it like this: mysql select count(*) from session where expire = '132535'; +--+ | count(*) | +--+ |3 | +--+ 1 row in set (0.00 sec) mysql WOW, what happened? Shouldn't be 13253 bigger than any value in table? It worked yesterday! In MySQL we suggested people to use quotation marks around integer values. This can avoid many web-based attacks targeted to modify SQL commands (more information on http://www.mysql.com/doc/G/e/General_security.html). This is the reason why people put quotation marks around integer expressions and this is correct. Also automatic type casting will fix the source problem is column data is integer or some time/date vale. But when both column is character type and expression, they get compared as strings. And as we know, strings get sorted in order: 1,11,2,22 but integers: 1.2.11.22 So, this is why 13253 10 It is possible that some web applicatons have endless expiry times now and not only in MySQL contexts. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Billionium Bug
On 09 Sep 2001 17:23:39 +1000, Jason Brooke wrote: To Whom it may concern, I've noticed a bug with the Billionium. Now that we have hit 1 Billion seconds since the beginning of the Epoch mysql will NOT work properly with This is NOT MySQL bug. I posted separate message with needed explanations about this to mysql and bugraq lists. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: No Lock
On 26 Aug 2001 13:55:40 -0700, Jeremy Zawodny wrote: On Sun, Aug 26, 2001 at 11:52:15PM +0200, Boaz Yahav wrote: Does mysql have something like NO LOCK? SELECT * FROM mytable WHERE myfield='xyz' NO LOCK By default, no. But if you use InnoDB tables in MySQL, you'll get non-locking SELECTS, which is probably what you're looking for. See the docs at http://www.mysql.com/doc/ for more info. Yes, this is true. Additionally I would like to say that I asked similar question from Monty when I yet wasn't empoyed by MySQL and he told that usually same behaviour can be got if INSERT DELAYED is used. SELECTS do not lock on tables like adview/adclick stuff where no high accuracy needed. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: carrying database
On 27 Aug 2001 13:27:17 +0300, noe wrote: Hi my name is Nejat from Turkey and i am very new in databases .I have got a database in linux which is mysql and i want to carry this database to a windows system how can this be done.Any help needed.Thankyou! Search in manual for mysqldump -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Data Encryption
On 22 Aug 2001 17:35:58 +0100, Elizabeth Alderton wrote: If I do a SELECT query to bring data down to a PC (this is being done through Delphi) how can I encrypt the data so that it comes safely? Equally when doing UPDATE and INSERT in the other direction I would want to encrypt the data. Can anyone help please? We can't afford to use ssh - we would have to have a dedicated server. You'll have to create encrypted tunnel or wait until MySQL-4.0 which can do encrypted connections with SSL. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 'pre-load' data after restarting...
On 21 Aug 2001 10:48:03 +0200, Erlend Stromsvik wrote: Is it possible to have mysql load indexes into memory after a restart or reboot? The computer has 768mb memory, and after a reboot/restart I have like 700mb of free memory. Then when someone clicks a link on a page which runs a 'huge' query agains the server you get a pretty long loading time. The next time someone clicks the same link it's a fraction of a second of loading. And I see that I have a few mb's less of free memory. Same thing happens for every link that activates queries agains the database. So could I force mysql to load the indexes into memory when you start the computer? Ok, you can do it in many different ways. As most things are cached by OS you can do just cat /datadir/table.* /dev/null or execute some query accessing all needed data: mysql -e SELECT something /dev/null But it still seems that you can optimize your queries and MySQL server, not to do such weird things. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: apache stops in make
On 19 Aug 2001 19:44:40 +0200, Greennet wrote: /usr/local/mysql-3.23.41/lib/libmysqlclient.a(my_compress.o): In function 'my_uncompress': my_compress.o(text+0x9a): undefined reference to 'uncompress' /usr/local/mysql-3.23.41/lib/libmysqlclient.a(my_compress.o): In function 'my_compress_alloc': my_compress.o(text+0x12a): undefined reference to 'compress' This symbol is defined in libz: [tonu@x153 tonu]$ nm /usr/lib/libz.a | grep compress compress.o: T compress 00ac T compress2 T uncompress 187c t compress_block [tonu@x153 tonu]$ Have you zlib-devel RPM installed? -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: innodb on linux raw partitions
On 20 Aug 2001 11:09:37 -0700, Jeremy Zawodny wrote: Does this impression come from your bad experiences or those of others? I ask because we're about to upgrade one of our Linux MySQL servers to the 2.4.x kernel series and are looking to use software RAID + ReiserFS on it. If that's a lost cause, it'll save us some work and frustration knowing sooner rather than later... Maybe this is not what you want to know but hardware IDE controller is really cheap. I personally prefer cheap tuned ATA100 disks on top of hardware RAID. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: lotus - mysql
On 18 Aug 2001 18:53:16 +0200, Siim Einfeldt aka Itpunk wrote: Hi, I need to convert lotus database to mysql, how to do it? Right now the lotus datbase in a text file...what can I do it now? LOAD DATA check the manual for exact syntax for your case. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Accessing MySql database using Bash shell Script
On 17 Aug 2001 06:13:08 +, Munish Malhotra wrote: Dear Sir, Can you please tell me how to access data from a MySql database using a Bash Shell Script i.e. how to connect to a MySql database and retrive records and to disconnect from database. I shall be very thankful to you. [tonu@x153 tonu]$ /usr/local/mysql/bin/mysql -e SELECT NOW(); SELECT VERSION() +-+ | NOW() | +-+ | 2001-08-17 14:55:42 | +-+ +-+ | VERSION() | +-+ | 4.0.0-debug-log | +-+ [tonu@x153 tonu]$ There are some additional flags which can be used to turn headers and boxes around data off if you need to. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ 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
SORRY: I was wrong
Now again I want to tell sorry to everyone who was shoked by my letter which told that we do not give answers without money. The truth is that MySQL developers have about 20 different mailing lists to read in priority order. We have mailing list for people who pay for support and their mails get answered before anything else. Unfortunately we receive a lot of spam to this list plus many people just ask us for free support. This makes our work harder in many aspects. For example I receive e-mails related to some patterns directly to my cellular phone as SMS message. If signal/noise ratio is bad, I drop this list from such service to keep others running. There are also other reasons The mistake was that I forget that I am not anymore reading support list. I sent out two those our standard replies accordnig to our internal policy before I realized what I am doing. I want to apologize in public for doing such mistake. This is NOT MySQL policy and never will be. MySQL public list remains open, free and there will be developers answering part time of their workday. Please forgive me. On 14 Aug 2001 15:53:49 +0300, Sinisa Milivojevic wrote: Michael T. Babcock writes: Thank you for your technical question to the MySQL team. Unfortunately, our developers are not able to answer this type of inquiry if you have not purchased a technical support contract. I'd like to know if this is now official MySQL policy (filling the list with this letter repeatedly). If so, I'm unsubscribing ... -- Michael T. Babcock CTO, FibreSpeed Please excuse our colleague Tonu. He thaught that he was reading a support list. He has already appologized to you, and so do I ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: searching columns with lots of text
On 13 Aug 2001 21:11:21 -0700, Michael Collins wrote: Is there a common approach to searching within text columns that contain fairly large blocks of text (30,000 - 65,000 characters)? Is the recommendation, simply don't do it or is there some sort of workaround? I suppose one can search within these columns using the LIKE and % wildcards and risk slowing down activity to a crawl. I suppose indexing is not going to help in this case at all. But what does one do when it becomes more important that the search occur at all despite the time that it might take? Search for FULLTEXT in the www.mysql.com and also please read the following: Dear user, Thank you for your technical question to the MySQL team. Unfortunately, our developers are not able to answer this type of inquiry if you have not purchased a technical support contract. MySQL is a fully open-source product. This means that in nearly all circumstances you can use the MySQL database and its utilities entirely for free. Our main way of financing our team of 13 full-time developers is through paid support contracts purchased by customers like you. Without paid support contracts, MySQL simply would not exist. Our entry-level support contract costs just ?1000 EUROS annually (about $1115 USD), and our most expensive regular support is only ?5000 EUROS (about $5580 USD). For corporations with requirements for high availability we have more expensive telephone support options. These are extremely low prices compared against your costs for proprietary database products, and are low even when compared to rates charged by other open-source vendors. The PC you use for email probably cost more! So please consider investing in a MySQL support contract. You will be served not by a help desk, but directly by the developers who author MySQL's source code. Information: http://www.mysql.com/support/index.html Questions? : [EMAIL PROTECTED] To Purchase: https://order.mysql.com/ I myself was once a MySQL customer who was delighted with the skill and responsiveness of the MySQL team. I think you will share the same reaction. Sincerely, -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Copy of databse on my PC....
On 14 Aug 2001 06:32:16 +0300, Marius Pertravius wrote: Sveiki, mysql, I have a databse on the server. It os called ads. I want to make copy of it on my PC. I have Win32, Apache with PHP and MySQL. And I also have phpMyAdmin on that server. I'm writing this: mysqldump -A ads /home/myaccount/www/backup.sql But it says that i'm making a mistake. Please help me. how could I make a copy of that databse Dear User: Thank you for your technical question to the MySQL team. Unfortunately, our developers are not able to answer this type of inquiry if you have not purchased a technical support contract. MySQL is a fully open-source product. This means that in nearly all circumstances you can use the MySQL database and its utilities entirely for free. Our main way of financing our team of 13 full-time developers is through paid support contracts purchased by customers like you. Without paid support contracts, MySQL simply would not exist. Our entry-level support contract costs just ?1000 EUROS annually (about $1115 USD), and our most expensive regular support is only ?5000 EUROS (about $5580 USD). For corporations with requirements for high availability we have more expensive telephone support options. These are extremely low prices compared against your costs for proprietary database products, and are low even when compared to rates charged by other open-source vendors. The PC you use for email probably cost more! So please consider investing in a MySQL support contract. You will be served not by a help desk, but directly by the developers who author MySQL's source code. Information: http://www.mysql.com/support/index.html Questions? : [EMAIL PROTECTED] To Purchase: https://order.mysql.com/ I myself was once a MySQL customer who was delighted with the skill and responsiveness of the MySQL team. I think you will share the same reaction. Sincerely, -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: searching columns with lots of text
On 13 Aug 2001 21:11:21 -0700, Michael Collins wrote: Is there a common approach to searching within text columns that contain fairly large blocks of text (30,000 - 65,000 characters)? Is Oh NO! Sorry, I messed my mail folders. Please forget about my previous mail :( -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem creating a database with my ISP
On 13 Aug 2001 21:36:47 -0700, Manuel Velasco wrote: I am trying to create a database in my account at an ISP with a Unix Solaris server. The error message: mydomain.com% mysqladmin create newdb /usr/local/mysql/bin/mysqladmin: create of 'newdb' failed error: 'Access denied for user: '@localhost' to database 'newdb'' mydomain.com% You do not have rights to create the database. Read the manual about -u and -p flags to mysqladmin. You should prorably supply other username and/or password for this. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Sub select.
On 07 Aug 2001 10:46:31 -0400, Trond Eivind Glomsrød wrote: MySQL doesn't have subselects. Some workarounds can be found at http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#Missing_Sub-selects PostgreSQL supports them. Actually MySQL 4.0 will do. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql-php mailing list
On 08 Aug 2001 13:11:57 -0600, Jason Radley wrote: I have written a php script to get all the clients for a mysql table and send them emails. The problem is when the script is doing its job the browser times out and it stops the script. so I am sending about 300 email out of 3000. And the browser said page not found. Any ideas? PHP+browser are not meant to do such job. If you really like to do then: 1. PHP timeout is configurable (check the {PHP manual) 2. Run PHP processor from command line. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SELECT to get last entry
On 07 Aug 2001 07:24:59 -0400, Eldon Ziegler wrote: I have a table that includes a device ID (indexed) and the name of the device with multiple records ordered over time. How can I retrieve the last record for each device ID without retrieving them all to find the most recent name? I believe your answer is in using GROUP BY clause together with MAX() function. Other choise is to have separate tables for all device ID-s and join them using MERGE table type. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Some questions About DBMS.
On 07 Aug 2001 22:18:04 +0900, Heo, Jungsu Mr. wrote: Umm. MySQL AB Has any plan to make MMDB or Embedded DBMS? (Last month's survey asked us 'bout Embedded DBMS) Yes we are working hard to get embedded MySQL version possible in MysQL 4.0. This should make life easier for many software providers and also embedded version should be faster because missing communication overhead. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Sub select.
On 07 Aug 2001 14:57:33 +0200, Anders Alstrin wrote: SELECT * FROM media WHERE media_id = (SELECT media_id FROM category_locks WHERE category_id = (SELECT category_id FROM categories WHERE dynamic_media = 'true')) A MySQL way to do it? Something like that should work: SELECT * FROM media LEFT JOIN category_locks USING (media_id) LEFT JOIN category_id ON (media.category_id=categories.category_id) WHERE dynamic_media = 'true' (never tested as I do not have your tables handy) -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.co - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 PHP
On 07 Aug 2001 13:51:01 +0100, Matt Gaskin wrote: Currently I have rented space on a Web Server that has MySql installed and PHP, They have created a database directory for myself. Do I need to install Mysql and PHP locally to take advantage of this. If so where do I start. I have had no experience of the above two products, although I have written a number of websites in HTML and a number of access databases. We have just started to get a number of enquiries for databases online and would like to develope in this area. I believe your provider should support first step help for you as it depends on exact details how this site is set up and configured. Also take a look on simple PHP tutorials on the web. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql w/SSL support howto?..
On 07 Aug 2001 16:21:13 +0800, louie miranda wrote: Is it possible for mysql 3.23.40 to support SSL. hm, how? No, from MySQL 4.0 only. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Char Set (Arabic) question
On 04 Aug 2001 22:57:39 +0300, Khaled I. Hammouda wrote: Greetings ALL: I am developing a database application using mySQL php for a client that requires data entry (at least) to be in Arabic. I am know that mySQL supports charsets, but it is not clear if it supports charsets that are not left-to-right, such as Arabic. If the answer to this is obvious and documented then please accept my apologies, and direct me to the right resource(s). I didn't knew also and searched manual for word arabic. There was nothing about this. So if this charset not called somehow different then it is not supported. But if this an true we are really interested about information, how Arabic language is organized. Maybe you can point to some source on the web? Changing left-right directions seems easy to me on first look. We need information: Is Arabic an single or multibyte character set? In which order these characters should appear? (prorably some national standard describes this) Also we need information about upper-lower conversion if it is applicable at all. And after all the smallest thing is translating about 220 error messages to Arabic. This is the part we cannot do as nobody of us can speak this language as far I know :( -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Thinking of switching from MyISAM to InnoDB
On 04 Aug 2001 16:25:14 +0300, Sinisa Milivojevic wrote: There is no 4 Gb limit in MyISAM with later 3.23 versions. This limit is imposed by a filesystem only. and RAIDed table can help to build aby size tables if only index file doesn't get too big. Actually InnoDB is nice thing. Just bith MyISAM and InnoDB have good advantages and you should decide, which ones you need more. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ssl denial of service in 3.23.39?
On 01 Aug 2001 10:20:30 +0200, Johan Danielsson wrote: This bug-report is all from code inspection, so if I've missed something essential, please correct me. The reason I started looking at this is that I wanted to add some kind of Kerberos 5 support. It appears that the SSL mode in mysql is very broken. In mysql_real_connect you do: But this means that if the server doesn't support SSL, or worse, if some malicious guy turned off the SSL bit from the server to the client, SSL will not be used, without anyone finding out. If SSL is requested but isn't used, the connection should be terminated. In practice this probably means that any enctryption has to be negotiated before any other (vital) data is transmitted. Well, this is not finished and doesn't work at all. We will put x509 based GRANT stuff also into ACL-s, so non-SSL connections can be refused. Also there will appear functions to determine exact SSL cipher, keylength and certificate stuff. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: urgent: mysql compile problem
On 01 Aug 2001 15:36:55 +0800, Wong Ching Kuen Frederick wrote: i am using redhat 7.1 (i386-smp) kernel 2.4.6 gcc 3.0 mysql 3.23.40 ./configure --prefix=/usr/local/mysql --with-charset=big5 --with-mysqld-user =mysql Correct way is: make distclean autoheader aclocal autoconf automake ./configure --prefix=/usr/local/mysql --with-charset=big5 --with-mysqld-user=mysql If you still have same problem, downgrade compiler. We sometime tried to compile MySQL with gcc-3.0 but this is still is not well tested, so surprises can appear with it. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Waste of data while using MySQL database
Andis wrote: I have LAN with some PC, which use MySQL database. Sometime power supplay failure occurs. I have back-UPS too, but them can't hold power for 2 or more hours and because it server loose power supplay and just stop (without correct system shut-down). I got such problem: I waste data in this situation (users waste what them did). As I understand, MySQL server don't write data on disc immediatly, but after some time. What can I do for saving data regularly (for example once at hour or something like that)? mysql -e "FLUSH TABLES" writes everything down and closes all files. OS can then maybe delay it and you should issue "sync". -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Contact
Mr Alain KABUIKA wrote: I have made a script in PHP which creates a table in my MySQL database on Linux environment. When I run the script and give the name of table to create, there isn't problem if I'm using ASCII; but if I use a Japanese Charater encoded (JIS), I'm getting error message on those encoded characters, they are converted in ASCII codes with special charters + numbers, and mysql cannot takes it for a name of table!. I need help on this matter. Most places in MySQL accept anything if you provide them between ` marks. And watch out they are not ' but ` -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how do I do this?
Jeff S Wheeler wrote: [This is an email copy of a Usenet post to mailing.database.mysql] Just insert a row with the initial value you want minus one, and then delete it. That will make the table do what you want. mysql INSERT INTO Orders VALUES (-1, , NOW(), -1, 125478); Query OK, 1 row affected (0.03 sec) mysql DELETE FROM Orders WHERE OrderNumber=125478; Query OK, 1 row affected (0.02 sec) mysql INSERT INTO Orders VALUES (-1, , NOW(), -1, 0); Query OK, 1 row affected (0.02 sec) mysql SELECT LAST_INSERT_ID(); +--+ | last_insert_id() | +--+ | 125479 | +--+ 1 row in set (0.02 sec) You did not supplied us any information about your table structure. If this is an column named OrderNumber where you insert -1 then everything seems OK to me. Please descibe where you can see problem and what is your table structure. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: table types
Pete Kuczynski wrote: Hi, I understand mysql supported InnoDB and BDB table types for the purposes of transaction logging, which I need to use. Which is recommended by you folks for NT4 boxes. Test both if you need to know :) I believe that InnoDB is better now but this depends of context of usage. Test it! -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: encrition /security
webmaster wrote: I have a customer who needs to have a very secure site, more secure than usual, he thinks that having a secure server is not enough so what kind of security for his transactions can I offer him? we are not talking about money transfers, his bussines is not about money is about information, I need to implement for him a very secure way in wich the infromatino inserted in to a database (oracle) be encripted, wheren can I get info about this= cheers Ps my customer in in europe, cheers You can't do it in way I will learn fast by reading something. Pay to some expert who will consult you for all time of this project. Without you loose your customer now or in future. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: HELP ! Myisamchk doesn't seem to see error in my table :(
Fournier Jocelyn [Presence-PC] wrote: mysql SELECT * FROM forumconthardwarefr6 order by date desc limit 0,20; +--+-++-+-+---+---+-+-+-+-+ | titre| numeropost | ouvert | date| auteur | icone | nbrep | maxnumrep | vue | lastauteur | sondage | +--+-++-+-+---+---+-+-+-+-+ | Vds Barette EDO pour moins j| 8387233509356368993 | 0 | /-/-0--)0 26:25:28 | ssonneur_de_vie | 117 | 0 | 723859610131712 | 27016 | | 10 | | artitionz| 7300902383298871296 |100 | J521-99-51 55:87:56 | hork | 108 | 0 | 8289623147154535528 | 7696240 | fman | 118 | | city | 8320800813073630040 |117 | p706-83-13 97:69:41 | inary Finary | 108 | 105 | 8241943594372651008 | 5138548 | et | 0 | | et | 661841128741497964 | 7 | Å.()-*(-+. 79:64:86 | | 101 | 0 | 270336 | 24 | AZIZDELAZUP | 0 | cut The date column is DATETIME, and as you can see, the datas are completely corrupted, but myisamchk doesn't see anything wrong :( I believe your data is not restorable. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database Backups
MikeBlezien wrote: We just installed MySQL 3.23.39 on a Redhat/Linux6.2 system,..so far so good. We have about 30 customers who are currently using various dbs and was wondering if someone could recommend or has setup some sort of automated back up system for the db's. We use the mysqldump utility do backups, but was wonder if it's possible to setup some of program to execute a 'cron' type back utilizing the mysqldump utility, like once a day. Yes, cron is good tool and you should use it. Why do you need some else cron type when cron is avalaible? Just put right commands in /etc/crontab Ando take a look on mysqlhotcopy script. Some people prefer this to make backups of MySQL database. I do not take position in this. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Getting more than 256 connections with MySQL/Linux
Alex Coke-Smyth wrote: max_connections=300 basically anything over 256 ends up giving the error : Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug after 256 connections are open. There is plenty of memory available and checking the docs says you should be able to get up to 1500 : If you are using our binary or RPM version 3.23.25 or later, you can safely set `max_connections' at 1500 using a linux 2.2.19 kernel and glibc2.1. Has anyone experienced this problem or know how I can get around it? Yes sure! This is limit of linux 2.2.x kernel. Upgrade to 2.4.x OR change values in file limits.h of linux 2.2.x kernel. There is a value of NR_TASKS set to 512 which you should to increase. There are some comments about it also. All this is documented in manual... -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How do you insert into two tables at once
David wrote: I have two tables under the one database. What is the best way to INSERT data into both tables at once. Can I use one INSERT statement or do I have to use two? Do those tables have exactly same tructure? If you then you do not have to insert into two table but use MERGE table type instead when doing SELECTs later. I do not know your exact problem but looks like MERGE may help. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: character set
dodge wrote: I've problem with sorting table rows, thats why i need to get mysql work with my character set. can you explain better about ctype array when defining character set. I really did not understand about elements in this array. The rest ones to_lower, to_upper, sort it's simple just simbol codes in hexadecimal... I think answer you need is here: http://www.mysql.com/doc/C/h/Character_arrays.html Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: changing mysql prompt
Nissim Lugasy wrote: Hi , is there a way to change the default mysql prompt to have the current GMT time embedded in the mysql command line prompt and look something like this (and also have the time increase every time the carriage return is pressed) [GMT:193/12:13:45] Mysql [GMT:193/12:13:46] Mysql : : [GMT:193/12:13:58] Mysql is it possible? Currently no. But I don't see any reason why not to implement such feature except that we have a lot things in our TODO lists already and most new items will go to the end of this list. If you are paying support customer and really need this feature, write about this feature request into support list. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help needed
Kim White wrote: Could anybody tell me how to get rid of the following error on a php3 request. Warning: MySQL Connection Failed: Host 'hostname.co.za' is not allowed to connect to this MySQL server in /var/local/irm/irm.inc on line 83. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) Go to the manual on http://www.mysql.com and search for GRANT command syntax. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Update problems
Jesús Gómez wrote: I have a problem with the update querys. When i do a update in a table,it fails. If i do this query two or three times it works fine. There isn´t a table problem because this error happens in every tables. The select and insert querys work fine. Anybody knows what could be the problem? No, until you haven't supplied us with exact error message. Also please provide table structure and update command. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Manual for sale? (was Re[2]: mysql.org)
Colin Faber wrote: Michael, Interesting idea but I think it would problematic over all, The mysql manual changes almost everyday (anyone that syncs the bk tree's knows) I would suggest a better solution would be to provide the manual as a localized application (possibly even ported to PalmOS/WindowsCE), Anyone? ;-) Actually I know that Monty himself uses Palm with copy of manual in it. Meanwhile I never asked for technical details and do not know more about topic as I am not PDA owner (yet ;)). -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: simpify chinese and traditional chinese
Mark Lo wrote: Hi, Is it possible for mysql to store simpify and tranditional chinese. Yes, storing is not problem at all. MySQL can store any data without loss in binary fields. Problem is on sorting, upper-lower conversions and fulltext search. We do not have any chinese sorting as much I know, there is no such things like upper and lower case charactes in chinese languages and fulltext search doesn't work as chinese languages do not use spaces nor any other separator between words :( I am sitting here in Hong Kong and one of my targets is to get MySQL support both traditional and simplified chinese but as far I can see there is a huge technical problems. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql and PHP problems
[EMAIL PROTECTED] wrote: I have Mysql 3.22 and PHP4 installed with RedHat 7.0 linux distribution.I created a script connecting my html page with mysql database(function mysql_pconnect).Everything was working just fine one day but on the next day I saw a message on my screen "Call to undefined function mysql_pconnect".Could someone tell me how is it possible? --- This is easy to come and this is PHP topic. PHP can be configured to have many different modules included or excluded. Many distributions have MySQL included but not all of them. Some distribution have separate RPM for this. Some distributions require of changing something in apache/PHP configuration files. Whatever happened, someone changed something ni your setup. Fix? I do not know. Take a look in PHP configuration file and check, If mysql modules gets loaded somewhere there. You can also make small PHP script like: ? PHPINFO() ? and execute it. This will give you much information when and how PHP is compiled and what modules are available to him. Thispage should have information about includes MySQL module if it is included at all. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Effect of quoting numbers
Corin Hartland-Swann wrote: SELECT * FROM foo WHERE char_field = '96' AND int_field = 1; SELECT * FROM foo WHERE char_field = 96 AND int_field = 1; Is it the expected behaviour for the second query to perform a numerical equivalence test on every row in the table in turn? It is returning rows with values like '096', '96foo' and the like. MySQL does automatic type conversion when different types compared or assigned. As much I know String-Numeric is preferred there. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installinging MySQL on a virtual server
Ton Geurts wrote: Hi, I wonder I someone can give me some advice about the following situation. I have to install MySQL to be used with a website on a virtual server. This gives the following restraints: * MySQL must be installed in my user directory /usr/local/WWW/www.mydomain.com/mysql * I am only allowed to use the TCP/IP ports on the virutal host www.mydomain.com, not on the actual host. * I have no root access and cannot edit the startup scripts. * My provider uses BSDI BSD 4.0.1 as operating system on the host. Who has any clues for me? No problem. You can change all related paths in your .my.cnf file. Even better if you can compile MySQL and give command configure with flag prefix=/usr/local/WWW/www.mydomain.com/mysql to it, then MySQL will use all directories relative to this point. Because there is a more MySQL-s mabye running on same server, you can start server using --skip-networking flag. Then you still can use MySQL over socket ni your home directory. Only thing you cannot do without root access is having MySQL started when machine get rebooted. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PROPOUSE
suh wrote: I meet in share ver. of MySQL different lang. driver but no where UKRAINIAN. AND now I ask - I wont translete errmsg.txt and errmsg.sys for UKRAINIAN lang? Waiting for ansver! Just translate errmsg.txt and send it to us. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: change db name???
[EMAIL PROTECTED] wrote: what is the [MySQL] command to change an existing db name? No command for this but this is in our TODO list. (is there a book or manual with straightforward question and answer like this?) Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) You see this before posting ...? Here is the manual :) -- -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: re-sorting auto_increment fields
tj marlin wrote: you can postpone this problem for a very long time by using an unsigned bigint (0 - 2**64-1) note i said postpone, not eliminate. Have you done calculations, how long it takes to reuse all id-s? I have done :). I bet that auto_increment field will be still young, fresh and alive even when this application is already dead after many years. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Where is the MySQL-DBI-perl-bin RPM?
citizen wrote: $ rpm --test -i MySQL-bench-3.23.39-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.39-1 Where is the MySQL-DBI-perl-bin RPM? ftp://ftp.mysql.com/RPMS/i386 fox example is one place for it. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: BACKUP TABLE command error
Michael Collins wrote: I could not get the backup to work using the mysql client program. The table is a MyISAM type and I have a version (3.23.36) that should support the BACKUP TABLE SQL command. First I created a directory called dbbackup and then used the following: mysql BACKUP TABLE Example.Import_Web TO '/dbbackup'; +++--+--+ | Table | Op | Msg_type | Msg_text | +++--+--+ | Import_Web | backup | error| Failed copying .frm file: errno = 13 | | Example.Import_Web | backup | status | Operation failed | +++--+--+ 2 rows in set (0.02 sec) Anyone recognize the error? Use the utility perror to get meaning of OS low level errors. This is an Access denied and means that in some reason you are not allowed to write into this / directory. I think, this is normal :) -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: direct ISAM access vs. SQL parser
Jeremy Zawodny wrote: Perhaps, but it's not listed here: http://www.mysql.com/doc/manual.php?search_query=handlerdepth=0 I *think* that only searches the 3.23.xx docs. I just found the same thing. :-( Sure. We do not want to confuse people with manual of incomplete and unreleased version of MySQL. I know many people including me use it in production systems but they are people who trust MySQL enough. Officially we can't put this online yet until MySQL-4.0 is out. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql segmentation fault on starting
Hung Hing Fai wrote: Description: mysqld segmentation fault on starting How-To-Repeat: # mysqld Segmentation Fault # ldd mysqld ldd: mysqld: execution failed due to signal 11 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --disable-shared Perl: This is perl, version 5.005_03 built for i86pc-solaris Weird. Official MySQL binaries are all passed our pretty big and mature testsuite, so it should work.I am not trying to say that you are wrong :) but I would like to hear results if you download some other MySQL older version and try to execute it. Is there are any differences? Are you sure that your hardware is OK? I do not have access to Solaris-x86 now to test myself for this bug. If you can't find problem yourself then I am also located in Hong Kong and can try to solve this problem myself on your system. But I really want to avoid this if you are able to debug this stuff yourself. Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: linux-redhat 6.2
Bradley Jenkins wrote: i get this error when starting MySQL ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) /var/lib/mysql/mysql.sock exists with srwxrwxrwx and user mysql. There is a possibility that this socket file belonged to RPM version of MySQL but you are using some other MySQL binary which creates socket file in different place. You can check where MySQL listens socket by command lsof -an | grep mysql for example. You should see location of socket. If not, then MySQL does not run at all. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: re-sorting auto_increment fields
Kif wrote: Hi ANy idea how i can get my auto_increment fields to renumber themselves after deletion of records so that they all get re-ordered and run consecutively from 1 to whatever without any numbers missing ? Please help if you know how to do this I think we never will implement such stuff. auto_increment responsibility is to be unique and it should never appear back again when issued once. Idea is to identify record in database. If someone have right to reorder one table then relationships to other tables will be broken. auto_increment is totally technical field and if you do not like holes in it, programmer should use separate column for user-readable values additionally to auto_increment. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: characters supported in MySQL fields
Michael Collins wrote: I understand that any ASCII character can be stored within any of the non-numeric type fields. Does this mean just characters 1-255? No, MySQL supports also multibyte character sets used in Asian countries. This means much wider range than 256. What happens if I try to import a non-ASCII character, let say, into a VARCHAR field? Is it discarded or will I simply not be able to get into a MySQL field in the first place? Nothing bad happens. Just MySQL will decide later how to use it in ORDER BY clauses by character set stuff. Byte is byte. In addition, do all of the following need to be escaped before being insert into a database? \0 An ASCII 0 (NUL) character \n A newline character \t A tab character You should use mysql_real_escape_string() C API function. This will escape now and in future all needed stuff. If you still need explanation about escaping, read the manual on http://www.mysql.com. There is surely section describing what should be escaped. In other words, am I correct that none of these characters can be stored in a MySQL string field (such as CHAR, VARCHAR, or TEXT)? Yes. Problems appear when you sort those strings and they appear in wrong order. Take the manual and read about character sets and languages support. This surely helps you to avoid problems. -- -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql using tcp/ip
Richard Gibbs wrote: sorry if this is the wrong list I am a beginner user of mysql, but a few pl I know are very active in scripting using mirc, especially gaming using tcp/ip connections to game servers to find out various details. I would like to know how/if I can connect to a mysql database using tcp/ip as mirc allows connections of this type. if anyone has a few hints and/or webpages I can look at to get a good idea of where to go with this it would help immensely. be warned, I am a beginner, but my friends are not so any help at all would be appreciated. No problem about being beginner. We all be beginners sometime. About question: it is pretty senseless. mIRC is IRC client software for Wnidows as much I know. I do not care if has some kind of scripting made on it but there is still no relationship with MySQL database. Yes MySQL uses TCP/IP but you are trying to make something incompatible by idea.If you need database, forget about mIRC. If you need IRC then it is not related to database I believe. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqld as a library in 4.0
Brian P Austin wrote: Has anyone seen any documentation for using mysqld as a library. I am building an embedded device on a machZ chipset, and I would really like to be able to use mysql for some internal querying of our data collection. I can get it to run (barely) as is, but need more room and memory for other parts of the device. Yes, it is possible to use MySQL server as library and link it to your application. But please do not kill me if I am wrong (I am technician, not business man) but I have smoewhere in my memory that this required some special license. I Cc: it to licensing, they should tell if I am wrong. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: tables locked
Patrick Prémartin wrote: I use Delphi 5 and MyODBC to access a MySQL database. In my program, I've sometimes a tables locked and I don't understand why ! I am the only user on this database and I change records correctly (as I do it for other programs on other databases). Does somebody have this problem ? Can you explain me how to unlock tables and records with MySQL ? Is it a bug in Borland Delphi ou BDE ? Is it a bug in MyODBC ? Is it a bug in MySQL ? Is it a bug in my program (I don't see where I could have make an error... but it's a possibility) ? You did not included enough information to solve your problem. But I can thing we can solve it easily if you give us output of mysqladmin processlist while the problem exists. I think we can read out the problem from there. Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Tr: MySQL mailing list
Matthieu Neukirch wrote: We would be peased to be subscribed to My SQL mailing list. Regards, Dominique Vellin Business developement Please use the http://www.mysql.com always before posting any questions or enquiries into list! There is a simple technical procedures you should follow to subscribe yourself into the list. I think http://lists.mysql.com is the direct way but anyway our main site gives all answers or pointers to answers. Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: inaccesable mysql db from other users but root
alexus wrote: hi is it possible to make mysql db inaccessable from other users but root? This is the default behaviour of MySQL server. You should just have password on root user of MySQL. Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php