MySQL-Client Segfaults

eciated. Thank you, Werner PS: Here is the strace of the mysql-Call corleone:/usr/local/mysql/bin# strace /usr/local/mysql/bin/mysql -u root execve("/usr/local/mysql/bin/mysql", ["/usr/local/mysql/bin/mysql", "-u", "root"], [/* 15 vars */]) =

Source-Install 5.0.85 on Debian Lenny: MySQL-Client segfaults

eciated. Thank you, Werner PS: Here is the strace of the mysql-Call corleone:/usr/local/mysql/bin# strace /usr/local/mysql/bin/mysql -u root execve("/usr/local/mysql/bin/mysql", ["/usr/local/mysql/bin/mysql", "-u", "root"], [/* 15 vars */]) =

Re: mysql on tmpfs

ystem. However, even though there is plenty of free memory linux makes weird decisions from time to time, temporarily killing performance, swapping in/out to make room. Without more information it's difficult to say what's causing it. How do you check swapping activity? Werner -- MySQL

Re: group_concat display limit

ble to a higher value which is constrained by max_allowed_packet. Werner -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to extract data from the show table status?

matted table. Here is an example showing a few columns: $ mysql -u root -p -e "SHOW TABLE STATUS FROM world" | awk '{print $1, $2, $5, $6, $12}' | column -t Name Engine Rows Avg_row_length Create_time City MyISAM 4079 67 2008-01-14 Country

Re: write lock and sql_cache

TABLE foo WRITE; > > thread 2: > SELECT * FROM foo ; > I have the result of the select; that was not 'locked' :( > > the only way I found to avoid that is use the SQL_NO_CACHE (then SELECT > SQL_NO_CACHE FROM foo) > > is that correct?! there is a way to avoid to speci

MySQL-Backup incremental Backups in a Master/Slave Environment

hen in the Dump from yesterday with applied binary logs :-( Why do I miss some ROWS? What is wrong within my recovery procedure? Any hints are greatly appreciated :-) Thanks, Werner -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL-Backup incremental Backups in a Master/Slave Environment

that point you were doing the comparison and not just to the next full backup? Could it be that i need to execute a "FLUSH TABLES" before doing the mysqldumps on the Slave to force Data in the Cache to be written into the DB ? Thank you, Werner -- MySQL General Mailing List For li

Re: Need Help Migrating DB from MySQL 5.0.x to MySQL 4.0.x

] > --password=[PASSWORD] --host=[HOST] [TARGET DB] > > > > ERROR MESSAGE RETURNED > > ERROR 1193 (0) at line 23: Unknown system variable > 'character_set_client' > > mysqldump: Got errno 22 on write > try the mysqldump-option --compatible=mysql

Re: Using Flush Hosts in cron

on these > mysql servers? better solution: increases max_connect_errors if you are sure, that there ist really no network-problem e.g. --max_connect_errors=10 Werner -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Using Flush Hosts in cron

Hank schrieb: > On Tue, Sep 9, 2008 at 11:48 AM, Werner D. <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > Hank schrieb: > > I have the blocked connection problem between three of my servers, all > > behind two firewalls and on one switc

Re: LOAD - failure for a non-admin user

Reyna.Sabina schrieb: > Hi, > > I am using MySQL 5.0.45, for redhat-linux-gnu (x86_64). > > I created a new database called HYDRO (user: admin). I created a new user > called 'hydro' in the 'localhost' ([EMAIL PROTECTED]) without a password. > User 'hydro' has given all provileges except the ' Gr

Werner Meyer/L4A/EAGA/EAG/AT ist außer Haus.

Ich bin vom 15.08.2003 bis 01.09.2003 außer Haus. Ich werde Ihre Nachrichten nach meiner Rückkehr beantworten. Während dieser Zeit erreichen Sie meine Vertretung Fr. Renate Trummer unter: Tel. 0316/8056-514 Fax 0316/8056-400 E-Mail [EMAIL PROTECTED]

DB Structure

Greetings, I've got two tables that I want to join on building and room. Right now I'm doing it on Building Name, but I was wondering if it would be better to have a column for the building number in each table and do the join on that instead. Is it better to join on numbers rather than stri

