help with optimal configuration for blobs

table and two fields. id integer db_data longblob Normally the standard my.cnf coming with etch is good for me - but now I think I need to tune my configuration. Could someone advice me? Thanx. -- Jochen Kaechelin gissmoh.de, figgfrosch.de, ror-ror.de -- MySQL General

Re: PHP mysql_connect

Am Freitag, 23. Juni 2006 16:27 schrieb Chris Sansom: At 15:47 +0200 23/6/06, Jørn Dahl-Stamnes wrote: Yes, I forgot to say that I was using PHP... Oh, I think the clue was in the subject line. :-) ever tried localhost as hostname? -- Jochen Kaechelin, fvgi242ss, wlanhacking.de http

is this safe against sql-injection?

= $row[uname], nickname= $row[nickname], mtch= $row[mtch] ); } Is this safe?? -- Jochen Kaechelin, fvgi242ss, wlanhacking.de http

browsing in search-results

I make a fulltext-search and store the results in a temporary table so the user can browser the temporary table (5 results per page...). I think this is of better performance instead of setting LIMIT $start,$elements. correct? what would happen if several visitors of the website make a search:

display a hierarchic tree

I have the following table: mysql select * from link_categories; ++---+-+---+---+-+ | id | level | category_id | category | parent_id | deleted | ++---+-+---+---+-+ | 1 | 1 |1000 |

Problem with INTO OUTFILE

Can somebody tell me what's wrong with this query: $sql=SELECT * INTO OUTFILE 'infoanforderung/$nameliste' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM net_contact WHERE nachname='Erbel'; I get no results! Without INTO OUTFILE everything works fine! -- Jochen Kaechelin -- MySQL

Problems with 4.0.18 and mysqldump

I use the following Script to backup a remote MySQL-Server. DATUM=`date +%Y_%m_%d__%H_%M` BACKUPDIR=/home/jochen/SICHERUNG/MySQL_Dumps/debby/$DATUM echo echo Erzeuge Sicherungvereichnis $BACKUPDIR... echo mkdir -p $BACKUPDIR for DB in db1 db2 do echo echo Erzeuge

Re: Problems with 4.0.18 and mysqldump

/usr/bin/mysqldump: Got error: 2003: Can't connect to MySQL server on '212.87.142.236' (111) when trying to connect Permissions are ok and I can modify the complete db with my php scripts. where's the error? Check - that MySQL server is running - that you use correct TCP/IP

Updating SuSE 7.3

Can I use the RedHat-rpms on mysql.com to update a SuSE 7.3 prof or do I need to compile it from source with some parameters? I run 3.23.44 max and I want to update to 3.23.48 max -- Jochen - Before posting, please check:

What License do I need

What licence do I need when a want to install a MySQL-Server in a intranet on a Linux-Box where 4 Win-Clients use it by running a PHP Groupware Application? -- Jochen - Before posting, please check:

Compare remote local database

Is there a tool - a php script would be prefered - to compare a local and a remote database for synchronisation? Our aim is to have to identical databases all the time! -- Jochen - Before posting, please check:

information about ADODB for PHP4

is there a source for further information connecting to databases with ADODB for PHP4? I only know http://php.weblogs.com/ADODB -- WA-P : Jochen Kaechelin Programmierung - Beratung - Hosting Stuttgarter Strasse 3, D-73033 Göppingen Tel. 07161 - 92 95 94, Fax 92 95 98

Databases and ADODB

Anyone made good experiences with the ADODB Library for PHP4? I would like to use it for further database programming! And suggestions? -- WA-P : Jochen Kaechelin Programmierung - Beratung - Hosting Stuttgarter Strasse 3, D-73033 Göppingen Tel. 07161 - 92 95 94, Fax 92 95 98