re: RE: MySQL Help Needed Please

2003-01-06 Thread Egor Egorov
On Sunday 05 January 2003 09:08, Anton Zavrin wrote: > Well, I read, played around and updated it (I guess) > Now, when I try to start mysql with this command (same as before), it > gives me that: > # /usr/local/bin/safe_mysqld --user=mysql & > [1] 71491 > # Starting mysqld daemon with databases f

Re: MySQL Help Needed Please

2003-01-05 Thread Stefan Hinz, iConnect \(Berlin\)
<[EMAIL PROTECTED]> To: "'Stefan Hinz, iConnect (Berlin)'" <[EMAIL PROTECTED]>; "'Thomas Spahni'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, January 05, 2003 8:08 AM Subject: RE: MySQL Help Needed Please Well, I read,

RE: MySQL Help Needed Please

2003-01-04 Thread Anton Zavrin
Saturday, January 04, 2003 2:14 PM To: Anton Zavrin; 'Thomas Spahni' Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, >ps -ef | grep mysqld >got nothing Because the MySQL SERVER isn't running! >Though I can do: ># mysql -u root -p With this command,

Re: MySQL Help Needed Please

2003-01-04 Thread Stefan Hinz, iConnect \(Berlin\)
t (Berlin)'" <[EMAIL PROTECTED]>; "'Thomas Spahni'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, January 04, 2003 9:59 PM Subject: RE: MySQL Help Needed Please Did: ps -ef | grep mysqld got nothing Though I can do: # mysql -u root -p E

RE: MySQL Help Needed Please

2003-01-04 Thread Anton Zavrin
Connect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 04, 2003 8:01 AM To: Anton Zavrin; 'Thomas Spahni' Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, first thing, try: ps [whatever options] | grep mysqld The daemon (database server) is called my

Re: MySQL Help Needed Please

2003-01-04 Thread Stefan Hinz, iConnect \(Berlin\)
70948-0 Fax: +49 30 7970948-3 - Original Message - From: "Anton Zavrin" <[EMAIL PROTECTED]> To: "'Thomas Spahni'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, January 04, 2003 9:01 AM Subject: RE: MySQL Help Needed Please > I

RE: MySQL Help Needed Please

2003-01-04 Thread Anton Zavrin
ailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 7:01 AM To: Anton Zavrin Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, check the .err and .log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez

Re: MySQL Help Needed Please

2003-01-03 Thread Thomas Spahni
Anton, check the .err and .log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahn

re: MySQL Help - Initial Configuration

2002-12-14 Thread Egor Egorov
On Friday 13 December 2002 22:19, Benjamin Fisher wrote: > I'm fairly new to MySQL, and RDBMS's in general, but not to system > administration nor linux. I'm running Gentoo, and I can't seem to get > mySQL to work. [skip] > My guess, it can't find the pid to stop it with. > > And the file /var/r

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Ed Carp
ED]> To: "'Michael T. Babcock'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, September 06, 2002 10:00 AM Subject: RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example > > Michael T. Babcock wrote: > > >May I rephra

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Gelu Gogancea
;; "'Michael T. Babcock'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, September 06, 2002 6:54 PM Subject: RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example > Sorry, my bad. > > What is this PAGER and where do I run your test scr

RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Keith Burke [Experience IT]
D] Subject: Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example ... > I'll also have to read up on those UDF's. Sounds interesting. ...or PAGER. Try to do a test: \P mail root@localhost; select User,Host,Password from mysql.u

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Gelu Gogancea
-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Keith Burke [Experience IT]" <[EMAIL PROTECTED]> To: "'Michael T. Babcock'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Frid

RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Keith Burke [Experience IT]
Michael T. Babcock wrote: >May I rephrase your comment? > >"I need to send E-mails to people from MySQL data". > >I recommend just doing a SELECT on the data in question and generating >the E-mails from PERL or PHP or whatever other language you are using. No you may not ;-) *joke* It needs

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Gelu Gogancea
t; <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "MySQL Mailing List" <[EMAIL PROTECTED]> Sent: Friday, September 06, 2002 5:10 PM Subject: Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example > Hi, > > I think youd should make an UDF which t

RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Keith Burke [Experience IT]
* * Ireland * * ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of walt Sent: 06 September 2002 15:05 To: [EMAIL PROTECTED] Cc: MySQL Mailing List Subject: Re: [MySQL] HELP: Can MySQL run external progr

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Ralf Narozny
Hello! walt wrote: >"Keith Burke [Experience IT]" wrote: > > > >>Greetings, >> >>I'm new to this list but not to MySQL. I've been using MySQL on >>Linux with PHP for the past year or two. I've always managed to sort out >>any problems by looking at the documentation on the website but

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail forexample