Does mySQL support Pascal/C++ like Unions

Hello! Does mySQL support a thing like Pascal/C++ unions for attribute types, i.e. an attribute can be of two types at the same time. Thanks in advance. Florian

Re[2]: databases disappear...

ql\bin mysqladmin shutdown mysqld and put that on my start bar, so that is just a click. -- 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[2]: Perl Script: MySQL Slow Query Log Parser

earch/search.php?q=mysqldumpslow shows no results. How come? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224

Re[2]: question about PHP4 setup on Win98...

What exactly is the problem? There are some tutorials out there, for example http://sourceforge.net/projects/phptriad/ >>any advice on setting up PHP4 in collabaration with MySQL on Win98? >>thanx... -- Herzlich Werner

Re: Quotation Marks

tp://php.net/manual/en/function.addslashes.php -- 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: delay times, threads

ne is not done yet? I think that last question has the > beginnings of an answer in it... :-) Nothing to do with multitasking. You invoke a program which is executed line by line. php has to wait for mysql to get any return code for further processing. -

Re: permissions and table creation

> I'm very new to mysql and adminstration of database software in Have you tried phpMyAdmin to manage your db? Recommended: http://www.phpwizard.net/projects/phpMyAdmin/ -- Herzlich Werner Stuerenburg _ ISIS Verlag, T

Re[2]: DISTINCT

65 > richdick@mail 33 I would create a new table with unique index on the pair name, email. Then import all records into that table. Redundancies will be avoided by your index. Kill the old table, rename the new table. -- Herzlich Werner Stuerenburg ___

Re: host.ISM

See http://www.mysql.com/doc/R/e/Repair.html -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-9

Duplicate entry

the table. The key in turn may turn wrong when error log says mysqld process hanging, pid 28635 - killed or Aborted connection 34111 to db: 'pferdezeitung' user: 'pferdezeitung' More about the latter if someone is interested. Anybody any suggestions? I myself am clueless.

Re: Bug in Like with longblob

n BLOB and TEXT types is that sorting and comparison is performed in case-sensitive fashion for BLOB values and case-insensitive fashion for TEXT values. In other words, a TEXT is a case-insensitive BLOB. -- Herzlich Werner Stuerenburg

Re[2]: Duplicate entry

ust in case }//else it is taken, get next } } Of course, nobody can play with the tables. They are served by the program exclusively. -- Herzlich Werner Stuerenburg

Re: How do I stop this script running when the page is loaded?

echo "HTTP_POST_VARS -sessionID-$sessionID--*Test\n"; } else{ echo "no HTTP_POST_VARS -sessionID-$sessionID--*Test\n"; } echo "\n"; -- Herzlich Werner Stuerenburg _ IS

Re[2]: Duplicate entry

ly different going on here? One thing for sure: in the case I observed I can produce the desired result: error with sace, fine without. -- Herzlich Werner Stuerenburg _ IS

Re[4]: Duplicate entry

> Doing a SELECT and then an INSERT without LOCK TABLE doesn't seem very > robust to me. I agree. (Blush) > Why don't you simply try to INSERT and if it fails due > to a duplicate sid generate another session ID? Good idea. (Again: blush) Thanks. -- Herzl

Re: Must use '#' in fieldnames

