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, fvgi242ss, wlanhacking.de
http
= $row[uname],
nickname= $row[nickname],
mtch= $row[mtch]
);
}
Is this safe??
--
Jochen Kaechelin, fvgi242ss, wlanhacking.de
http
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 |
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
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
/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
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:
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:
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