Re: MySQL Spawns Many Processes and Uses 100% CPU! PART #1

/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

Re: Backups from Server to localhost

, 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

Re: Error altering column name

check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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

Re: Problems with the unique properties...

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

Re: Formatting Price Field in my Table so 0.20 does not become 0.2....

archive) 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

Re: synchronisation (replication)

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

Re: imigration of db from server 2 localhost as backups

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

Re: Replication

(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

Re: error codes ??

, 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

Re: 2008 : MySQL client run out of memory

://lists.mysql.com/ (the list archive) 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

Re: 2008 : MySQL client run out of memory

[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

Re: mysql-php mailing list

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

Re: Got an error reading communication packets

/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

Re: Truncated User List

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

Re: Logging connections

/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

reading error

. 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

Re: Index length too long, but no index specified!

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

Re: '/tmp/mysql.sock' (111)

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

Re: importing text files using phpmyadmin

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

Re: generate database script from existing table?

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

Re: Searching in a mysql table

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

No Database Selected /weird behaviour

. 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

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

Re: Crazy Threads

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

Re: Databases on Removable Media?

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

Re: Help selecting something that occurred in past 5 minutes

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

Re: Query Acting Weird

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

Re: How to add an excel file directly to MySQL database using PHP?

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

Re: account?

://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

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

(Got an error reading communication packets)

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

Re: How to know which row was affected with a querry ???

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

msg from MAILER-DAEMON@web.mysql.com

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

Re: Database Security

://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

Re: msg from MAILER-DAEMON@web.mysql.com

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

Fwd: Re: msg from MAILER-DAEMON@web.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

Re: Writing 100+ fields with Perl DBI

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

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

Re: Parsing text file into mysql database.

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

Re: reindexing tables

] 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

addition for manual section 24.5.1

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

Re: Parsing text file into mysql database.

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

Re: howto insert an image as blob?

archive) 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

Re: access dbs to mysql dbs

, 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

Re: FW: encrypt

://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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

Re: Date Format in MySQL

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

Re: How to ROUND numbers

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

Re: timestamp problem

(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

Re: Unable to use shortcut keys

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

Re: not null

archive) 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

top reports Status D

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

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

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

Re: how to move a database to a new 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

Re: auto_increment, is this a bug?? Where to report it?

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

Re: Many students - each with own DB - would like to restrict size of each DB

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

Re: what version to download?

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

Re: downloaded file problem

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

Delayed_insert

, 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

Re: syntax problem

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

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

Re: Another Newbie Question

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

Re: mysql manager

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

Re: Put together (Merge) two tables in one

. 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

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

Re: concept of users connecting from different host

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

Re: REPLACE single value

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

Re: SMP+mysql problem

. 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

Re: Table keeps corrupting

archive) 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

Re: mysql.org

://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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

Re: Anyone knows what's wrong with this INSERT sentence?

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

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

Re: Left Join very sloooowwww..

. 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

Re: auto_increment, is this a bug?? Where to report it?

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

Re: Is last_insert_id reliable?

? 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

Re: Randomize column order

/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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

Re: Select Statement with AS Keyword

? 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

Re: Fw: tricky RAND() function...

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

Re: Fw: tricky RAND() function...

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

Re: Another Newbie Question

' - ; 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

Re: blob question

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

Re: UPDATEing values in SET columns

/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

Re: blob question

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

Re: Backup of databases.

. -- 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

Re: Questions about extremely large database support

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

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

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

Re: Left Join very sloooowwww..

://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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

Re: Sysdate????Date????Please help

. -- 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

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

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

Re[2]: mysql.org

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

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

Re[2]: SMP+mysql problem

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

Re: Small Problem with a function

-- 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

Re[2]: AW: password-recovery for root-user?

/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

Re: Network connection

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

Re: help with crosstable SEARCH

? 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

Re: what' about my current database if I reinstall mysql and my linux

://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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

Re: Force password

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

  1   2   >