> create table test ( > a35#70 char (70)); Looks like the reason is # is the remark sign like // in php Why don't you call the columns any name? Then you write INSERT INTO table (col1, col2) VALUES ('a35#70', 'id') or whatever.

Re[2]: message traffic

e to put a " [MySQL] " tag in the subject line? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049

Re: Diagrams and Flowcharts on mySQL tables

MyAdmin and am pretty happy with it as are numerous others. You get it at http://www.phpwizard.net/projects/phpMyAdmin/ -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · F

Re: tough query

ined query? -- 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 ---

CHECK TABLE

Sorry, I don't understand from the manual how to use this (running MySQL 3.22.32 on RedHat) I tried to issue CHECK TABLE tbl_name as indicated, but get mysql> CHECK TABLE sessData; ERROR 1064: parse error near 'CHECK TABLE sessData' at line 1 -- Herzlich

Re[2]: updating tables

is an entertaining article entitled MySQL Wizardry at address http://mysql.com/articles/wizard/ which shows how to work with databases and perl. Highly recommended. -- Herzlich Werner Stuerenburg

Re: MySQL error code list

136 = No more room in index file 141 = Duplicate unique key or constraint on write or update 144 = Table is crashed and last repair failed 145 = Table was marked as crashed and should be repaired -- Herzlich Werner Stuerenburg _ ISIS

Re: SELECT form element with PHP/MySQL

better classes, there are plenty by now. There even maybe one in PEAR - that would be a good project, at least. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409

Re: Create Login?

> I need to create a new login for a already created > database. I have tryed to from the command prompt of > my windows 2000 adv server box. c:\mysql\bin>>Create User mark > c:\mysql\bin this is the directory > Create User mark There is no executable named Create. You have to start mysql

Re: ERROR :Can't find file: './mysql/host.frm' (errno: 13)

The error indicated means that the table host is missing. I would reinstall the package. If it doesn't work, I would download the latest package from mysql.com and install that (it is the recommended path, anyway) - it works fine. -- Herzlich Werner Stuere

Re[2]: Reporting Tool : Linux?

, and you can do anything you like. I guess, that's the way all the experts do it. Read the entertaining and instructive article at http://www.mysql.com/articles/wizard/ -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3

Re: MySQL HELP -- Unable to start Win2k service

>I have tried to remove the service, uninstalled the mysql and reinstalled it. I >got the same result. Looks like the problem may be with a dirty shutdown and problems in tables. Try to run isamchk. Maybe this helps. -- Herzlich Werner Stuer

Re: Looking for list of ckocking charecters

double quote ("), backslash (\) and NUL (the null byte). -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407

Re: INSERT problem

sage by the existence of a cookie value which shows that you are testing. Hence other users won't see anything, but you do automatically. You can use the lib out of the box. Just provide for the connection data, password etc. Make sure you put the location of the lib outside your home dir

Re: Copy table structure to another database?

> Can I copy a table (structure only) to another database? I've searched > though my manuals without success so far. use phpMyAdmin. It is a push of a button (you have to give a name for the copy first). -- Herzlich Werner

Re: Urgent : Execute querys stored in file but from phpmyadmin

le.sql You will have to enter your password. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 ht

Re[2]: Proposition: Attach a comment to each connection

ed ? >> > > > Regards, > Alex. > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) &

Re: Got error 127 from table handler

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

Re: asking for teaching?

>http://lists.mysql.com/ (the list archive) > 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[3]: Proposition: Attach a comment to each connection

> Am I naive or is this a viable proposition? Oh, I see, you would like to connect this information with the pid, right? I wouldn't know how to do that. How do you get a pid? Is this something MySQL could provide? -- Herzlich Werner Stu

Re[5]: Proposition: Attach a comment to each connection

s session data has to be there instantly. -- 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[5]: Proposition: Attach a comment to each connection

uspect an error in a client and want to know exactly what mysqld thought the client sent to it. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 52

Re[2]: Localization with MySQL

they chose. His translators can add the translations likewise later. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(0

Re[3]: characters supported in MySQL fields

See http://www.mysql.com/doc/S/t/String_syntax.html > I thought that the way the data was stored you could not use certain > characters. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel

bug report on WinMySQLadmin 1.1

D does not work in the browser, so I created http://art-quarter.com/crashedTable.php3 which does not work with IE, but fine with Netscape, so please use that if you need it - I have several complaints about IE and workarounds, but none works f

Re: Question,

You want to search for the LIMIT keyword at http://mysql.com > Is there a way of doing a select and out of the results saying only give me > 5-10 or 10-15? -- Herzlich Werner Stuerenburg _ ISIS

Re[2]: bug report on WinMySQLadmin 1.1

oaded the table to your site instead of offering it to download from my site - but anyway, you should be able to reproduce the problem. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997

Re[4]: bug report on WinMySQLadmin 1.1

> The error : Server has gone away ... > is not WinMySQLAdmin error, but error on the server side. True, but WinMySQLAdmin should not crash with a GPF, right? Or is that an expected behaviour, even a feature? -- Herzlich Werner Stuer

Re[4]: saving in mysql

L, which is a controlled procedure. As you do already, I wonder why and what you want to write to a file. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 ˇ Fax 0(049) 5224-997 409

Re[6]: saving in mysql

The php code looks ok. What do you have in line xxx in example.php? Usually, this is the key to the error. I never saw such an error message, so I would like to see what php is supposed to do in that line. For spam filter usage: table -- Herzlich Werner Stuerenburg

Re[2]: Where to find options / my.cnf documentation?

It's so easy, you won't think of it: start mysqld with parameter -h (=help): mysqld -h shows all parameters and current settings -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049

Re[2]: Migration from Access 2000 to my SQL

ta from MS Access, MS Excel, Dbase, FoxPro, Paradox, and ODBC 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://pferde

Re: Log files

places. Check the manual or use the search box on 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://pferdezeit

LOCK while REPAIR?

when necessary. Am I correct in the assumption that I don't need a LOCK TABLE during CHECK TABLE, but otherwise during REPAIR TABLE? And if so, should I use a LOCK TABLE tbl_name WRITE? -- Herzlich Werner Stuerenburg _ ISIS Verlag,

Re: Field name LEFT and RIGHT

> I need to create a table that have field names 'LEFT' and 'RIGHT'. I have tried the >following but it doesn't work: See http://www.mysql.com/doc/R/e/Reserved_words.html Hint: use another laguage. In German, it is links and rechts for left and richt.

Re[4]: Where to find options / my.cnf documentation?

Easy as can be: for example mysqld -O max_allowed_packet=2M > Alas, it does not. It shows a couple of variable settings, but not the syntax > for tha various logging options and the like. So the question for a complete > options syntax of my.cnf remains open. -- Herzlich Werner St

Re: Updating Random Records

> 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: Regarding Use of Union in SQL statement

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

Re[2]: Updating Random Records

that those can't be picked a second time. You will definitely not set those picked back to not picked, will you? The question is: can you pick some 5000 at random and mark them as picked with one single query? That would be very handy. But sorry, I don't know. Maybe some expert

Re: phpmyadmin and mysql client conflict!! HOW?!

ok. > How can PHPmyadmin and the mysql client show different output?!! phpMyAdmin shows you the query. Check it for consistency. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407

Re: Insert text/string which is contain semicolon

> I have a problem to insert string which is contain semicolon to mySQL Database. Try escaping ";", i.e. use "\;" instead. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen

Re: LIMIT with mysql_num_rows

ly, so far, using > $result = mysql_query("$SELECT"); > $qct = mysql_num_rows($result); > Results in $qct being equal to $end, which I already knew. > Is it possible to get this figure without doing a separate q

Re: FULLTEXT indexing versus '%text%'

the app they want to receive: > 1) 'the protection' > 2) 'protecting the whales' > 3) 'please protect me' -- Herzlich Werner Stuerenburg _ ISIS Verlag,

