Re: installation de mysql

2004-03-24 Thread Bernd Tannenbaum
Hello, Am Mittwoch, 24. März 2004 11:01 schrieb sanaâ Aitouchen: > j'ai le red hat 9 et j'ai télécharger > mysql-3.23.58-pc-linux-i686.tar.gz j'ai crée le repertoir > /usr/local/src et j'ai fais > gunzip mysql-3.23.58-pc-linux-i686.tar.gz > tar xvf mysql-3.23.58-pc-linux-i686.tar.gz > cd mysql-3.2

Re: php script for new database and user

2004-03-18 Thread Bernd Tannenbaum
Hi, > -Original Message- > From: Elly Wisata [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 18, 2004 1:55 AM > To: [EMAIL PROTECTED] > Cc: 'BGLefty' > Subject: RE: php script for new database and user > > I don't think php script can create database. But maybe I am wrong. > If I am, ple

Re: Enabling Mysql in php

2004-02-16 Thread Bernd Tannenbaum
Hullos, Am Montag, 16. Februar 2004 12:08 schrieb michele digioia: > Hi. > I haven't mysql enabled in php. How may I do it? I have php 4.0.4, > mysql 3.23.36, both installed on linux RH 7.3. If u compiled php urself u may wanna do it again with: --with-mysql=/PATH to mysql If its a finished pack

Re: Just simple question...

2004-02-07 Thread Bernd Tannenbaum
Hi, Am Freitag, 6. Februar 2004 16:03 schrieb Dusan Spisak: > Hello everybody! > > I need to create some simple database. I've started to build it up in > Microsoft Access. MS Access was really great for me, it was very easy and > user friendly, intuitive. Without any manual I've managed to create

Re: Bash script to MySql

2004-02-04 Thread Bernd Tannenbaum
Hi, Am Donnerstag, 5. Februar 2004 03:43 schrieb Scott Haneda: > on 02/04/2004 02:23 AM, Bernd Tannenbaum at [EMAIL PROTECTED] > > wrote: > > 2 possible ways to go: > > > > Feed a Textfile with your statement in the db: > > PATH/mysql db < /sql_scripts/sql_st

Re: Bash script to MySql

2004-02-04 Thread Bernd Tannenbaum
Hi, Am Mittwoch, 4. Februar 2004 07:19 schrieb Hassan Schroeder: Scott Haneda wrote: > I need to to the following > Select serial from serials; > > Problem is I need to run this from a script which cron will call once a > day, how do you pass a select statement to mysql with user and pass so it >

Re: MySQL viewer

2004-02-04 Thread Bernd Tannenbaum
Hi, Am Dienstag, 3. Februar 2004 22:50 schrieb Alex croes: > I'm currently using MyCC as a tool to "view" and maintain a > MySQL-database of mine. > I find it quit a good tool, but which tool are you guys using. I have > heard about MySQLfront > and Navicat. Are this also good tools to maintain th

TRIM to replace?

2004-01-26 Thread Bernd Tannenbaum
Hi all, Me needs to change the format of some telephone numbers which are placed in a mysql database. Current format: 49xyz Wanted format: 0xyz Now i know how to remove the leading 49: UPDATE table SET field=(TRIM(LEADING '49' FROM field)); But how can i replace the "49" with a "0"? Or maybe i

Re: keep leading 000 -solved

2003-11-06 Thread Bernd Tannenbaum
Am Donnerstag, 6. November 2003 13:14 schrieb Bernd Tannenbaum: > Hi all, > only small problem here (me hopes). > I update a field with a value that is stored in a bash-variable. > The value in the variable ($dsvar2) is like "12.". > So what i want is to keep th

keep leading 000 ?

2003-11-06 Thread Bernd Tannenbaum
Hi all, only small problem here (me hopes). I update a field with a value that is stored in a bash-variable. The value in the variable ($dsvar2) is like "12.". So what i want is to keep the leading and trailing "0" in the value. in the bash-scipt: /mysql -e "UPDATE table SET field=$dsv

Re: export to textfile -solved :)

2003-10-21 Thread Bernd Tannenbaum
Hi and thx to all who answered :) Okay, finally found my mistake with ur help. One can add the needed options within the "select" statement, not within the "mysql -e" statement as i tried. Working solution is now: ./mysql --skip-column-names -e "select ek_satzart,[...] into outfile 'File' FIELD

Re: export to textfile

2003-10-21 Thread Bernd Tannenbaum
Helloand ty for the fast answers, but Am Dienstag, 21. Oktober 2003 13:10 schrieben Sie: > Hi Bernd > If you are just interested in dumping the data in CSV (or whatever) format > you can do it like so: > SELECT * > INTO OUTFILE 'arb_file.csv' FIELDS TERMINATED BY ',' LINE TERMINATED BY > '

export to textfile

2003-10-21 Thread Bernd Tannenbaum
Hello all, Have only a small problem with my mysql and hope that i can get a lil hint from ya how to go on. Currently i`m importing Log-files in the mysql-database with a cronjob (bashscript in Linux). After some processing in the db itself i try now to export the results into a textfile. But i

Re: Replication

2003-07-29 Thread Bernd Tannenbaum
Hello, Am Dienstag, 29. Juli 2003 11:15 schrieb ΝΙΚΟΣ ΓΑΤΣΗΣ: > Hello. > I have MySQL 3.23.41 on a RH-7.2 Linux used as local server. > I'm trying to replicate the databases from server (192.168.0.1) to another > linux PC (192.168.0.3). > Following the manual, i grant to the master a user with fil

Re: my.cnf not existing - Thx :)

2003-07-28 Thread Bernd Tannenbaum
Thx for the answer, found it myself too: Am Montag, 28. Juli 2003 14:22 schrieben Sie: > Build the file and put it in your C:\>.. You are not given a my.cnf > file if you build from source, if you had used the binary file, it came > with about 4 of the files and you just pick one and modify it an

my.cnf not existing?

2003-07-28 Thread Bernd Tannenbaum
Hello List, this is my first posting here so plz do not flame me too much if my question marks me as a total noob. My problem is, i play around a bit with mysql (4.0.13) and want to test the Replication. The Documentation at http://www.mysql.com says i have to do the following: Stop databases