help with optimal configuration for blobs

2007-07-26 Thread jochen kaechelin
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

2006-06-23 Thread Jochen Kaechelin
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, fvgi2

is this safe against sql-injection?

2006-03-05 Thread Jochen Kaechelin
"id" => $row["id"], "uname" => $row["uname"], "nickname"=> $row["nickname"], "mtch" => $row[&q

browsing in search-results

2006-02-26 Thread Jochen Kaechelin
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

2006-01-29 Thread Jochen Kaechelin
I have the following table: mysql> select * from link_categories; ++---+-+---+---+-+ | id | level | category_id | category | parent_id | deleted | ++---+-+---+---+-+ | 1 | 1 |1000 | So

Problem with INTO OUTFILE

2004-05-17 Thread Jochen Kaechelin
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 &qu

Re: Problems with 4.0.18 and mysqldump

2004-03-17 Thread Jochen Kaechelin
> > /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 u

Problems with 4.0.18 and mysqldump

2004-03-17 Thread Jochen Kaechelin
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 "E

Updating SuSE 7.3

2002-02-13 Thread Jochen Kaechelin
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

2002-02-12 Thread Jochen Kaechelin
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: http://www.mysql.com/man

Compare remote & local database

2002-01-10 Thread Jochen Kaechelin
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: http://www.m

information about ADODB for PHP4

2001-08-20 Thread Jochen Kaechelin
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

2001-08-18 Thread Jochen Kaechelin
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