Re: MySQL Spawns Many Processes and Uses 100% CPU! PART #1
Okay, here is the problem: everyone once in a while, say once or twice a day, my web server running RH 7.2, PHP 4.0.6 and MySQL, will seem to freeze (from a web users point of view). Upon SSH'ing into the server, and running top I see the system load averages in the 90s (!!!) and all I see for processes on the list is mysqld. The CPU usage is at 100%, and the top mysqld process ususally is taking 14% or so, then 12% then a lot of 10%, and on down until it goes off the list. This is what I used to have. We invoked the scenario described in http://linux.oreillynet.com/pub/a/linux/2000/06/29/hdparm.html and since then things went back to normal without any other tuning. Oh, one more thing: I changed pconnect to connect in php. So it looks as like we had load problems at times due to poor hd performance which gave trouble to mysql. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Backups from Server to localhost
sql Stefan Hinz schrieb am Freitag, 17. August 2001, 21:28:54: It's not secure, though (http://www.securereality.com.au/studyinscarlet.txt), so make sure to protect the directory it's installed in with .htaccess when running it on a public server. To make a long story short: dont't trust user input. It took me quite some time to read through all this stuff. In the end, it is exactly as one of the quotes says: You know a conjuror gets no credit when once he has explained his trick and if I show you too much of my method of working, you will come to the conclusion that I am a very ordinary individual after all - Sherlock Holmes So all you have to do to make your phpMyAdmin unvulnerable is to change 2 types of lines in 7 instances in 2 files, see: http://www.securereality.com.au/patches/phpMyAdmin-SecureReality.diff In particular, these are: -if(file_exists($goto)) +if(file_exists(./$goto)) -include($goto); +include(preg_replace('/\.\.*/', '.', $goto)); With respect to general security, this is of interest also, in case you don't know already http://www.devshed.com/Server_Side/Administration/WebSecurityI/ With respect to trusted data, Koehntopp talks about it in the article webtuning http://www.koehntopp.de/kris/artikel/webtune/ (German, not translated yet, try http://fets3.freetranslation.com:5081/?Language=German%2FEnglishUrl=http%3A%2F%2Fwww.koehntopp.de%2Fkris%2Fartikel%2Fwebtune%2FSequence=core machine translations are sometimes fine, but often incomprehensible - seems like much work is left to be done there. His point is that _nothing_ coming from out there should be trusted and be checked against anticipated input.) -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error altering column name
I had this error under win when using phpMyAdmin quite frequently. It turned out that mysql creates temp files and somehow the process terminates. To get along, I dump the table, edit the sql file and reimport. Never had a problem with this method. Charles Mégnin schrieb am Freitag, 17. August 2001, 11:00:08: I am trying to change the name of a table column and get the following error message. I've tried both as a user and as root with no success. Thanks for your ideas mysql use music Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql alter table label - change name label_name varchar(30); ERROR 1: Can't create/write to file './music/#sql-28a_2d.frm' (Errcode: 13) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems with the unique properties...
UNIQUE is an index property. You need to remove the index with the drop command. Ciprian A. schrieb am Freitag, 17. August 2001, 15:01:51: *This message was transferred with a trial version of CommuniGate(tm) Pro* Hi, I have a table in my database that has one field named design_name. The design_name is varchar(200) unique. After I created the table the need appeared to have duplicates in this field. So I tried to remove the unique property. I used: alter table designs modify design_name varchar(200); I get an ok message but the unique property still stays among the field properties. How can I remove the unique property??? Thank you, Cip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Formatting Price Field in my Table so 0.20 does not become 0.2....
try varchar. pc schrieb am Freitag, 17. August 2001, 18:15:10: Hi people, Anyone know how to get a field in one of my table in a form that any number that I want to be displayed as 0.20 doesn't round off as 0.2? So 0.20 for the cost instead of 0.2? Or do I have to do this with the Server Side Language I'm using to format the value? Or some extra SQL command? Thanxs Steve Griff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: synchronisation (replication)
Neil Tompkins schrieb am Donnerstag, 16. August 2001, 14:20:07: Below is a message I posted earlier. But what I'm really looking for is does MySQL provide synchrosisation of data. If so, can someone point me in the right direction Well, I'll give it another try. The answer is Yes and No. Yes: you can replicate databases. You set up one database as a master and any number of other as slaves. These slaves may reside on the same machine or on any number of other machines. It is a one-way communication. The master is used to change data, the slaves to read data only. Very clean concept, seems to work well, although I didn't try it personally yet. No: as far as I understand your question, you want to synchronize data between your local machine and the webserver in a two way process. This is something I do regularly for some reason, i.e. users insert/delete/update the web database, I insert/delete/update some data locally for testing and later addition to the web. I don't see any way to automate such a two way communication, and it is certainly not possible with the replication mechanisms at hand. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: imigration of db from server 2 localhost as backups
use mysqldump, i.e. if you are in your data dir /usr/local/mysql/bin/mysqldump -c -h localhost -u user_name -p db_name | gzip -9 db_name.sql.gz hanan khader schrieb am Mittwoch, 15. August 2001, 09:02:49: Hi everybody ... I need ur help urgently in this: how can we make imigration of database from server to localhost as backups... Where can I find help in this, plz I need ur help. Thanks in Advance: Hanan M. Khader _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication
My ISP provides me with a MySQL database. I have installed MyODBC and MySQL on my Windows2000 machine. Can you tell me if its possible to replicate the database to my own computer, make changes and these be replicated back to the database hosted by my ISP ? You will have to do it manually, I guess. This is how I do it: If it is a one time operation, I use mysqldump, i.e. in Win it is \path_to_mysqlbin\mysqldump \path_to_datadir\db_name \your_path\update.sql on the local machine, I upload the sql file via ftp, then feed it into mysql like this /path_to_mysqlbin/mysql -hlocalhost -uuser_name -p /path_to_datadir/db_name /your_path/update.sql If I have a large db and little changes, this would be overkill. What I do is get a dump from the table I changed with phpMyAdmin (just a click), copy the row(s) added to an instance of phpMyAdmin pointing to my web site to a new file (a snap with my editor), paste it to the sql textarea and click the go button. If it is more than a few records, this is not feasible either, so I upload that file via ftp and feed it like above into mysql. If somebody knows an easier way, I'd be glad to learn. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error codes ??
perror will tell you Error code 69: Srmount error This looks pretty much like a system error to me. Ask your ISP. [EMAIL PROTECTED] schrieb am Donnerstag, 9. August 2001, 01:25:48: Hello, I seem to have corrupted mySQL deep down inside. I can not create any tables in any new databases. I will get the exact same errcode each time ... that is : SQL-query: CREATE TABLE test (user_id INT (6) not null AUTO_INCREMENT, notes VARCHAR (100) not null , PRIMARY KEY (user_id)) MySQL said: Error writing file './relata/test.frm' (Errcode: 69) I don't have root access to my server, and also can't find a list of what any of the errcodes mean. Looking for help Peter -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 2008 : MySQL client run out of memory
If it is a memory problem, try for example ini_set(memory_limit, 16M); in your script. Otherwise, it may be a loop that keeps allocating memory until it crahes. It this is the case, you won't get it through allocating more memory. Patrice Garbe schrieb am Donnerstag, 9. August 2001, 12:43:42: Hello, I have this error (2008 : MySQL client run out of memory) performing a request in a PHP script. However that request works perfectly under phpMyAdmin ! I tried to do a lot of mysql_free_result() in my script (because there are a lot of requests) but I doesn't work and I think It is useless. I looked on the PHP site to see if there's not a bug but I didn't configured my PHP with the --enable-memory-limit option. I have the version 4.0.6 with the mysql built-in support. Note that I first compiled PHP with the external mysql support and I had the same error. What's the problem ? How to find the cause ? I tried a debugger called Body but It is so slow that I could die before. Thank you Patrice - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 2008 : MySQL client run out of memory
Patrice Garbe schrieb am Donnerstag, 9. August 2001, 14:20:04: Then It is not a memory problem for ini_set() didn't work. It always crashes at the same point. Mysql doc says : ERROR 2008: MySQL client ran out of memory note that the error refers to the MySQL client mysql. The reason for this error is simply that the client does not have enough memory to store the whole result. But as I said the query works with phpMyAdmin and is performed several times in the script with free_results() after each performing. So look at the difference between phpMyAdmin and your script. I assume that you put your query into phpMyAdmin and that's it. In your script, you will obtain the same result when you do the same, as phpMyAdmin does nothing else than call the usual php functions. Therefore, I assume that you will do some other sort of things in your script, like a huge while loop which eats up memory. It isn't hard to construct such a thing. You didn't provide your code, did you? Patrice Le jeu, 09 aoû 2001, vous avez écrit : If it is a memory problem, try for example ini_set(memory_limit, 16M); in your script. Otherwise, it may be a loop that keeps allocating memory until it crahes. It this is the case, you won't get it through allocating more memory. Patrice Garbe schrieb am Donnerstag, 9. August 2001, 12:43:42: Hello, I have this error (2008 : MySQL client run out of memory) performing a request in a PHP script. However that request works perfectly under phpMyAdmin ! I tried to do a lot of mysql_free_result() in my script (because there are a lot of requests) but I doesn't work and I think It is useless. I looked on the PHP site to see if there's not a bug but I didn't configured my PHP with the --enable-memory-limit option. I have the version 4.0.6 with the mysql built-in support. Note that I first compiled PHP with the external mysql support and I had the same error. What's the problem ? How to find the cause ? I tried a debugger called Body but It is so slow that I could die before. Thank you Patrice - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Jason Radley schrieb am Mittwoch, 8. August 2001, 21:11:57: 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? Yes. It timed out. You adjust it with set_time_limit(0);//indefinitely -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Got an error reading communication packets
Colin Faber schrieb am Dienstag, 7. August 2001, 09:29:45: Before posting, please check: http://www.mysql.com/manual.php (the manual) -- http://lists.mysql.com/ (the list archive) Very nice hint, indeed, I didn't think of it before, and I experience these things, too. So I went to it and did a search on error reading communication packets which gave me 5 results. Fine. The first hint I found was max_allowed_packet Well, this is taken care of: set-variable= max_allowed_packet=16M http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html then continues to The MySQL server shrinks each communication buffer to net_buffer_length bytes after each query. For clients, the size of the buffer associated with a connection is not decreased until the connection is closed, at which time client memory is reclaimed. Does this mean that the error signals that buffer has become too low and will be increased again with each error? Sorry, I don't get that. DS wrote: Anyone seen this in your log file before? It's perlscripts on the same host, so before the DBI routine all the data needed for an insert is on the machine, not like it's loggin in from another machine. Could this be a problem with the loop back device? Any other ideas as to what causes mysql to spit this out? Thanks David 010804 20:00:40 mysqld started /usr/local/mysql/bin/mysqld: ready for connections 010805 4:08:29 Aborted connection 140 to db: 'rose' user: 'rainman2' host: `localhost' (Got an error reading communication packets) 010805 4:09:48 Aborted connection 166 to db: 'rose' user: 'rainman2' host: `localhost' (Got an error reading communication packets) = http/email [EMAIL PROTECTED] +380676920324 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Truncated User List
Steve Wright schrieb am Dienstag, 7. August 2001, 18:49:43: I don't mean to sound ungrateful to those who are trying to help me, I just need to grasp an understanding of what is causing my problem why. mysqldump has helped me solved moving my databases, however I can still recreate the original problem still do not understand it. You are correct, in my understanding it should have worked ok. So I am interested in a solution to this, too. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Logging connections
You have timestamp fields in your table. When the user connects, you insert a row. The first timestamp field is set to the entry time automatically, you just record the user. When he disconnects, you update the second timestamp with the disconnect time. You can later compute the difference. I wonder how you find out about the latter. Tadej Guzej schrieb am Dienstag, 7. August 2001, 15:37:59: How would I log connections to MySQL server? I need the time user connects and the time user disconnects. Thanks, Tadej - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
reading error
I experience entries in hostname.err like 010806 11:05:48 Aborted connection 1780 to db: 'pferdezeitung' user: 'pferdezeitung' host: `localhost' (Got an error reading communication packets) The frequency of serious problems has dropped since we changed RAM modules. The ISP tells me that he performed fsck after that which proves to him that there is _no_ hardware problem on the machine. So - what else can be the cause of the error? If I have few of those (reading or writing), the machine still runs, but if I have lots of them in the same second (say 40), mysqld and httpd change to status D in top and load average rises, response times get very bad. They have a cron job checking the bad condition every minute, which will kill and restart http, now every 5 hours or so, so we can live with it somehow. Before they changed RAM (and upgraded from 384 MB to 768), restart frequency was about 30 minutes. Anything I can do or tell my ISP? We run on Intel single CPU 700 MHz, Linux Suse with Kernel 2.2.19, Server Apache/1.3.19 PHP/4.0.4pl1 I told him that Sinisa recommended Kernel 2.4 and they tell me, that all of their machines run with 2.2.19 with no problems. They tell me they have one client with more than 1 million hits per day and a huge MySQL database, who never had problems. I asked about check free space on both datadir and TMPDIR and they say no problem. We run 3.23.33 and they don't dare to change versions because of possible problems. I don't have any experience. I suppose I could unpack and just change executables, but I am reluctant to try. We moved to that ISP 4 weeks ago. Before that, we never had any errors of that kind (reading or writing) AFAICS. We didn't have any problems the first 10 days (or we didn't notice them), then all of a sudden things went crazy. Quite naturally, I looked for programming errors first, but I can't find any and it doesn't look like there are any. We did have those errors right from the start, though, roughly 6.000 per day, more than 60.000 until we had massive problems and I found out about it in hostname.err. Any ideas where I can look at or test? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Index length too long, but no index specified!
I just tried with your definition and it worked fine. Johan Andersson schrieb am Montag, 6. August 2001, 14:03:42: Hi, I cannot find my answer of this problem in the manual. When trying to add the table below to mysql (3.23.36) I get the error that says the index is too long. But how can it complain about a index in this table when no index is defined for this table? Do mysql create a pseudo primary key when no primary key is defined? CREATE TABLE NPGE_RETTEN_TMP ( NP_NR NUMERIC(7,0) NOT NULL, GE_NR NUMERIC(18,0) NOT NULL, ORTSANGABE VARCHAR(100), TELEFON_NR VARCHAR(50), TELEFAX_NR VARCHAR(50), TEL_VORWAHL VARCHAR(20), BUCHTITEL VARCHAR(100), ANREDETITEL VARCHAR(20), BT_SCHLUESSEL VARCHAR(5), BEMERKUNG VARCHAR(100), LOESCHKZ VARCHAR(1), U_VERSION VARCHAR(1) ); Normally, I've got this error when using KEY(x, y, x) where the column length of x, y and z overrides 500 chars. Help, anyone? Regards, Johan Andersson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: '/tmp/mysql.sock' (111)
sarahana schrieb am Freitag, 3. August 2001, 03:07:31: If mysql is shown when runnnig phpinfo() - does it mean that its installed, and if yes, why this error? this only shows that php is compiled with mysql support. thanks, what needs to ben done? I assume you work under win. You need to start mysql - which is done with the executable mysqld - clear to unix users, unfamiliar to win users - means mysql daemon. This is done in a dos window. You should place it into your autostart group or use WinMySQLadmin to do this for you - quite handy, as this program takes care of closing mysql during shutdown - otherwise you have to do it yourself, and if you don't, you may damage your tables. Get yourself WinMySQLadmin from http://mysql.com Also, make sure you read all readmes and install guides and docs that came with the installation. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: importing text files using phpmyadmin
Glyndower schrieb am Freitag, 3. August 2001, 05:37:15: The error message says :MySql said: qUERY WAS EMPTY. When I try to import this data. looks like phpMyAdmin does not get the correct query. You have the source code of phpMyAdmin. Look into that, insert some debugging code and fix the problem. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: generate database script from existing table?
Tong Kiat, Chiah schrieb am Freitag, 3. August 2001, 12:44:45: I just took over a mysql database with no documenation. Is there any tools or anyway I could generate a database/table creation script from the current database? This is because I need to recreate the database on another machine and currently I have no way of doing so. get yourself phpMyAdmin and set it up (you need your username and such). Then it's a snap. Good tool for all sorts of things. Loog in google for it. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in a mysql table
joe schrieb am Freitag, 3. August 2001, 07:46:09: Would it be inefficient to use the command SELECT * FROM users_info WHERE name LIKE %phil% and company like % and address like %; What use have and company like % and address like % Omit it and you will be just as fine. If you have an index an name, that is. Otherwise mysql will have to read all records. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
No Database Selected /weird behaviour
Errno: 1046 Error: No Database Selected I get this on only one of my sites, on the first query during a connection only, and actually it is an impossible error. All sites are driven by db_mysql.inc from PHPLIB. Therefore, everything is totally automatic, no chance to omit the database name during connect. In fact, when the query returns that error, I jump in between and look for all the parameters, and indeed, they are present, including the database -- nothing else could be expected. If it occurs, it is a simple query SELECT * FROM lgs which will return the languages supported at the time, three right now. Simple table, simple query, three rows, so I guess the problem is not located here. I could hard code that stuff as well, but why? It worked fine for a year. So this is rather interesting indeed. Also, it does no harm as I default to a standard language if the query doesn't work. But I get an email notice, so I know. The rest runs fine, I didn't have problems although I reuse the connection and do a lot of other queries shortly thereafter. I notice this for at least 6 months now. It happens mostly in intervals, say once a day on three days a week. During the last week, the behavior changed slightly. I received thousands of notices during the period of about one or two hours, then things went back to normal. Before, I mostly received tens or at most hundreds of notices. top shows a really funny picture if it happens: typically no httpd, but 20 or more mysqld processes. I had a look at the hostname.log which looked rather normal, issuing queries that ought to be expected during normal page generation. hostname.err shows Number of processes running now: 34 mysqld process hanging, pid 2830 - killed Currently, there is only this client on the machine. Previously, I had another site on the same machine which produced much more load. Back then, I experienced similar problems with processes hanging. Is this a clue to something? What kind of questions could be asked in this situation? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How can try to recover the data from mysql
Rupak schrieb am Dienstag, 10. Juli 2001, 10:27:47: I think my mysql database carsh but I hope there are some utility to recovered the data crash. read on myisamchk or recovery in the manual. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Crazy Threads
Chris Hilbert schrieb am Donnerstag, 2. August 2001, 12:54:55: Its seems like the only way to watch the process list would be to do something like mysqladmin -uroot -i 1 processlist. Since I can't show processlist when it won't connect to it (I tried to do it while it was dead). Still, this would consume a lot of resource and might not even work right...since I'd technically have to wait an hour or so for it to crash. Any other ideas? You could watch the log file and error log. Those grow pretty big very fast, so you could rename the old ones and start new ones. Data from an hour should be easy to manage. Hence you will see exactly what mysql does and what kind of errors occur, if any. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Databases on Removable Media?
Gerald R. Jensen schrieb am Freitag, 3. August 2001, 02:51:36: Is it possible to create mulitple database directories ... with one of them on a CD-ROM? As far as I know, you can spread your data physically to different locations and different media. You will find information on this question in the manual. How about giving it a try? You will find out immediately. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 selecting something that occurred in past 5 minutes
Mark R. Cervarich schrieb am Freitag, 3. August 2001, 03:33:44: On 2 Aug 2001 [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: Part I == I'm setting up a cron job and want to be able to get records that have been accessed in the past X number of minutes. I tried doing this: SELECT postcard.uniq_id, (now() - accesstime) as smalldiff, recipients_last_name, accesstime FROM postcard HAVING (smalldiff =500) and (smalldiff = 0); and it sorta works. (By tinkering I've found out that each minute is equal to 100 'ticks'(?) - so in the example above, 5min = 500. But it fails if the event occurred at 4:47pm and now it's 5:02pm. ??? how did you define that field? I hope you defined accesstime as timestamp. Read on the definition of timestamp fields. Anyway, I'm sure there has to be a better way to do this...please help me! Also, what about in past 30minutes, past hour, past 6 hours, etc. Part II === How can I get a count of this - meaning I only want outputted a number that corresponds to how many uniq.id's have been accessed in past X time period. SELECT postcard.uniq_id, (now() - accesstime) as smalldiff, recipients_last_name, accesstime FROM postcard HAVING (smalldiff =500) and (smalldiff = 0); look for count(*) as ... in the manual. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query Acting Weird
Adam Douglas schrieb am Donnerstag, 2. August 2001, 19:14:15: I have a group of 3 queries that's used to find our representative for Unitary, Applied and Wholesale based on a Zip Code. This all is executed through PHP to MySQL. The three queries work fine and get the results I want. The problem is the 3 queries seem to work one minute but not the next. You could enter say 3 or 4 zip codes and have it return results with no problem, but on the 5 try it will crap out. This seems to be random, one minute it wouldn't work on the first try and then the next it will. When the 3 queries crap out it renders MySQL useless, you can send or do any thing to MySQL when the 3 queries crap out. It puts my CPU usage to 99.0% and stays roughly there forever. I've left the query running for more then 8 hours and still nothing seems to be returned. Can anyone direct me in the right direction on how to resolve this problem? I didn't have a look at your code as I don't think it is probable that you will have a problem here. These days, I am hunting problems similarly weird. I'm looking into faulty hardware now. Yesterday, we changed 2 of the 3 128 MB RAM modules, which has reduced problem frequency from 30 minutes to 10 hours. We see from hostname.err that the problem occurs exactly when the log records 010802 22:35:30 Aborted connection 231 to db: 'pferdezeitung' user: 'pferdezeitung' host: `localhost' (Got an error writing communication packets) So we will replace the 3rd module or all three to see what will happen then. It might be the hard disk, though, or the controller, or something else. Also, it may be a good idea to look at the hostname.log to see what mysql does when running wild. I did this to test queries that seemingly produced errors, but when reproduced, they did not, so this was proof that neither the query nor the data had problems. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 add an excel file directly to MySQL database using PHP?
Yeong CN schrieb am Freitag, 3. August 2001, 06:43:11: How can I add an excel file with *.xls extension directly into MySQL database..is it possible to do or I need to convert it into *.csv format or *.txt format first? You can put anything into MySQL provided you choose the right column type. In this case, you should use one of the text or blob types. Make sure you escape the special characters. If you program in php, you wrap the input with the function addslashes which does the job for you, and you strip the escapes back on retrieval with stripslashes. If you don't want to operate on these files, it is probably not a good idea to put them into the database. In this case, the general considerations regarding pictures apply. Here is what Rasmus says about storing pictures in databases: When dealing with images, it is of course possible to insert the image data into the database as binary blobs. However, the value in doing that is questionable. Until databases provide you with cool pattern recognition tools that will let you search a blob for a picture of a rose, having the image data itself in the database isn't of much use. Every operating system comes with a finely tuned blob database. It is called your file system. So, just put the full-path filename into the database and leave the images sitting somewhere on your disk. You will save yourself much aggrevation in the long run. As the data format of Microsoft files is not very good documented, I wonder what operations you may want to perform on those. Of course, they do have some ASCII inside you may search for. You seem to be willing to sacrifice all Excel specific data, which will happen if you convert to csv or txt. This looks like you are only interested in the plain ASCII and structure and don't want to conserve anything that adds on that. In this case it will be a good idea to convert xls to any of these formats, because you will save a lot of space. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: account?
This means that the user on that shared machine will get a user/password pair plus database for the mysql user table to be able to connect to mysql. Then he may see all databases on the machine, but can only access his own with his user/password pair. [EMAIL PROTECTED] schrieb am Mittwoch, 1. August 2001, 03:03:23: say i am running a server with mysql and phpmyadmin and i have some dbs (including of course the mysql db)... so when someone says to set them up a 'MySQL account' what exactly do they mean? and how do i do it? tia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: hostname.err
Sinisa Milivojevic schrieb am Mittwoch, 1. August 2001, 16:04:45: Werner Stuerenburg writes: To track down problems, I downloaded hostname.err, hostname.log and hostname-slow.log and, as these were quite big (log = 350 MB), I deleted them on the host. I remember that I turned on slow query logging and did not create the log myself. Therefore, I assumed that MySQL would create all these files anew. Instead, I found a new file called hostname-bin.001 which grew rapidly and has nearly 800 MB after a week. I had a quick look into that file and it looked pretty much like a log file to me. I couldn't find any information about this kind of beast. Finally, I created empty files hostname.err, hostname.log and hostname-slow.log yesterday and find that .err and .log have been written to, which may be normal. In addition, .001 has been written to also recently. Any explanation to what is happening here? My ISP says they didn't do anything with MySQL. -- Herzlich Werner Stuerenburg Hi! Check up startup variables or global config file. You have turned binary logging or replication ON. True. How did I do that? my.cnf says # Start logging log log-slow-queries Oh, I see ... some place else: log-bin Sorry for the confusion. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
(Got an error reading communication packets)
hostname.err says (Got an error reading communication packets) (Got an error writing communication packets) I had to shut down the server. What does this mean? This relates to SHOW PROCESSLIST Id Command Time State Info 6 Query 81 Locked SELECT * FROM staticStrings WHERE ruri = 'staticAnzeigenRubriken' 14 Query 38 Locked REPLACE INTO staticStrings (ruri, staticString) VALUES ('static/Rassen/%40_e4e8', ' !doctype ht 21 Query 83 Locked REPLACE INTO staticStrings (ruri, staticString) VALUES ('staticPferdQuAlter/5', 'DIV ALIGN=\'CE 22 Query 35 Locked REPLACE INTO staticStrings (ruri, staticString) VALUES ('staticAnzeigenQuUnterbringung/t', 'A N 348 Query129 Copying to tmp table SELECT * FROM staticStrings ORDER BY RAND() LIMIT 0,10 349 Query 66 Locked SELECT * FROM staticStrings ORDER BY RAND() LIMIT 0,10 350 Query 9 Locked SELECT * FROM staticStrings ORDER BY RAND() LIMIT 0,10 table definition CREATE TABLE staticStrings ( auto mediumint(4) unsigned NOT NULL auto_increment, ruri varchar(255) DEFAULT '0' NOT NULL, staticString mediumtext NOT NULL, PRIMARY KEY (auto), UNIQUE ruri (ruri) ); -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 know which row was affected with a querry ???
MySQL returns the autoincrement number - ask it! In php, this is wrapped into mysql_insert_id(); Zbigniew Szczesny schrieb am Montag, 30. Juli 2001, 21:15:37: Hello ! I have a following problem while scripting MySQL with PHP4: Imagine the user may add a record to a table. How can I know precisely what was the number (auto increment primary key) given by MySQL to this new inserted row ??? You may presume there are many simultaneus users adding rows, so I need a accurate information. Thank you for your kind help, Ziggi -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
msg from MAILER-DAEMON@web.mysql.com
This is one of several similar messages I received today. Someone to take care of it? Hi. This is the qmail-send program at web.mysql.com. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. [EMAIL PROTECTED]: Sorry, message has wrong owner. (#4.3.5) I'm not going to try again; this message has been in the queue too long. --- Enclosed is a copy of the message. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Security
You can protect the directory your file lives in with .htaccess Claudemir F. Martins schrieb am Montag, 30. Juli 2001, 17:17:53: Hello. How can I made a Database secure by using an PHP Interface ? I Mean .If I use a PHP interface there are passwords included in the PHP config files in the directory that must be readable for all (755). If a user get access to the directory (FTP) he/she will read the password and then get access to the MySQL Databases. Is there a good way to protect the passwords ? Regards Claudemir F. Martins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: msg from MAILER-DAEMON@web.mysql.com
Don't know. I receive messages, but some of my posts were not delivered with that obscure reason. Looks like an error of the mailinglist daemon to me. Adam Douglas schrieb am Dienstag, 31. Juli 2001, 21:12:06: Why can I not post to the mailinglist? -Original Message- From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 12:11 PM To: [EMAIL PROTECTED] Subject: msg from [EMAIL PROTECTED] This is one of several similar messages I received today. Someone to take care of it? Hi. This is the qmail-send program at web.mysql.com. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. [EMAIL PROTECTED]: Sorry, message has wrong owner. (#4.3.5) I'm not going to try again; this message has been in the queue too long. --- Enclosed is a copy of the message. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fwd: Re: msg from MAILER-DAEMON@web.mysql.com
Hi, Personnaly, I receive : recipient [EMAIL PROTECTED] does not exist, verify e-mail address, please From [EMAIL PROTECTED], and no way to send my mail to the list. Something is definitively wrong with the mailing list. Jocelyn Fournier Presence-PC - Original Message - From: Werner Stuerenburg [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 31, 2001 8:10 PM Subject: msg from [EMAIL PROTECTED] This is one of several similar messages I received today. Someone to take care of it? Hi. This is the qmail-send program at web.mysql.com. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. [EMAIL PROTECTED]: Sorry, message has wrong owner. (#4.3.5) I'm not going to try again; this message has been in the queue too long. --- Enclosed is a copy of the message. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ===8===Ende der Original-Nachricht=== -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Writing 100+ fields with Perl DBI
I don't see the problem. If you have a table with 120 columns and need to populate it, do you not want to do it with one insert statement? What else? I am not very familiar with perl, but in php it would be easy for me to construct the insert statement: You can read the columns names into one array; the values are in the array $HTTP_POST_VARS; so you loop over the arrays and build parts of your insert statement -- you only have to make sure you get the correspondence correct. If you name the columns accordingly, you don't even have to ask mysql about them. So you say: $q = 'INSERT INTO table ('; for ($i = 1; $i 120; $i++) { $q .= 'Q' . $i . ', '; } $q = substr($q, 0, -2); //take off the last ', ' $q .= ') VALUES ('; while(list(, $val) = each($HTTP_POST_VARS)) { $q .= '$val', ; } $q = substr($q, 0, -2); //take off the last ', ' $q .= ')'; //you are done, hoopefully, with something like //INSERT INTO table (..., ...) VALUES ('...', ...) Nelson Goforth schrieb am Dienstag, 31. Juli 2001, 20:47:31: In my application I'm writing up to 120 fields of data in one swoop (the results of a sort of survey). I'm using Perl DBI with MySQL. Each survey has several fields of data like 'name' (stored as parameters in the CGI object $asmt) and then up to 100 actual survey questions (Q1, Q2, etc). Until now I've just written one line of data to a text file, like: # Write basic data print FILE asmt - param('name') . \t; print FILE asmt - param('city') . \t; $v = 1; #write response to each question (Q1, Q2 etc) while ($v = $questions) { $x = Q . $v; print FILE $asmt - param($x). \t; $v++; } And this works fine for the text file - but from what I've seen I probably can't carry over the iteration through the (up to) 100 actual survey questions. I named the MySQL fields 'q1', 'q2', anticipating some way to do a loop, but I can't see it. Does anyone have any suggestions of how best to do this? The thought of one huge INSERT statement makes my eyes glaze over - I'm hoping there is a more elegant alternative. Thanks, Nelson -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fwd: RE: Re: msg from MAILER-DAEMON@web.mysql.com
Dies ist eine weitergeleitete Nachricht Von: Adam Douglas [EMAIL PROTECTED] An: 'Werner Stuerenburg' [EMAIL PROTECTED] Datum: Mittwoch, 1. August 2001, 00:40:33 Betreff: msg from [EMAIL PROTECTED] ===8==Original-Nachricht=== should I unsubscribe and then resubscribe to the mailing list? Don't want to cause any problems just looking for a good MySQL help resource. -Original Message- From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 3:20 PM To: [EMAIL PROTECTED] Subject: Fwd: Re: msg from [EMAIL PROTECTED] Hi, Personnaly, I receive : recipient [EMAIL PROTECTED] does not exist, verify e-mail address, please From [EMAIL PROTECTED], and no way to send my mail to the list. Something is definitively wrong with the mailing list. Jocelyn Fournier Presence-PC - Original Message - From: Werner Stuerenburg [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 31, 2001 8:10 PM Subject: msg from [EMAIL PROTECTED] This is one of several similar messages I received today. Someone to take care of it? Hi. This is the qmail-send program at web.mysql.com. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. [EMAIL PROTECTED]: Sorry, message has wrong owner. (#4.3.5) I'm not going to try again; this message has been in the queue too long. --- Enclosed is a copy of the message. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ===8===Ende der Original-Nachricht=== -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ===8===Ende der Original-Nachricht=== -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Parsing text file into mysql database.
I'll give you an example, step-by-step. I didn't do that kind of thing myself yet, so I had a look at the manual. First, I discovered that mysql can take all kinds of separators (I read that before, but forgot about it), so you don't have to convert at all, as you can signal different separators and delimiters to mysql. To get a text file in the first place, I issued the following command: SELECT * INTO OUTFILE result.txt FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY \\n FROM autoren; Here you see already that you can specify exactly how you want the records to be written. The result looked like this: 1,Werner Stürenburg,[EMAIL PROTECTED] 2,Priv. Doz. Dr. med. Th. Rommel, 3,Regina Steinkrauss,[EMAIL PROTECTED] 4,Uta Over,[EMAIL PROTECTED] 5,Paula da Silva,[EMAIL PROTECTED] 6,Friedhelm Splett,[EMAIL PROTECTED] 7,Kathrin und Eva Astl,[EMAIL PROTECTED] 8,Heidi Grieder Ulrich,[EMAIL PROTECTED] 9,Lena Scherling,[EMAIL PROTECTED] 10,Hardy Oelke,[EMAIL PROTECTED] 11,Elizabeth Wener, 12,Marianne Schwöbel, 13,Merten-Melching, 14,Dr. Otto Marré, 15,Taschen Verlag,[EMAIL PROTECTED] Now let's reverse the process. I used phpMyAdmin to copy the table autoren to autoren2, structure only (enter name + click). Now I issued the command LOAD DATA INFILE 'result3.txt' INTO TABLE autoren2 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY \\n; again from phpMyAdmin. This populated the new table with those values. Both tables are identical. I did all this on my local Win system. If you do it on your server, there are differences in syntax regarding the location of your text file, residing either on your local machine or the server. The latter is faster, as the data doesn't have to travel across the phone line (it had to earlier to get there in the first place), but you need the FILE priviledge in the user table to be able to do that. So if your text file is very large, I'd suggest you compress it, transfer it to the server, decompress it and load from there - make sure you have the file priviledge or else give it to yourself in this case. The advantage of this approach is that it is straightforward and as fast as can be. Kit Kerbel schrieb am Sonntag, 29. Juli 2001, 23:57:26: I'm sorry, I'm kind of a newbie at what you are discussing about converting to csv files. Could you explain the advantage of doing this as opposed to other ways, if any. Thanks. Original Message Follows From: Werner Stuerenburg [EMAIL PROTECTED] Reply-To: Werner Stuerenburg [EMAIL PROTECTED] To: Kit Kerbel [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Parsing text file into mysql database. Date: Sun, 29 Jul 2001 22:49:45 +0200 filter: mysql I don't have the original post any more, but you will have some kind of file where the records are lines and the fileds in the record are separated by some kind of character, say tab or blank or anything else, but you will know what. So let's say the filename is $filename and the separator is $sep. Then you read the content of the file into an array with $content = file($filename); Now the elements of the array are the records. You will have to convert the separator into , to get csv style. There are several styles to do that, for example while(list($key, $val) = each($comment)) { $content[$key] = str_replace($sep, ',', $val); } Now $content should be written to a file to feed to mysql. Well, this is a common task, and there isn't a handy php function as far as I know, so I wrote it myself (see below). With that function, I don't have to think about all that mumbo jumbo and get it right nevertheless: stringToFile(implode(\n, $content), $filename_csv); The implode function transforms the array to a string which can be written to the file, glueing the rows together with \n (new line) in this case. function stringToFile($str, $filename, $mode=a){ $fp = fopen($filename,$mode); $res = fwrite($fp, $str); fclose($fp); return $res; } Of course, I have written the reverse function, too: function fileToString($filename, $sep=' ') { return @implode($sep, @file($filename)); } The @ insures that no error messages are shown. So this function will return nothing if the file does not exist. Kit Kerbel schrieb am Sonntag, 29. Juli 2001, 21:33:16: I'm the original poster of the parsing text file into mysql database note. I am in need of some extra assistance on this topic. I kinda know what's going on here, but just need to see it to understand it, you know? So if you could, extra assistance would be greatly appreciated. Thanks, Kit Original Message Follows From: Werner Stuerenburg [EMAIL PROTECTED] Reply-To: Werner Stuerenburg [EMAIL PROTECTED] To: Kit Kerbel [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Parsing text file into mysql
Re: reindexing tables
What about issueing first drop index, then add index? Should do the job. Or repair table. What does check table or myisamchk say? shawn reed schrieb am Montag, 30. Juli 2001, 07:44:15: hi all, i apologize for the utterly newbie-ish question, but i've yet to find an answer to it after having spent quite some time searching mysql's web site (especially since half the links i click on now seem to be giving me 404 errors...) how does one reindex a table containing fulltext indexes? the reason i ask this is... a table that i had set up w/ fulltext indexes suddenly returns no rows when i perform a search on it... and it used to work just fine. everything i have read seems to be telling me to reindex the table.. and quite frankly that's the only thing i can think of doing since nothing else has changed that should be causing the searches to no longer function properly. any help would be appreciated. ~shawn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
addition for manual section 24.5.1
I don't know where to send this to, so someone who knows please forward it to the appropriate address. 24.5.1 Common Problems with MySQL and PHP Error: Maximum Execution Time Exceeded You can alter this value on a per script basis as well by inserting the following statement: set_time_limit(800);//e.g., 800= number of seconds This is handy if the user isn't allowed to change php.ini directly, mostly the case on multiple user-machines, or when occasional long jobs have to be performed. The same holds true to the ram allowed per script figure: ini_set(memory_limit, 16M); -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Parsing text file into mysql database.
Well, you can't do that with LOAD DATA INFILE. You will have to write some piece of code for that. Like so... $content = file($filename); while(list($key, $val) = each($content)) {//sorry, //I had a typo in here in my prev. post $content[$key] = do_some_error_checking($val); } with some do_some_error_checking function or while(list($key, $val) = each($content)) { if (do_some_error_checking($val)){ $correct_content[] = $val; } } and then work with $correct_content. Once you are at it, why don't you while(list($key, $val) = each($content)) { if (do_some_error_checking($val)){ insert_my_data_into_table($val); } } with the appropriate insert_my_data_into_table function, where your do_some_error_checking will return true or false only. You would get faster and better answers if you would provide as much info on your problem as possible. Don't hesitate to provide sample code and/or data - it is easy to skip text but impossible to imagine missing information. Kit Kerbel schrieb am Montag, 30. Juli 2001, 09:58:49: Sorry, last time. I previously was using the LOAD DATA INFILE... line of code. My problem consists of having to cycle through each individual entry into the table to do error checking to check for existing users, etc. Thanks, Kit Original Message Follows From: Werner Stuerenburg [EMAIL PROTECTED] Reply-To: Werner Stuerenburg [EMAIL PROTECTED] To: Kit Kerbel [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Parsing text file into mysql database. Date: Mon, 30 Jul 2001 08:56:47 +0200 I'll give you an example, step-by-step. I didn't do that kind of thing myself yet, so I had a look at the manual. First, I discovered that mysql can take all kinds of separators (I read that before, but forgot about it), so you don't have to convert at all, as you can signal different separators and delimiters to mysql. To get a text file in the first place, I issued the following command: SELECT * INTO OUTFILE result.txt FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY \\n FROM autoren; Here you see already that you can specify exactly how you want the records to be written. The result looked like this: 1,Werner Stürenburg,[EMAIL PROTECTED] 2,Priv. Doz. Dr. med. Th. Rommel, 3,Regina Steinkrauss,[EMAIL PROTECTED] 4,Uta Over,[EMAIL PROTECTED] 5,Paula da Silva,[EMAIL PROTECTED] 6,Friedhelm Splett,[EMAIL PROTECTED] 7,Kathrin und Eva Astl,[EMAIL PROTECTED] 8,Heidi Grieder Ulrich,[EMAIL PROTECTED] 9,Lena Scherling,[EMAIL PROTECTED] 10,Hardy Oelke,[EMAIL PROTECTED] 11,Elizabeth Wener, 12,Marianne Schwöbel, 13,Merten-Melching, 14,Dr. Otto Marré, 15,Taschen Verlag,[EMAIL PROTECTED] Now let's reverse the process. I used phpMyAdmin to copy the table autoren to autoren2, structure only (enter name + click). Now I issued the command LOAD DATA INFILE 'result3.txt' INTO TABLE autoren2 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY \\n; again from phpMyAdmin. This populated the new table with those values. Both tables are identical. I did all this on my local Win system. If you do it on your server, there are differences in syntax regarding the location of your text file, residing either on your local machine or the server. The latter is faster, as the data doesn't have to travel across the phone line (it had to earlier to get there in the first place), but you need the FILE priviledge in the user table to be able to do that. So if your text file is very large, I'd suggest you compress it, transfer it to the server, decompress it and load from there - make sure you have the file priviledge or else give it to yourself in this case. The advantage of this approach is that it is straightforward and as fast as can be. Kit Kerbel schrieb am Sonntag, 29. Juli 2001, 23:57:26: I'm sorry, I'm kind of a newbie at what you are discussing about converting to csv files. Could you explain the advantage of doing this as opposed to other ways, if any. Thanks. Original Message Follows From: Werner Stuerenburg [EMAIL PROTECTED] Reply-To: Werner Stuerenburg [EMAIL PROTECTED] To: Kit Kerbel [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Parsing text file into mysql database. Date: Sun, 29 Jul 2001 22:49:45 +0200 filter: mysql I don't have the original post any more, but you will have some kind of file where the records are lines and the fileds in the record are separated by some kind of character, say tab or blank or anything else, but you will know what. So let's say the filename is $filename and the separator is $sep. Then you read the content of the file into an array with $content = file($filename); Now the elements of the array are the records. You will have to convert the separator into , to get csv style. There are several
Re: howto insert an image as blob?
Do it like any other insert, but care for special characters. In php, you would wrap data with addSlashes() and remove them on retrieval with stripSlashes(). But... you better not insert images into a table. Yes, you can do it, but it is generally considered a bad idea. Read about it at http://www.bitbybit.dk/mysqlfaq/ - if the images have to be provided by users, use the upload functions of your system. php for example has upload support built in. Next you have to care for the appropriate write rights for those files. These can be handled safely without compromising system security. Store all data associated with the pictures in a table except the picture itself, which should be taken care of by the file sytem. [EMAIL PROTECTED] schrieb am Montag, 30. Juli 2001, 11:35:42: hello, plz can someone tell me howto insert an image as blob into a table. i have created a table with a blob column, but i dont know how to fill it with binary data like pictures e.g.. thx bastian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 dbs to mysql dbs
Have a look at AccessToMysql tools at http://mysql.com kaab kaoutar schrieb am Donnerstag, 26. Juli 2001, 20:18:54: Hi How can u take profit of my already done access dbs to create a new one in mysql ? Thanks _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FW: encrypt
Wouldn't that be a problem of your program? MySQL will sotre anything and not care about what it is. You encrypt first, then insert, next retrieve and decrypt. Jason Whitlow schrieb am Mittwoch, 25. Juli 2001, 17:34:05: I hope this is not to stupid. I have looked at how to encrypt strings in my database. I know that you need to use a blob and I think I can figure out how to encrypt from a query or SELECT but how do I encrypt on the INSERT. Thanks for your help Jason - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Date Format in MySQL
Claudemir F. Martins schrieb am Donnerstag, 26. Juli 2001, 21:03:59: Is possible to change the MysQL Date fromat from -mm-dd to dd-mm- ? No. This is the standard format. You can, however, reformat the result sets according to your needs. This format allows easy manipulation of date data in contrast to many of those accustomed to by local cultures. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 ROUND numbers
Your code doesn't make much sense to me, and especially not with respect to the question. I give you some comments below. Arnab (WebMaster) schrieb am Mittwoch, 25. Juli 2001, 09:23:39: How to round the result number after the multiplication, below are the PHP codes, any help greatly appreciated ?php If (@$rcurr ==) @ doesn't make sense here. It is used with functions to suppress error messages. { echo (); This doesn't make any sense at all. If you don't want any out put then don't do anything. If you have a if/else construct without action you can insert a comment like this if(...){ //nothing to do } else{ . } Better: leave that thing alone and write if (!...){ } ? ?php I hope you open your table somwhere. while ( $row = mysql_fetch_array($result) ) { echo(tr); echo(td . $row[Room_Category] . /td); echo(td . $row[Room_Size] . /td); echo(td align='right' . $row[xsp] . /td); echo(td align='right' . $row[xan] . /td); echo(/tr); } echo(/table); You close your table in any case, so you better put that outside your if/else-stuff. ? ?php } else { ? ?php while ( $row = mysql_fetch_array($result) ) { echo(tr); echo(td . $row[Room_Category] . /td); echo(td . $row[Room_Size] . /td); echo(td align='right' . $row[xsp]*$rcurr . /td); echo(td align='right' . $row[xan]*$rcurr . /td); echo(/tr); } echo(/table); } ? Write yourself a function like roundCurr() and then insert roundCurr($row[xan]*$rcurr) instead. To get a hint, how to do that, look at php.net and do a little research. You want to behave your reound function in a certain way, and it can be done very elegantly, as I remember, but I don't remember how and I don't want to do the work for you.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: timestamp problem
Omit the value for timestamp. mysql will do all by itself. Kory Wheatley schrieb am Freitag, 27. Juli 2001, 01:17:22: I'm using PHP to add records into a mysql database. The records write successfully to the database except for the timestamp field which I have defined as Field Type Null Key Default Extra TheDatetimestamp(14) YES NULL Everytime I write a record or edit a record it puts 000 in the TheDate, which of course is not the correct date. Here is the insert command below that I'm using, does anyone have a solution. $query3 = INSERT INTO Quser VALUES('', '$fullname', '$add_novell', '$tot_novell', '$add_cwis', '$tot_cwis', '$add_mail', '$tot_mail', 'TIMESTAMP'); mysql_query($query3); is the TIMESTAMP option where I get the current date from. -- # Kory Wheatley Academic Computing Analyst Sr. Phone 282-3874 # Everything must point to him. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unable to use shortcut keys
You mean within mysql? That's a program, doskey won't do anything inside that program. Oh junhui schrieb am Freitag, 27. Juli 2001, 06:49:05: Hi, I am currently using mySQL 3.23.39, under windows 98 SE environment. When i am running mySQL using MSDOS-prompt, there is no shortcut key available (all the arrows keys, ctrl+p, etc, don't work, even though doskey was enabled). Thanks in advance. JH -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: not null
Example: CREATE TABLE rassen ( id smallint(5) unsigned NOT NULL auto_increment, bezeichnung varchar(50) NOT NULL, kurz varchar(25) NOT NULL, total smallint(5) unsigned DEFAULT '0' NOT NULL, totalDeck tinyint(4) DEFAULT '0' NOT NULL, PRIMARY KEY (id), KEY id (id, bezeichnung), KEY kurz (kurz), KEY totalDeck (totalDeck) ); [EMAIL PROTECTED] schrieb am Freitag, 27. Juli 2001, 06:47:50: I am having trouble setting a column attribute to not null. Below is the statement I am using: create table table_name ( Column_Name not null ); If this is not the correct way to do it, can someone please help me...this is my first mysql database. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
top reports Status D
Server Version: Apache/1.3.19 (Unix) PHP/4.0.4pl1 MySQL 3.23.33 To find out about a peculiar phenomenon I am hunting for 10 days already, I added a stopwatch and record for each URL the elapsed time from entry of page construction to end. Right from the start, I get significant data: auto Timestamp URL secs 178 20010727193459 Preis/30-35 1.06 179 20010727193459 Preis/35-40 0.41 180 20010727193500 Preis/18-20 81.55 181 20010727193505 Preis/40-45 0.81 182 20010727193505 Anzeigen/Woche/9 2.68 183 20010727193526 1461 0.47 184 20010727193531 Preis/20-25 91.86 185 20010727193538 4485 0.17 186 20010727193549 Berichte/120 0.56 Entries 180 and 184 are extreme. All Preis-URLs fetch classifieds within that price range (horses 30.000-35.000 DM, for example). As can be seen from the timestamp alone, this is no human scanning the pages, rather a spider. The program is always the same, the table also, the only difference are the conditioning numbers for the query. Therefore, it is not likely to be a program or query fault, as this should produce equally bad figures on all URLs with that pattern. The table in question for the above data is ok, as might be suspected, because it is the same table with all queries, slow or fast. I just made a manual test with URL Preis/18-20: it took 2.98 seconds - so this is proof that it is not the data range that produces the differences. I show at most 10 records, and clearly there will be more in this range than in range 40-45 (in fact, we have no offers in this range right now). Time is consumed not in fetching the data but in producing the html for presenting the data. Did anybody ever see something like this? Should I upgrade to 3.23.40? Is it plausible that this is a problem with MySQL in the first place? Any places to look at in addition? Any ideas of how to track this thing down? What else can I say? When watching top, things go nicely for a while. If there is high load, it is significant that mostly httpd processes are shown, very seldom a mysql process. All of a sudden, the picture changes. Some mysql processes show with status column showing D instead of R, meaning uninterruptible sleep versus running. Looking at processlist, I may or may not see mysql processes. If I do, there are all kinds of status reports like sorting, opening, copying to tmp table etc. Without that state, I have little chance to see any processes at all (except root looking for processlist :-)), which seems to show that mysql is extremely fast. With these few mysql processes in status D, very fast some httpd processes show status D as well, and in addition, if there were many processes running and showing before, we have only a few shown with status D and few if any running. So if I let top run in the background without really watching, I will notice this change by the number of rows shown. Response time will decline very fast, load average will rise instead, and we have seen values of up to 200, at which situation the machine is essentially non responding to anything. The only remedy we know to date is killing and restarting Apache, which we do with a cron job every minute evaluating load average, but that's just a workaround for the moment. We will refine this watching for status D. I thought about bad queries or faulty code, but the data above does not back this idea. Also, we thought that the machine could not handle the load, but it happens with few hits as well and does not seem to accelerate significantly with heavy load. Actually, I don't know if the data shown above relates to Status D or not, but it is highly peculiar in any case and maybe significant. These are the first data that really show something weird. I have processlist and Apache status, but neither showed anything valuable. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 find out where the files are stored ?
On my system, they are in /usr/local/mysql I installed MySQL using the binay (RPM) version on RedHat Linus 7.0 How can I find out where the various MySQL files are installed to? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Dumping a database
use mysqldump - look for it in manual Philippe Pham schrieb am Montag, 23. Juli 2001, 11:16:08: Who know how to dump a database for backup it. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 move a database to a new server?
shutdown the server, tarball your data (mine is in /usr/local/mysql/var) and transfer, then put it all back. Andrew Pasetti schrieb am Montag, 23. Juli 2001, 13:47:32: Can someone please recommend the easiest way to transfer a database (with data) from one server to another? Here's the server info: Existing server: Linux 2.2.14-5.0 running mysql 3.23.10-alpha New server: Linux 2.2.14-5.0 running mysql 3.23.32 Thank you. Your feedback will be greatly appreciated. --Andrew -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: auto_increment, is this a bug?? Where to report it?
We had this discussion here a couple of days ago. There are versions of MySQL who behave this way, but it is mostly not considered the correct way. So you may as well get used to the idea that an autoincremented field is doomed to increment no matter what. That got me thinking...say you have a list of 500 people, and you delete the person with id 500 (The Person with the very last ID). Now, your ID's go up to 499. Now say someone else is added. Would they have an id of 500 or 501? For me it would be 500, which would create a security problem, but I very well could be doing something wrong. Is this a typical behavior? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Many students - each with own DB - would like to restrict size of each DB
I think this is a problem similar to that of ISPs. I don't know about this technique personally, as I am not fit on Linux/Unix, but restricting disc space on those systems is standard, so you will know how to do that. Databases for MySQL are just subdirectories, as you may already know, so you may very easily restrict disc usage on those subdirs for each student. Also, you may use symbolic links and place those subdirs into the dir structure you provide for the students anyway. Surinder S. Dio schrieb am Montag, 23. Juli 2001, 17:09:54: Hi, I work in a university and need to give students access to a MySQL database from their php enabled web server. The apache/php stuff is all working but I was wondering on some advise as to how best to deal with a large number of students. Ideally waht I'd like to do is to setup MySQL so that each student has their own unique database, accessible from their own userid, this would mean a large (1000) number of relatively small databases (I'm hoping to restrict each student to approx 20Mb for Db usage) and they could setup their own tables etc via something like phpMyAdmin. They can have full access rights to their own individual db - but not see any other students's. The machine I've set aside for this purpose is a Sun Ultra 5 - 256Mb ram - plenty of swap and fast local disk. ALso I want to restrict the size of the database for each studnet - as this is only for learning php/mysql purposes and if theirs a more serious project then I can provide other facilities. Is this going to to be achievable - how are other Uni's or ISP who provide MySQL dealing with this tpye of issue. If I can't restrict the size of each database - should I be pursuing some other db option? Many thanks in advance Rgds Surinder -- Surinder Singh Dio , School of Computing and Mathematical Sciences [EMAIL PROTECTED] , University of Greenwich, London, England. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 version to download?
http://mysql.com/downloads/index.html says: MySQL database MySQL Max 3.23 -- Beta Release MySQL 3.23 -- Stable Release (Recommended) MySQL 3.22 -- Previous Stable Release MySQL 3.21 -- Elder Release MySQL 3.20 -- Elder (no longer supported) Release So why don't you pick Stable Release You better learn to ask precise questions, give lots of information on what you experienced so far and be a little more polite if you want people to be helpful. Remember, nobody owes you anything, we all do it for fun and social responsibility. You may one day switch from the asking part to the answering part, too. Is there anything I do oversee or misinterpret? Neil Allen schrieb am Montag, 23. Juli 2001, 19:07:03: that didnt really help me at all! I dont know which file to download becaus ethe 1 at the top of the list is for mac the one under neath I have no Idea about same goes for the rest of them aswell - Original Message - From: Werner Stuerenburg [EMAIL PROTECTED] To: Neil Allen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, July 22, 2001 7:13 PM Subject: Re: what version to download? Hi I would like to download the MySQL server but I dont know which 1 I should download. I want to use it with MS Access and PHP so which 1 do I download? Take the latest version from the download area in http://mysql.com -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: downloaded file problem
I have download manual-split.tar.gz and couldn't open it (from www.mysql.com). tried with winzip but had the following error: Invalid Compressed Data - unable to inflate Looks like a download error. Did you try to repeat the download? which program should I use? why not Zipping the files? That's the Linux/Unix-way of doing things. If you use WinZip, you shouldn't have any problems unzipping those. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Delayed_insert
I just found that I can make phpMyAdmin display the processlist very conveniently. There I see dbCommandTime State Info pferdezeitung Delayed_insert 27Waiting on cond staticStrings Well, I know I experimented with INSERT DELAYED on table staticStrings, but what does this thing do there for that long? All other threads are sleeping. Something wrong here? I thought it should perform it's insert when there is idle time, which is now. I'm sure someone of you knows about what I'm missing here... -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: syntax problem
I rather thought that this was the whole purpose of this mailing list? You are right both in your inquiry and in your reply to Sinisa. It is not his usual way, though, I was astonished myself. I think most is ok. Try select handicap_results.date, handicap_results.victor, handicaps.icq_nick, handicaps.provisional, handicaps.handicaps, from handicap_results inner join handicaps handicaps on (handicaps.icq_nick = handicap_results.victor) group by handicap_results.victor, handicaps.handicap, handicaps.provisional, handicap_results.date I omitted some commas. A good way to find out is to construct a very basic query first which works and then make it more complex step by step until you reach the error condition. Then you will see exactly what it is that needs change. You should have the fix in a few minutes yourself with this technique. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 version to download?
Hi I would like to download the MySQL server but I dont know which 1 I should download. I want to use it with MS Access and PHP so which 1 do I download? Take the latest version from the download area in http://mysql.com -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Another Newbie Question
Bob Rea schrieb am Samstag, 21. Juli 2001, 19:14:34: On Friday 20 July 2001 10:46 pm, you wrote: You may want to understand what distinct and avg means. The combination doesn't make sense. I took the example in question out of a book that I am using to teach myself SQL. So I don't quite understand what it is after. It says, The following example uses the AVG() function to return the average product price offered by a specific vendorhere the DISTINCT argument is used so that the average only takes into account unique prices Does this make sense at all? in MySQL? Well, it came to me after my reply that this might be the meaning of the query. Actually, I don't know if this is standard SLQ and MySQL will support it or not. The error messages indicates it does not, but I may be wrong. Anyway, according to the example, it is clear that the average of all prices may differ substantially from the average of all distinct prices. If the latter does make sense economically is another question. The usual prescription for things not implemented is to look for a work around. In this case, it would be very easy to create a temporary table (could be a memory table which is very fast but has some restrictions), write all distinct values to that table and take an average from those. Thanks for helping a learner. You are welcome. Bob Rea schrieb am Samstag, 21. Juli 2001, 02:36:11: The SQL book I am using has this: mysql select avg(distinct prod_price) as avg_price - from Products - where vend_id = 'dll01' - ; and responds thus: ERROR 1064: You have an error in your SQL syntax near 'distinct prod_price) as avg_price from Products where vend_id = 'dll01'' at line 1 How do I do this, if I can? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 manager
should be an easy task to open a database and edit or create a new one should not need a server running for that. I do it all the time with Delphi maybe im not being clear Well, delphi has access to the borland engine which is a server in its own right. If you develop a delphi program which uses databases and want to install that on a customer machine, you will have to install the borland database engine there, too, in order to give him access to the data. IIRC, you will even have a borland db applet in your windows system area. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Put together (Merge) two tables in one
Wouldn't you do this in a loop? Where is the problem? I have two tables each with 12K records, I need to merge them into one single table and also check for duplicates. I'm thinking in doing it with PHP and Mysql. My idea involves one SELECT query and almost 12K insert query. Is there a faster way of doing using only MySQL? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Left Join very sloooowwww..
I added comments and a recipe to my debug function collection. You can download at the address http://pferdezeitung.de/php3/toosDebug.zip Well, I don't know about David, but I'd be very interested in your stopwatch program table, sql -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: concept of users connecting from different host
i don't understand what does connecting from different host mean? Where do you have this problem? 1. does it mean connecting from a different pc to the pc hosting the mysql server through telnet? Why would you like to do that? looks like a masochistic approach to me, under normal circumstances. 2. connecting from the same pc hosting the mysql server and specifying the host when connecting? Which would be localhost then, right? 3. running mysql client on a local computer and connecting to the pc hosting the mysql server. how do you connect in thisway then? Well, i do it through the browser as I use mysql on my server. in this approach, the connection is done through a cgi program running on the server, in my case php. in other words, I use php functions to connect to mysql, which means that the program connects to localhost. If I would like to connect, say, from your program on one machine to a database on another machine, then you will have to address that machine directly, for example with the IP number of that machine. You will have to insert a new user in the mysql database. Example: I manage my server databases through phpMyAdmin. This is a server based program, so it connects like all other server stuff through localhost. No problem. Recently, I downloaded mysqlfront (http://www.mysqlfront.de/). I liked that program very much, but as it runs as a standalone program on my client machine, it can connect to the database on that machine as localhost, but not to the web server. In order to do that, I would have to set up a new user and such. Another example. In addition to my own project, I have several customer projects. When I wanted to integrate data from a customer into my own project, I couldn't connect to the database of the customer directly because the ISP wouldn't allow it. When we moved to our own dedicated server, I moved the site of this customer to this machine, too. As I was master of this machine now, I could have realized my original plan to tap into the live data of this customer. In this case, both databases would reside on localhost. But it turned out that we had some problems. Now we moved our project to a separate dedicated server. As I am master of both machines, I will have to introduce the machine address of our project into the user table of the machine with the customer's data to realize my original plan. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: REPLACE single value
Sorry, I didn't use replace yet, I always work with update which is what I want. Are you sure you want to use replace? See the differences in the manual. The syntax for update is UPDATE table_name SET col1 = '$val1', col2 = '$val2', col3 = '$val3' WHERE primKey = '$id' or something -- you get the idea. REPLACE contacts (access) VALUE ('P') WHERE id=x -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SMP+mysql problem
It's normal that the mysqld is 795M big? If is not normal which could be the cause of this size? Certainly not. But Jeremy gave some comments; I don't know anything about this, I wonder myself. My processes are between 8 and 25 MB. PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND 14237 root 50 580 795M 33M sleep 187:33 0.15% mysqld This process is sleeping and consumes that much memory. This looks funny to me. Why should the sleeping process keep that much memory hostage? But most probably, I don't understand anything about what's happening here. Anybody out there? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 keeps corrupting
I experience something similar for a long time and try to find out what's happening. I cannot see any rule, so far. Any ideas what I could do to find out? For some days now, I didn't have problems now except for a duplicate entry error which shouldn't occur at all. Before, this indicated a corrupted index and/or table. But now the table is ok. Puzzling. BTW: I studied the sections in the manual about what to do if tables keep crashing. Sie schrieben am Freitag, 20. Juli 2001, 14:32:18: This is the feedback from repair: mysql repair table hits - ; +--++--+ -+ | Table| Op | Msg_type | Msg_text | +--++--+ -+ | counter.hits | repair | info | Wrong bytesec: 17-0-197 at 1097180; Skipped | | counter.hits | repair | warning | Number of rows changed from 8628 to 8627| | counter.hits | repair | status | OK | +--++--+ -+ 3 rows in set (0.71 sec) This has happened at least once a day for the past three days (ever since the hit counter got popular. This is the version: mysql Ver 11.15 Distrib 3.23.38, for apple-darwin1.3.3 (powerpc) And some other stats: Threads: 6 Questions: 2007 Slow queries: 0 Opens: 14 Flush tables: 1 Open tables: 4 Queries per second avg: 0.055 As you can see, it's barely ticking over compared to some installs I've seen. Any suggestions where to look for trouble here? Walter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.org
Absolutely great! You are so keen and brave - I wouldn't dare to and some others obviously neither! We need people who calm things down to make negotiations and an agreement possible, that's absolutely true, but we also need people to emphasize the frontiers to make a correct agreement possible in the first place. If it is not possible to distinguish between right or wrong, how will you hope to reach a basis that will last? It is not a question of politics, but of ethics and morals. I know that these are not counted upon in business, but ultimately this is what drives the world. And nobody will ever change the basic principles. You may have short term success violating those principles, but they will not last. Yesterday, I read an interesting German article about Bill Gates. A nice parallel was drawn to Napoleon and the like. All of these had huge success on the short run, but failed very soon. When I started in my computer business, Nixdorf was overwhelmingly successful. Five years later, they didn't exist anymore. They, like all big players at the time, held their customers hostage. Nobody liked that, so as soon as they had a chance they took their choice. The same will happen with Microsoft and any other endeavor which tries to force people into something which they don't really want. On the other hand, the open source movement is driven by huge energies which cannot be bought by money, no matter how much you want to throw at it. As they are negotiating right now, as far as I remember, this beautiful analysis may come a little late. On the other hand, they plan to take breaks and communicate, so I hope both parties will get to know your arguments. You are, of course, welcome to your opinion, and to the expression of said opinion. You are also liable to be judged on the basis of that expression, and frankly, your expression leaves me wondering about your wisdom and your analytical capabilities, not to mention your social skills. What - you work for NuShpere. My analysis of this affair is correct. It comes down to trust I TRUST MONTY. I do not trust Brit, and man who has abused the GPL, abused the MYSQL trademark, and broke the trust between the two partners. What do I base that trust on 6 years of contant communication and dependency of the MYSQL staff and my PERSONAL relationship with Monty and his Fella's as he called them. Furthmore, the assumption that under any condition NuSphere BROUGHT the right to open up shop directly under the MYSQL name and conduct independent sales, promotion and business, is damn off the wall, far fetched, and ridicules to asume, that you'd have to be a complete utter moron to beleive this report, and in addition, the report should be playing tomorrow afternoon on the Opra show, and be reported right next to the alien abduction story in the National Enquirer. Furthermore, their behavior secondary to this, and the proposition that they opened the mysql.org site as a Community site flies right in the face of the proposition forwarded by NuShpere that they opened the site with full rights to do so under previous agreements because they purchased control over the MYSQL trademark because they did in secret, then protested they had they right ot, after saying it was a communitee site, and then finally, they release they're Gemini code on it, only after 100's of people complained that they were violating the GPL. This is NOT the actions of an honest person...period... No We need NuSphere to admit their wrongs, make a blanket apology, and everyone can call a no harm no foul, and forget it happened. Ruben - End of forwarded message from Brooklyn Linux Solutions CEO - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Anyone knows what's wrong with this INSERT sentence?
I don't investigate the error -- why don't you put a unique index on email? That's how you get what you want. I have this two tables : table1,table2 . I would like to include all emails from table2 into table1 removing duplicates. INSERT INTO table1 (email) SELECT email from table2 where table1.email table2.email; MYSQL says: ERROR 1109: Unknown table 'table1' in where clause Both tables exist, what's wrong? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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!
What do I do next? Check in to mysql.com, look for AccessToMySQL tools, fget a distribution, set it up and convert your data. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Left Join very sloooowwww..
I added comments and a recipe to my debug function collection. You can download at the address http://pferdezeitung.de/php3/toosDebug.zip Sorry - in adding comments I inadvertently dropped several lines in function debugMsg. So if you downloaded version 0.4, please fetch version 0.4a. And then ... I missed to add table, sql etc. to this message! Sigh -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: auto_increment, is this a bug?? Where to report it?
The problem is...if I delete the third entry (Edicao = 3), the next entry inserted should be 3, right?! Well it is not! It is 4. Well, this may be debated. I suffered a lot from the behaviour you want to have. I considered it bad design ... An autoincrement field should not serve for counting or numbering but for making sure that you have a unique key - no more and no less - without having to think about it. If you count on this - that every record will have its own number no matter what happens - then the number of a deleted record _must_ be discarded. Of course, you can live with both implementations if you know what happens and what you're doing. Lastly, the trouble I had was nothing else than bad design. Relying on the unique key, populated other tables with this foreign key. When the row was deleted, I didn't care about deleting the dependent rows in the other tables and files connected with them (pictures). As a result, there was a good chance that somebody had the wrong picture in their classifieds: big embarrassment! Took me some time to find out about this scenario. Of course, the bad design was that I didn't care about deleting all dependencies including the files. But otherwise, I wouldn't have run into problems at all and only wasted disk space which isn't that much of a value these days. If you care to look at the manual, you will find explanations about this change in design. I don't remember the details now, but I know that I have seen them. Use the search box and you will find it fast. This explains why the behavior changes with the versions. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is last_insert_id reliable?
Currently, I have been counting the rows in PHP in order to get the value of the last hit_id in the database like this: You have mysql_insert_id() in php to get the last autoincrement value. This is _not_necessarily_ the same as the number of rows. It's staggering the difference in speed. But if I sit there and hit refresh on the browser, I get wildly different values for $pixels. It jumps around the actual number by +-10 or 12. The first method is precisely the same every time (unless a hit is recorded in the interim). Am I doing something wrong here? Well, I imagine that the last inserted id (not number of rows) will be given after you have actually inserted a row. I never tried to ask twice. Did you ever find that a variable in php shows a totally obscure value? If so, you may find that the value was not defined at all and point to some random memory block which contains some value from another process which you see. Maybe this is the case with mysql, too. So you better be sure to look for what you refer to. I made a search on LAST_INSERT_ID but it returned 0 results in mysql.com. Funny. Can I not count on MySQL to know how many rows it has recorded in a table? Any idea why that select statement would select a different row each time? This is a different question. You should ask SELECT count(*) as num FROM hits and then look at the value of num to get an answer to that question. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Randomize column order
How many rows do you have? I'd do it in php along those lines: read the rows from the old table in 3 arrays. randomize one or all of them (built in function in version 4, else do it yourself), then populate new table from those arrays. Sie schrieben am Freitag, 20. Juli 2001, 23:56:38: I'm sure I'm just missing something basic, but here goes... I need to create a table, populated with data, from an existing table. Easy enough: create table TEST select * from OLD_DATA Most cool. Now, let's say OLD_DATA has three columns: A, B, C. I want to create new table TEST, with all 3 columns from OLD_DATA, but.I want to totally randomize the order of column B. For example, I want to go from: FIRSTNAME LASTNAMEPID bob jones 1 marysmith 2 maddog brown 3 To this: FIRSTNAME LASTNAMEPID bob smith 1 marybrown 2 maddog jones 3 I guess what I'm looking for is something similar to this imaginary command: CREATE TABLE TEST SELECT FIRSTNAME, PID, (LASTNAME ORDER BY RAND()) FROM OLD_DATA; Any help is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Statement with AS Keyword
select table1.colOne as one, table2.colOne as two from table1, table2 where some condition... Later fetch the values with names one and two. Sie schrieben am Freitag, 20. Juli 2001, 23:55:45: I have two tables and both tables have a field name thats the same. I need to display both those field names back to the browser using PHP. I have used php to display all the other fields but I can't display these fields, because of the identical name. I know you can us the Select statement with the keyword AS to rename the fields to something else, but I can't get the syntax right. I hope someone can send me an example, my email is [EMAIL PROTECTED] -- # Kory Wheatley Academic Computing Analyst Sr. Phone 282-3874 # Everything must point to him. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fw: tricky RAND() function...
From the German php FAQ: version = 3.23 SELECT * FROM tabelle ORDER BY RAND() LIMIT 1 version 3.23 //see how many rows you have $result = @mysql_query(SELECT COUNT(*) FROM $table); $row = mysql_fetch_row($result); //produce random number out of that mt_srand((double)microtime()*100); $number = mt_rand(0,$row[0]-1); //fetch one record randomly $result = @mysql_query(SELECT * FROM $table LIMIT $number,1); Derick Dorner schrieb am Samstag, 21. Juli 2001, 05:33:13: - Original Message - From: Derick Dorner To: [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 3:11 PM Subject: tricky RAND() function... I am using MySQL 3.22, and need to know how to randomly select a record, therefore I can't just use the ORDER BY RAND() clause, because of my version. so i do this: SELECT field1,field2*0+RAND() as rand_col FROM TableName WHERE field3=5 ORDER BY rand_col; --according to paul dubois' book I have to do that field2*0+rand to override mysql's query optimizer...? This works great randomly selecting records, but it obviously also returns the rand_col column, which I can't have (I have to output the data (a picture) straight into a web browser). How can I either re-write this statement or hide that rand_col column from showing up? all i want to do is randomly select one column using mysql 3.22, is this that hard? thanks in advance! -derick -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fw: tricky RAND() function...
From the German php FAQ: version = 3.23 SELECT * FROM tabelle ORDER BY RAND() LIMIT 1 version 3.23 //see how many rows you have $result = @mysql_query(SELECT COUNT(*) FROM $table); $row = mysql_fetch_row($result); //produce random number out of that mt_srand((double)microtime()*100); $number = mt_rand(0,$row[0]-1); //fetch one record randomly $result = @mysql_query(SELECT * FROM $table LIMIT $number,1); Of course, you could encapsulate that stuff nicely into a function. Derick Dorner schrieb am Samstag, 21. Juli 2001, 05:33:13: - Original Message - From: Derick Dorner To: [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 3:11 PM Subject: tricky RAND() function... I am using MySQL 3.22, and need to know how to randomly select a record, therefore I can't just use the ORDER BY RAND() clause, because of my version. so i do this: SELECT field1,field2*0+RAND() as rand_col FROM TableName WHERE field3=5 ORDER BY rand_col; --according to paul dubois' book I have to do that field2*0+rand to override mysql's query optimizer...? This works great randomly selecting records, but it obviously also returns the rand_col column, which I can't have (I have to output the data (a picture) straight into a web browser). How can I either re-write this statement or hide that rand_col column from showing up? all i want to do is randomly select one column using mysql 3.22, is this that hard? thanks in advance! -derick -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Another Newbie Question
You may want to understand what distinct and avg means. The combination doesn't make sense. Bob Rea schrieb am Samstag, 21. Juli 2001, 02:36:11: The SQL book I am using has this: mysql select avg(distinct prod_price) as avg_price - from Products - where vend_id = 'dll01' - ; and responds thus: ERROR 1064: You have an error in your SQL syntax near 'distinct prod_price) as avg_price from Products where vend_id = 'dll01'' at line 1 How do I do this, if I can? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: blob question
Generally, it is not advised to add pictures to tables. See http://www.bitbybit.dk/mysqlfaq/faq.html#storing_images We had this question here some days ago, so it may ge a good idea to discuss at length possible problems why people won't like this approach of storing pics as files. WARNING: this is _not_ MySQL specific. You may want to stop reading here. 2nd WARNING: I will also show what can be done with all that information to arrive at some kind of content management wizardry. After all, people do use MySQL to do something with it, and many seem to manage pictures. So here it goes. If you let people upload images with php (which is built in and really easy) you will receive the images in, say some sort of tmp dir. You will have to move them in your code to a separate storage dir, as php will automatically delete the tmp files (see manual). Now php is part of httpd and that runs as nobody, so it cannot write to that storage dir unless you open that dir to nobody. This will be ok as you use this dir only for the purpose of storing those third party images. You may protect it in addition with .htaccess or move it out of the normal dir tree if you are a little paranoid. Now you can store the images as files with no problem and only note the filename and type or such (for example comments of the user to the picture) in the database. When you upload, you move the file, so this is a good point to record the file in your table. Once you are at it, you can retrieve the dimensions of that image with php function getImageSize and store them in your table together with the type as well. So now you know everything about this file you need for inclusion in your html code. Hence you write yourself a function, say getImgCode, which produces the html tags from this info, so you can insert the whole stuff into your code without any further thought like ... ?php getImgCode(firstNameOfMyPicture) ? ... You may even go a step further if you are in at content production. Let's assume the user uploads any text and pictures. The user is instructed to embed their pics with special syntax like ... stuff stuff stuff *MyImageFirstName* stuff stuff stuff ... You later insert the image with $content = preg_replace(/\*(\w+)\*/e, getImgCode($1), $content); This example is taken from http://php.net/manual/en/ref.pcre.php (I developed a content management system along these lines on my own, but this is just stunning - an incentive to learn the art of regular expressions). Sie schrieben am Donnerstag, 19. Juli 2001, 19:42:08: Hi, I'm new to blobs. I want to create a seperate table that will hold blob's or pictures. Each picture will be a .gif and will not exceed 100k in size. each image will be called, ord.gif, bar.gif, cmi,gif, lax.gif, jfk.gif, ord.gif, etc. The questions I had were 1. what would the create table statment look like. 2. Should I use a longblob based on my 100k .gif size? 3. Is one column with the gifs enough. Or should I add a autoincremented primary key? 4. Is it better to have a seperate table for this or, is it better to update my existing table, and add a blob column. Does it matter in terms of speed of queries? Queries will be done via php. Thanks! Pete -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: UPDATEing values in SET columns
I would take another approach. table 1 has only user_id table 2 has flag values and key user_id So you just insert rows or delete them in table 2. That's it. Did I understand your problem? Sie schrieben am Donnerstag, 19. Juli 2001, 20:24:17: Hi I have been searching through the manual and the list archives for the last few days regarding a problem I have with the SET column type. I'm creating an app that uses a SET column as 'flags'. Different parts within the application will check to see if certain 'flags' are enabled. As I understand, the SET column uses bit representation internally. My problem is updating the column with flags already set. Below is an example: The table is as follows: CREATE TABLE users ... user_id INT ... user_flags SET('another','test','pass_renew','none') NOT NULL DEFAULT 'none' ... When I update a record, I can only set the whole string not just the individual flag. i.e. This works fine... UPDATE users SET user_flags = 'test, none' WHERE user_id = 1 How can I add (or remove) values within the SET column without affecting the existing contents? I've tried a number of ways with no success!! For example UPDATE users SET user_flags = CONCAT(user_flags,'pass_renew') WHERE user_id = 1 Any help or pointers would be greatly appreciated. Thanks Nick Brandon P.S. Please cc my email address as I'm not subscribe to the list - Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: blob question
What I need to know is: 1. what would the create table statment look like in Mysql. DROP TABLE IF EXISTS pictures; CREATE TABLE pictures ( id mediumint(4) NOT NULL auto_increment, comment text NOT NULL, width smallint(6) DEFAULT '0' NOT NULL, height smallint(6) DEFAULT '0' NOT NULL, format varchar(4) NOT NULL, PRIMARY KEY (id), KEY pid (pid) ); You may add other colums as needed or create other tables with foreign keys to this to connect the picture data to other data, e.g. texts, classifieds, whatever. 2. Should I use a longblob based on my 100k .gif size? You should provide for enough space in the field to hold your data. The field definitions tell you what is provided. If you deliver greater values than storage space, MySQL will truncate your data. You will want to acoid this. 3. Is one column with the gifs enough. Or should I add a autoincremented primary key? That is always a good idea, unless you use a foreign key which in turn will most probably be an autoincremented key itself. 4. Is it better to have a seperate table for this or, is it better to update my existing table, and add a blob column. Does it matter in terms of speed of queries? I would create a separate table. No, rather I would not store pictures in a table, as said. Werner Stuerenburg wrote: Generally, it is not advised to add pictures to tables. See http://www.bitbybit.dk/mysqlfaq/faq.html#storing_images We had this question here some days ago, so it may ge a good idea to discuss at length possible problems why people won't like this approach of storing pics as files. WARNING: this is _not_ MySQL specific. You may want to stop reading here. 2nd WARNING: I will also show what can be done with all that information to arrive at some kind of content management wizardry. After all, people do use MySQL to do something with it, and many seem to manage pictures. So here it goes. If you let people upload images with php (which is built in and really easy) you will receive the images in, say some sort of tmp dir. You will have to move them in your code to a separate storage dir, as php will automatically delete the tmp files (see manual). Now php is part of httpd and that runs as nobody, so it cannot write to that storage dir unless you open that dir to nobody. This will be ok as you use this dir only for the purpose of storing those third party images. You may protect it in addition with .htaccess or move it out of the normal dir tree if you are a little paranoid. Now you can store the images as files with no problem and only note the filename and type or such (for example comments of the user to the picture) in the database. When you upload, you move the file, so this is a good point to record the file in your table. Once you are at it, you can retrieve the dimensions of that image with php function getImageSize and store them in your table together with the type as well. So now you know everything about this file you need for inclusion in your html code. Hence you write yourself a function, say getImgCode, which produces the html tags from this info, so you can insert the whole stuff into your code without any further thought like ... ?php getImgCode(firstNameOfMyPicture) ? ... You may even go a step further if you are in at content production. Let's assume the user uploads any text and pictures. The user is instructed to embed their pics with special syntax like ... stuff stuff stuff *MyImageFirstName* stuff stuff stuff ... You later insert the image with $content = preg_replace(/\*(\w+)\*/e, getImgCode($1), $content); This example is taken from http://php.net/manual/en/ref.pcre.php (I developed a content management system along these lines on my own, but this is just stunning - an incentive to learn the art of regular expressions). Sie schrieben am Donnerstag, 19. Juli 2001, 19:42:08: Hi, I'm new to blobs. I want to create a seperate table that will hold blob's or pictures. Each picture will be a .gif and will not exceed 100k in size. each image will be called, ord.gif, bar.gif, cmi,gif, lax.gif, jfk.gif, ord.gif, etc. The questions I had were 1. what would the create table statment look like. 2. Should I use a longblob based on my 100k .gif size? 3. Is one column with the gifs enough. Or should I add a autoincremented primary key? 4. Is it better to have a seperate table for this or, is it better to update my existing table, and add a blob column. Does it matter in terms of speed of queries? Queries will be done via php. Thanks! Pete -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D
Re: Backup of databases.
i cannot start my mysqld server on my Unix OpenBSD 2.9 Server, because i have a problem after i have restarted my server. So how do i take backups without connecting to the mysqld server, i have access to the files that is placed in /var/mysql but i cannot you mysqldump because of the server not is started and not can be started.. If your server is not running, your files in .../mysql/var will hopefully be in a good state (otherwise you have to run myisamchk anyway) and no changes are written to them. Fine. So you just copy all files to some other place. No dump necessary. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Questions about extremely large database support
Is mySQL up to such a task? I have been using mySQL for four years now, but have never used it in a project of this magnitude. We'll be handling financial data in the database, so integrity is important. I think so. You find impressive statements on the mysql site about speed size reliability incl. testimonials. Also, you may want to consider the new innobase table type - see statements at their site as well. Where can I find information about very large databases with mySQL? See above. Also you will find statements in the list archives lists.mysql.com, but you may have a harder time searching the appropriate posts. Is there a really efficient way to implement a function like indexseek() in FoxPro? This function will simply check an index to tell you if a record with that key exists. Sort of like select count(id) from Foo where id=1 except that it doesn't actually fetch the field value and it just checks the index file, not the data file. As far as I know that's exactly what MySQL does. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Please help - does changing the port the web server listens on affect mysql?
Congratulations to the Webby Award! MySQL knows nothing of the ports that your Web server may listen to. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Upgrade MySQL
You may want to have a look at http://www.mysqlfront.de/ Sie schrieben am Freitag, 20. Juli 2001, 20:29:32: does someone have a windows based program to manage, create and edit a database abd table off line -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Left Join very sloooowwww..
where I want to find a customer + order.. I have a separate customer database which I can link to the orders, but this linking adds a very huge delay (about 15 seconds on a search).. When I just use the orders table (with no linking) because 99.99% of the cases we need to look up a customer who has placed an order the query is very fast... It looks that as soon as if I start to link a table with more than 1000 records the machine is having a hard time.. Is it better to use a where clause to link the tables..?? Thanks for any suggestions: Bye Bye David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Sysdate????Date????Please help
I would call the program via cron job. The program would query the database, produce the mails and feed them to sendmail. I work with php, but don't know about java. I planned to add this feature to our card program, but didn't have the time yet. to send the greeting at a later date,not today. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SMP+mysql problem
What I am stumbling about is this: PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND 22889 root 30 330 801M 11M cpu0 23.6H 26.75% mysqld Is this really true: size 801 M How can that be -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Faults
The main aspect I'm interested in is avoiding data loss. So I want that any change to database must immediatly (or at least on regular intervals) be made persistent. Is there any configurable parameter to do this? You may want to read about transaction services. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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[2]: mysql.org
table This statement/release was very ordinary, very normal, very to-the-point for any situation such as this. Condescending, no. Condescension, like beauty, is in the eye of the beholder. Well, I didn't plan to give my opinion on this subject publicly. But, I was alerted by the last post of Mr. Johnston and am concerned about this interpretation I refer to. I have to admit that English is not my native language and I may miss a lot of meaning. But this is the situation of the MySQL people as well, and I know English good enough (and the art of negotiation and politics) to feel strongly what happens here. Incidentally, this morning I received a long elaboration about spam, written by a long-standing spam fighter. We all know that this subject is equally unpleasant. He closes his remarks with the following, which I think applies to the recent dialogue as well: I remember when I first read Orwell's 1984. The concept that really got my attention was DoubleSpeak. I thought he was really out there. Orwell was an optimist. Paul Myers, talkbiz.com Reread both of the posts of MySQL and nusphere in question and make up your mind. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: AW: password-recovery for root-user?
You can reinstall the complete system from scratch, if you are superuser to that system. Would be the easiest way to do it, I guess. I'm trying to get the root-password to be deleted or set to a new value without knowing the old password. (Forgotten...) table -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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[2]: SMP+mysql problem
Sorry, I don't know about Solaris, but I observed that my MySQL processes (Linux) are sometimes from 10 to 25 MB which makes me wonder. I think that a process should reflect the result size, for example. We have all sorts of parameters here to adjust memory usage, and normally there are restrictions to keep programs from running away. What happens if you get a result set of 100 MB? Will MySQL show in top with, say 110 MB? Sie schrieben am Mittwoch, 18. Juli 2001, 13:00:09: I don't know. I've got a server with Linux+Mysql and the output of top is different PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 822 mysql 0 0 9628 7548 5296 S 0,0 11,9 0:00 mysqld 839 mysql 0 0 9628 7548 5296 S 0,0 11,9 0:01 mysqld 840 mysql 0 0 9628 7548 5296 S 0,0 11,9 0:01 mysqld Why in the output of Top in Solaris mysqld is 801M If you need an archive conf. or something to help me, say me please. -Mensaje original- De: Werner Stuerenburg [mailto:[EMAIL PROTECTED]] Enviado el: miércoles, 18 de julio de 2001 12:46 Para: Jorge Ruiz Martinez CC: '[EMAIL PROTECTED]' Asunto: Re: SMP+mysql problem What I am stumbling about is this: PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND 22889 root 30 330 801M 11M cpu0 23.6H 26.75% mysqld Is this really true: size 801 M How can that be -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Small Problem with a function
mysql support should be built into php. I experienced this twice under Winxx. The first time I found a remedy which I don't remember. The second time I upgraded to the newest version of php. Fatal error: Call to unsupported or undefined function mysql_pconnect() in ./db_mysql.php on line 38 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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[2]: AW: password-recovery for root-user?
http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.h FYI: The link you requested was not found. Sie schrieben am Mittwoch, 18. Juli 2001, 16:17:24: mysqld --skip-grant-tables section 6.3 on this page: http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.h tml -ravi. -Original Message- From: Andy Tanner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 10:03 AM To: Werner Stuerenburg; Rischbode, Horst Cc: [EMAIL PROTECTED] Subject: RE: AW: password-recovery for root-user? Similarly - how about - take a copy of you original mysql database tables - overwrite the mysql database tables with the original installation tables - login as root (the password will be blank) - import your orignial tables back into the mysql database good luck Andy -Original Message- From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]] Sent: 18 July 2001 13:26 To: Rischbode, Horst Cc: [EMAIL PROTECTED] Subject: Re: AW: password-recovery for root-user? You can reinstall the complete system from scratch, if you are superuser to that system. Would be the easiest way to do it, I guess. I'm trying to get the root-password to be deleted or set to a new value without knowing the old password. (Forgotten...) table -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Network connection
How about using Ora_Logon to connect to an oracle db? It is the prescibed procedure. mysql_pconnect ist used to connect to mysql dbs. $db = mysql_pconnect (anothermachine:oracleport, user, passwd) or die .. I need to connect to an oracle DB - can I? Or do I have to run a ?cgi? style script / program to get there? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help with crosstable SEARCH
Well, you have to tell MySQL somehow how to connect those two tables. You may want to check the syntax for JOINS to understand what's going on. I have two tables: whenever I tried doing this select, mysql would hang indefinitely trying to resolve it or at least took t long I would rather shutdown the whole machine. SELECT m.username, m.class, u.password FROM masterlist m, user u WHERE m.class '' LIMIT 20; However, when I include u.username = m.username in the WHERE field, it immediately produces the result in 0.0x seconds. Why does it hang on the 1st case? was it because there were cases wherein a row in masterlist is not present in user list that's causing it to croak? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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' about my current database if I reinstall mysql and my linux
In my setting, it is /usr/local/mysql The data is at /usr/local/mysql/var Sie schrieben am Sonntag, 15. Juli 2001, 10:00:17: Dear my beloved e-pals, Would you like to be so kind to answer my question ? Please.. Where is located the database of my mysql database engine...? Under which directory is my database located ? And which harddisk ? I want to reinstall my linux. I have more than one harddisk... I have to make sure that the database is located on the other harddisks. Because I will reformat the harddisk whose linux OS. If I have reinstall my Linux and my MySQL, how can I use my previous database ? __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Force password
Maybe you need to restrict access through .htaccess or some other form of login-procedure. There are lots of packets out there realising user login. Sie schrieben am Montag, 16. Juli 2001, 01:26:50: Hi guys could someone tell me how I could force people to their enter password otherwise deny entry. I've looked through the mysql manual but I can't seem to find anything on this. your help is greatly appreciated. Tom -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php