Re: Join syntax

join with that temporary table. Question is: what kind of an application do you have that you need such a thing? > Is it possible to join two tables from different databases that are located > on different hosts? -- Herzlich Werner Stuer

Re: String Size Limit?

ending to the front of the text field each time > using: Are you able to insert content at possible length? Are you able to update the same? You should be able to track it down. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3,

Re[4]: Where to find options / my.cnf documentation?

rameters and current settings > Alas, it does not. It shows a couple of variable settings, but not the syntax > for tha various logging options and the like. So the question for a complete > options syntax of my.cnf remains open. -- Herzlich Werner Stuerenburg _

Re: Query

for it .please send me as > soon as possible. > Please let me know how could i change the server > variables. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdisse

Re: Accesses

per second avg: 32.155 -- 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 Databases with Few Tables or Few Databases with Many Tables???

gt; really relate in any way??? Since I've never quite had this perspective -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 522

Re: How Long is TEXT?

rching is something different than indexing. You may be interested in the FULLTEXT clause. See http://www.mysql.com/doc/F/u/Fulltext_Search.html and follwing for details. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683

Re: Altering tables

d what I remembered: If you want to change a column's type but not the name, CHANGE syntax still requires two column names even if they are the same. For example: mysql> ALTER TABLE t1 CHANGE b b BIGINT NOT NULL; So: you have to repeat the column name! -- Herzlich Wern

