Re: mysql becomes slow

2001-08-18 Thread Werner Stuerenburg
ion of a second. And if it is not, something weird is going on and I would like to see this problem really understood and solved. It may turn out to be not a problem of mysql proper, but who knows at the time being? -- Herzlich Werner Stuerenburg __

Re: Backups from Server to localhost

2001-08-18 Thread Werner Stuerenburg
tp%3A%2F%2Fwww.koehntopp.de%2Fkris%2Fartikel%2Fwebtune%2F&Sequence=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

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

2001-08-18 Thread Werner Stuerenburg
escribed 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

Re: naming feilds

2001-08-17 Thread Werner Stuerenburg
t; table? I would say: not without some magic on your behalf. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pfer

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

2001-08-17 Thread Werner Stuerenburg
(the manual) >http://lists.mysql.com/ (the list archive) > 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: Problems with the unique properties...

2001-08-17 Thread Werner Stuerenburg
/lists.mysql.com/ (the list archive) > 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: Error altering column name

2001-08-17 Thread Werner Stuerenburg
MAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683

Re: SQL underscore character question

2001-08-16 Thread Werner Stuerenburg
To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, T

Re: synchronisation (replication)

2001-08-16 Thread Werner Stuerenburg
rt/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. --

Re: imigration of db from server 2 localhost as backups

2001-08-15 Thread Werner Stuerenburg
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) 52

Re: Replication

2001-08-14 Thread Werner Stuerenburg
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. -- Herz

Re: 2008 : MySQL client run out of memory

2001-08-09 Thread Werner Stuerenburg
ause ? >> > I tried a debugger called Body but It is so slow that I could die before. >> > >> > Thank you >> > >> > Patrice >> > >> > ----- >&

Re: 2008 : MySQL client run out of memory

2001-08-09 Thread Werner Stuerenburg
-- > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTE

Re: error codes ??

2001-08-08 Thread Werner Stuerenburg
> 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-Alverdis

Re: mysql-php mailing list

2001-08-08 Thread Werner Stuerenburg
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-Alverd

Re: Logging connections

2001-08-07 Thread Werner Stuerenburg
le 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 · Fa

Re: Truncated User List

2001-08-07 Thread Werner Stuerenburg
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 Ver

Re: "Got an error reading communication packets"

2001-08-07 Thread Werner Stuerenburg
rouble 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 r

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

2001-08-06 Thread Werner Stuerenburg
se check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscri

reading error

2001-08-06 Thread Werner Stuerenburg
ssive 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-99

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

2001-08-03 Thread Werner Stuerenburg
f 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 Wern

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

2001-08-03 Thread Werner Stuerenburg
sv 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. --

Re: Query Acting Weird

2001-08-03 Thread Werner Stuerenburg
ysql 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,

Re: Help selecting something that occurred in past 5 minutes

2001-08-03 Thread Werner Stuerenburg
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 >

Re: Databases on Removable Media?

2001-08-03 Thread Werner Stuerenburg
n 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://pferdezeit

Re: Crazy Threads

2001-08-03 Thread Werner Stuerenburg
he 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-Alverdi

Re: How can try to recover the data from mysql

2001-08-03 Thread Werner Stuerenburg
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 Stuer

No Database Selected /weird behaviour

2001-08-03 Thread Werner Stuerenburg
he 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 S

Re: Searching in a mysql table

2001-08-03 Thread Werner Stuerenburg
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 Barntr

Re: generate database script from existing table?

2001-08-03 Thread Werner Stuerenburg
; 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 _

Re: importing text files using phpmyadmin

2001-08-03 Thread Werner Stuerenburg
nd 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://pferdezeit

(Got an error reading communication packets)

2001-08-01 Thread Werner Stuerenburg
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

Re: hostname.err

2001-08-01 Thread Werner Stuerenburg
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. >>

hostname.err

2001-08-01 Thread Werner Stuerenburg
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. -- Herzl

Re: account?

2001-08-01 Thread Werner Stuerenburg
be, 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

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

2001-07-31 Thread Werner Stuerenburg
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==

Re: Writing 100+ fields with Perl DBI

2001-07-31 Thread Werner Stuerenburg
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 sugges

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

2001-07-31 Thread Werner Stuerenburg
ge - 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 qmai

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

2001-07-31 Thread Werner Stuerenburg
e- >> 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

Re: Database Security

2001-07-31 Thread Werner Stuerenburg
o 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) 52

msg from MAILER-DAEMON@web.mysql.com

2001-07-31 Thread Werner Stuerenburg
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 V

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

2001-07-31 Thread Werner Stuerenburg
an 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 --

Re: howto insert an image as blob?

2001-07-30 Thread Werner Stuerenburg
>http://lists.mysql.com/ (the list archive) > 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: Parsing text file into mysql database.

2001-07-30 Thread Werner Stuerenburg
ving 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]>

addition for manual section 24.5.1

2001-07-30 Thread Werner Stuerenburg
"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

Re: reindexing tables

2001-07-29 Thread Werner Stuerenburg
.mysql.com/ (the list archive) > 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: Parsing text file into mysql database.

2001-07-29 Thread Werner Stuerenburg
iviledge 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

Re: Parsing text file into mysql database.

2001-07-29 Thread Werner Stuerenburg
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: We

top reports Status D

2001-07-27 Thread Werner Stuerenburg
che 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-9

Re: not null