2002-09-06 Thread Michael T. Babcock
Keith Burke [Experience IT] wrote: > I need to be able to send Emails to people from MySQL command >line. > > May I rephrase your comment? "I need to send E-mails to people from MySQL data". I recommend just doing a SELECT on the data in question and generating the E-mails from PERL or

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Gelu Gogancea
Hi, I think youd should make an UDF which that execute in shell what you need. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Mess

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Gerald Clark
Write it in perl. Perl has modules for MySQl and Email. Keith Burke [Experience IT] wrote: >Greetings, > > I'm new to this list but not to MySQL. I've been using MySQL on >Linux with PHP for the past year or two. I've always managed to sort out >any problems by looking at the documentatio

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread walt
"Keith Burke [Experience IT]" wrote: > Greetings, > > I'm new to this list but not to MySQL. I've been using MySQL on > Linux with PHP for the past year or two. I've always managed to sort out > any problems by looking at the documentation on the website but my > current problem has me pe

RE: mysql help !! urgent

2002-06-22 Thread Cal Evans
mysqld --skip-grant-tables -Original Message- From: Jesse Angell [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 3:38 AM To: [EMAIL PROTECTED] Subject: mysql help !! urgent Hello, In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do anything as phpmyadmin w

RE: MYSQL HELP

2002-02-20 Thread Daniel Rosher
11:18 a.m. > To: David McInnis; 'Shade, Richard'; [EMAIL PROTECTED] > Subject: Re: MYSQL HELP > > > David, > > > How would you use a temporary table? Is that the most efficient way? > > Use SELECT INTO temp_tbl to replace the sub-select clause. > Re

Re: MYSQL HELP

2002-02-20 Thread DL Neil
David, > How would you use a temporary table? Is that the most efficient way? Use SELECT INTO temp_tbl to replace the sub-select clause. Rewrite the existing SELECT into a join with the temp_tbl. Is there another way? =dn > Richard, > > > Does anyone know what is wrong with this syntax...

RE: MYSQL HELP

2002-02-20 Thread David McInnis
How would you use a temporary table? Is that the most efficient way? David -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 11:03 AM To: Shade, Richard; [EMAIL PROTECTED] Subject: Re: MYSQL HELP Richard, > Does anyone know what is wr

Re: MYSQL HELP

2002-02-20 Thread DL Neil
Richard, > Does anyone know what is wrong with this syntax... > > Select H.FinishCode, L.RowID > From CallHistory As H, BD2.CallList As L > Where (H.CallTime in(Select MAX(CallTime) From CallHistory Where H.RowID = > L.RowID) > AND H.RowID = L.RowID); Sub-selects not (yet) permitted by MySQL (

RE: MYSQL HELP

2002-02-20 Thread Shade, Richard
Richard Shade Systems Administrator (936)559-2280 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 11:39 AM To: Shade, Richard Subject: Re: MYSQL HELP Your message cannot be posted because it appears to be either spam or

Re: MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Pete Kuczynski
Only time I had this error on a NT4 server was when I attempted to get logging to work and I made a mistake editing the mycnf and myini files. When I cycled the mysql service, it would no come back up. Removing the offending edit allowed it to start. Pete Michael Tam wrote: > > Hi all, > >

Re: MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Michael Tam
Hi all, Thank you for giving me direction to where I should look into the problem. I finally fix the problem which is coming from a mistake that I made in my.ini. Regards, Michael

Re: MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Michael Tam
AIL PROTECTED]> To: "Michael Tam" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]> Sent: Tuesday, July 03, 2001 9:10 AM Subject: Re: MySQL HELP -- Unable to start Win2k service > >I have tried to remove the service, uninstalled the mysql and reinstall

Re: MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Werner Stuerenburg
>I have tried to remove the service, uninstalled the mysql and reinstalled it. I >got the same result. Looks like the problem may be with a dirty shutdown and problems in tables. Try to run isamchk. Maybe this helps. -- Herzlich Werner Stuerenburg ___

Re: MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Miguel Angel Solórzano
At 03:45 03/07/2001 -0700, Michael Tam wrote: Hi, Take a look on \mysql\data\mysql.err file and see if exists a message error like that server doesn't find a grant tables. Otherwise, try to run the server standalone to see in the screen the error message: yourservername --standalone Fix the pos

Re: MySQL Help

2001-05-08 Thread Joseph Bueno
Salvador Casquero Algarra wrote: > > Hi, > > I am having a terrible problem with MySQL and I am desperated as > nobody seems to find the source. I have a Web site ( www.genteirc.com ) > whith MySQL database access. The problem is that those Mysql processes are > growing continuou