Re: MySQL for holding User opinions

(the manual) >http://lists.mysql.com/ (the list archive) > 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[2]: LIMIT with mysql_num_rows

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

nfotrmation abaut licence. Well, you may not have looked good enough. It is all there. They tell impressive numbers. Also, you find licensing info. Check out http://mysql.com - and take your time. They have more than you will ever want to know. -- Herzlich W

Re[2]: mysql and PHP problems

en "Call to undefined function mysql_pconnect".Could >> someone tell me how is it possible? This happened to me twice on my winbox. I don't remember how I fixed it the first time, but the second time I didn't come up with a solution that fast, so I decided to upgrade fr

Re: MySql and 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://li

Re: Page Refresh?

Check for something like or something... If you submit the form and call itself, php will automatically assign a variable $name. You may want to unset($name); or call another page if you are ready. -- Herzlich Werner Stuerenburg ___

Re: Search Engine Query

vi Mumbai > Maharashtra India. > Visit Aspbyte Online at : > Website:www.aspbytecreations.com > Re: > If you recieved this mail in Error please bounce the mail. > >-----

Re: Binary Data storage and Retrieval Problem

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

LOCK TABLE/automatic repair function

At 02:42, I had 59 normal error messages, later about 300/min. The mail from checkTable sessData, also from 02:42, said: Record-count is not ok; is 3184 Should be: 3183 Size of datafile is: 1302860 Should be: 579332 Found 10399 partsShould be: 3183 parts Found 4113 deleted

Re[4]: LIMIT with mysql_num_rows

> I said "without doing another query" :-) Sure you can do count(*) > beforehand... Oh, sure, sorry! Too late, I guess. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 52

Re[3]: Strange locking problem disrupting operation

ge behaivour: > Now this is a surprise! It seems I have experienced something > similar for a long time. The behavior is not exactly the same, > though. > What information would you need to tell what is going on? -- Herzlich Werner Stuerenburg ___

Re: Bounces from rtmglobal.com

I sent them a notice. Sie schrieben am Freitag, 13. Juli 2001, 13:58:40: > Am I the only one getting these? Someone really needs to fix their mail > server... For spam filter: sql -- Herzlich Werner Stuerenburg _ ISIS Verlag

Store outgoing faxes

Somebody asked for it a couple of days ago: Accidentally I found hylalog-1.0.tar.gz Store hylafax outgoing faxes in a MySQL database. By Sinisa Milivojevic, [EMAIL PROTECTED] -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D

Re[2]: Dificult question.....

lity of > those buttons, and then, if I didn't know the relative position in the > sorted table, how can I present the previous or next record of the record I > Found? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-

Re: mySQL Certification

There are courses, but there is no certification as yet, AFAIK. See http://mysql.com/training/ Sie schrieben am Samstag, 14. Juli 2001, 04:26:16: > Is there some sort of mySQL certification course? sql -- Herzlich Werner Stuerenb

Re[2]: Remote Access to SQL Server via Internet

MySQL. Also, look for a different ISP. They should make things easy, and there are plenty who know how to do it. No problem at all. If you are looking for an account in the US and need personal advice, contact Glen Pipkin at [EMAIL PROTECTED], for example. -- Herzlich Werner Stuer

Re[2]: why it is like this... {}

mment 14-Mar-2001 02:23 and following.) I use php which is very convenient. You can do eveything you dream of very easily. In particular, if anything goes wrong, you can have a look at it and understand why. But, I must admit, there is a learning curve, as is with everything. --

Re[6]: Urgent problem : recovering a table with no MYI file ?

amchk and it worked fine (with -f switch). Hope it will work in your case, 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://pferdez

Re[2]: Remote Access to SQL Server via Internet

(the list archive) > 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: Loop an INSERT from form

songsinalbum) { > $query = "INSERT INTO songs VALUES ('$id', > '$songname','$rating','$video', '$album_id', '$movie')"; >$result = mysql_db_query("movies", $query); > }; -- Herzlich Werner Stuerenb

  1   2   3   >