2001-07-27 Thread Werner Stuerenburg
manual.php (the manual) >http://lists.mysql.com/ (the list archive) > 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 St

Re: Unable to use shortcut keys

2001-07-27 Thread Werner Stuerenburg
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-Alverdi

Re: timestamp problem

2001-07-27 Thread Werner Stuerenburg
> Everything must point to him. > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive)

Re: How to ROUND numbers

2001-07-27 Thread Werner Stuerenburg
;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) > T

Re: Date Format in MySQL

2001-07-27 Thread Werner Stuerenburg
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

Re: FW: encrypt

2001-07-27 Thread Werner Stuerenburg
ry: 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: access dbs to mysql dbs

2001-07-27 Thread Werner Stuerenburg
he list archive) > 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

Delayed_insert

2001-07-23 Thread Werner Stuerenburg
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 Wer

Re: downloaded file problem

2001-07-23 Thread Werner Stuerenburg
ld 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-Alv

Re: what version to download?

2001-07-23 Thread Werner Stuerenburg
bout 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: Many students - each with own DB - would like to restrict size of each DB

2001-07-23 Thread Werner Stuerenburg
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: auto_increment, is this a bug?? Where to report it?

2001-07-23 Thread Werner Stuerenburg
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 4

Re: how to move a database to a new server?

2001-07-23 Thread Werner Stuerenburg
'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 --

Re: Dumping a database

2001-07-23 Thread Werner Stuerenburg
Message ----- > From: "Werner Stuerenburg" <[EMAIL PROTECTED]> > To: "Philippe Pham" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Monday, July 23, 2001 11:51 AM > Subject: Re: Dumping a database > use mysqldump - look for it in manu

Re: Dumping a database

2001-07-23 Thread Werner Stuerenburg
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-Alverdis

Re: how do I find out where the files are stored ?

2001-07-23 Thread Werner Stuerenburg
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 __

Re: what version to download?

2001-07-22 Thread Werner Stuerenburg
> 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 St

Re: syntax problem

2001-07-22 Thread Werner Stuerenburg
his 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

Re: Another Newbie Question

2001-07-21 Thread Werner Stuerenburg
d 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

Re: Another Newbie Question

2001-07-20 Thread Werner Stuerenburg
gt; 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''

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

2001-07-20 Thread Werner Stuerenburg
t 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 40

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

2001-07-20 Thread Werner Stuerenburg
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 colu

Re: Select Statement with AS Keyword

2001-07-20 Thread Werner Stuerenburg
AIL PROTECTED]> > To unsubscribe, e-mail > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-

Re: Randomize column order

2001-07-20 Thread Werner Stuerenburg
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

Re: Is last_insert_id reliable?

2001-07-20 Thread Werner Stuerenburg
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 questio

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

2001-07-20 Thread Werner Stuerenburg
ut 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) 52

Re: Left Join very sloooowwww..

2001-07-20 Thread Werner Stuerenburg
h 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://pferdez

Re: Help!

2001-07-20 Thread Werner Stuerenburg
> 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-

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

2001-07-20 Thread Werner Stuerenburg
ELECT 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

Re: mysql.org

2001-07-20 Thread Werner Stuerenburg
(the list archive) > 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 S

Re: Table keeps corrupting

2001-07-20 Thread Werner Stuerenburg
> Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscr

Re: SMP+mysql problem

2001-07-20 Thread Werner Stuerenburg
hing 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

Re: REPLACE single value

2001-07-20 Thread Werner Stuerenburg
3 = '$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

Re: concept of users connecting from different host

2001-07-20 Thread Werner Stuerenburg
e 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(

Re: Left Join very sloooowwww..

2001-07-20 Thread Werner Stuerenburg
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 We

Re: Put together (Merge) two tables in one

2001-07-20 Thread Werner Stuerenburg
sert 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 h

Re: mysql manager

2001-07-20 Thread Werner Stuerenburg
i 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 St

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

2001-07-19 Thread Werner Stuerenburg
ate,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://pfe

Re: Left Join very sloooowwww..

2001-07-19 Thread Werner Stuerenburg
> Before posting, please check: > http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[

Re: Upgrade MySQL

2001-07-19 Thread Werner Stuerenburg
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 Stuer

Re: Please help - does changing the port the web server listens on affect mysql?

2001-07-19 Thread Werner Stuerenburg
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) 5

Re: Questions about extremely large database support

2001-07-19 Thread Werner Stuerenburg
;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 ___

Re: Backup of databases.

2001-07-19 Thread Werner Stuerenburg
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 --

Re: blob question

2001-07-19 Thread Werner Stuerenburg
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.bitbyb

Re: UPDATEing values in SET columns

2001-07-19 Thread Werner Stuerenburg
.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscrib

Re: blob question

2001-07-19 Thread Werner Stuerenburg
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? > Que

Re: Network connection

2001-07-18 Thread Werner Stuerenburg
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 · Fa

Re: Buffering SELECT results without using temporary tables; "Locked tables while 'Sending data'" revisited

2001-07-18 Thread Werner Stuerenburg
ul to add links at both places, maybe with a suggestion to look there, too, before asking? -- 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[2]: AW: password-recovery for root-user?

2001-07-18 Thread Werner Stuerenburg
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-recove

Re: Small Problem with a function

2001-07-18 Thread Werner Stuerenburg
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://pferd

Re[2]: SMP+mysql problem

2001-07-18 Thread Werner Stuerenburg
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 > C

  1   2   >