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
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
"id" => $row["id"],
"uname" => $row["uname"],
"nickname"=> $row["nickname"],
"mtch" => $row[&q
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
I have the following table:
mysql> select * from link_categories;
++---+-+---+---+-+
| id | level | category_id | category | parent_id | deleted |
++---+-+---+---+-+
| 1 | 1 |1000 | So
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
> > /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
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
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 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
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
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
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
13 matches
Mail list logo