Bulk mailing

2001-09-01 Thread legal
Hi list members, I want to mail a newsletter to about 500+ email addresses. Can anyone give php script that mails to all email addresses picking from a table in Mysql and mailing newsletter while addressing individually. Thanks in advance, Ajay K. Ratra [EMAIL PROTECTED]

Re: mysqld or kernel bug?

2001-09-01 Thread Robert La Ferla
I forgot to include the info on the zombied mysql process. mysql10389 0.0 0.0 00 pts/0Z12:51 0:00 [mysqld ] Robert - Before posting, please check: http://www.mysql.com/manual.php (the manual) h

mysqld or kernel bug?

2001-09-01 Thread Robert La Ferla
I saw this message in the log. Is this a mysql or kernel? I also saw one of the mysqld processes (threads?) in the process list as a Zombie. I think it happened at the same time of this log but I don't remember so it's not definite but likely. Robert Versions == Linux version 2.4.3-12 ([E

Re: subject header

2001-09-01 Thread s . keeling
On Sat, Sep 01, 2001 at 09:10:01PM -0500, Cal Evans wrote: > Wow, has it been a month already? > > Please check the archives before posting. There are several discussions on > this exact topic. Specifically, "List-ID: " or: :0: * ^[EMAIL PROTECTED] IN.mysql for procmail. -- Any technol

RE: subject header

2001-09-01 Thread Don Read
On 02-Sep-2001 Cal Evans wrote: > Wow, has it been a month already? > No, it must be September. -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it.

Re: Strange Problem !

2001-09-01 Thread s . keeling
On Sun, Sep 02, 2001 at 02:01:36AM +0200, Daniel Urstöger wrote: > Hiya ! > > I am not new with mysql, but I guess my experience is not enough for that > kind of problem ;) > mysql runs fine now the last 3 weeks, but now I am running into problems. > I want to restart mysql with the /etc/rc.d/ini

Re: MySQL Ports & Sockets Problem

2001-09-01 Thread s . keeling
On Sat, Sep 01, 2001 at 03:54:31PM -0700, Edward Blazer wrote: > > When i do a portscan on my box, the mysql port does not show up leading me > to beleive that mysql has not bound to the port. I've confirmed this by > trying to telnet to the port, but I do not get the garble that I expect, > rath

RE: subject header

2001-09-01 Thread Cal Evans
Wow, has it been a month already? Please check the archives before posting. There are several discussions on this exact topic. Cal http://www.calevans.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Harvey Sent: Saturday, September 01, 2001 8

subject header

2001-09-01 Thread Peter Harvey
Would it be possible to get a header prefix on the subject line for all email sent out from this list. For example; [mysql] subject header This is becoming quite common these days and is very useful when interpreting the subject line. Thanks!! Peter -- +--- | Data A

RE: Win98 Installation problems

2001-09-01 Thread Mathew Hamilton
Hello, I am having a problem installing mysql on Win98. I am getting an error mesage when trying to start the serversomething to do with the innodb_data_file_path I have the following in a my.cnf file off of c: innodb_data_file_path = ibdata1:2000M;ibdata2:2000M innodb_data_home_dir = c

Make Money For Sending E-mail

2001-09-01 Thread fred . bill
Dear [EMAIL PROTECTED], > BE A MILLIONAIRE LIKE OTHERS WITHIN A YEAR!!! > > > Before you say ''Bull'', please read the following.> > This is the letter > you > have been hearing about > on the news lately. Due to> the popularity of > this > letter on the Internet, a national weekly news> > progr

Strange Problem !

2001-09-01 Thread Daniel Urstöger
Hiya ! I am not new with mysql, but I guess my experience is not enough for that kind of problem ;) mysql runs fine now the last 3 weeks, but now I am running into problems. I want to restart mysql with the /etc/rc.d/init.d/mysql stop skript, but it doesn´t done so .. Killing mysqld with pid kill

Re: Problem while compiling mysql-4.0

2001-09-01 Thread Fournier Jocelyn [Presence-PC]
Sorry, I've just seen the problem has been already fixed by tonu in the mysql-4.0 tree. - Original Message - From: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, September 02, 2001 1:00 AM Subject: Problem while compiling my

DSN-Less connection Strange error!

2001-09-01 Thread randy
Hi People, I'm trying to connect to Mysql server using Access2k, VBA and DSN less connection, and mysql v3.23.36. All queries sent to the server exceute or returns records just fine except one simple query. "DESCRIBE Employees" Employees is a table in my database. the server responds by : "D

Problem while compiling mysql-4.0

2001-09-01 Thread Fournier Jocelyn [Presence-PC]
Hummm I forgot one important thing : mysqld.cc: In function `int main(int, char **)': mysqld.cc:1994: `ssl_acceptor_fd' undeclared (first use this function) mysqld.cc:1994: (Each undeclared identifier is reported only once mysqld.cc:1994: for each function it appears in.) - Original Message

Re: MySQL Ports & Sockets Problem

2001-09-01 Thread Edward Blazer
Hi, When i do a portscan on my box, the mysql port does not show up leading me to beleive that mysql has not bound to the port. I've confirmed this by trying to telnet to the port, but I do not get the garble that I expect, rather just a timeout. I've setup my 'my.cnf' in my datadir but this seem

Re: Berkeley or InnoDB?

2001-09-01 Thread David Turner
Can you explain this further? Dave On Sat, Sep 01, 2001 at 12:52:43PM +0400, Ilya Martynov wrote: > > AM> I'm porting an application to MySQL and I need to support transactions. > AM> I will appreciate so much if someone could give me some impressions about > AM> which one is better. BerkeleyDB

problem while compiling mysql-4.0

2001-09-01 Thread Fournier Jocelyn [Presence-PC]
Hi, I've just encoutered an error while compiling MySQL-4.0 : gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/var/lib/mys ql\"" -DDATADIR="\"/var/lib/mysql/var\"" -DSHAREDIR="\"/var/lib/mysql/share/mysql\"" -DHAVE_C ONF

MySQL Data problem...

2001-09-01 Thread Brian E . Lozier
Well I made quite the mistake and I'm hoping someone can help me out! I had a RH Linux 6.1 box running MySQL (not exactly sure what version anymore). I took all the files from the mysql/data directory and backed them up. Then I wiped the server and installed FreeBSD. I then installed the l

Re: Mysql C API Problem

2001-09-01 Thread Uwe Sander
just add mysql_init(&csql); before accessing the struct for any purpose. Sure it helps (I made the same mistake, got the same result ;-) Uwe - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, September 01, 2001 8:25 PM Subject: Mysql C API Problem

Mysql C API Problem

2001-09-01 Thread BeachTHO
am connecting to a mysql server on localhost i put all the code in a function call mysql_conlocal MYSQL csql; int mysql_conlocal() { puts("Connecting to Mysql Server"); if(!mysql_connect(&csql,DBHOST,DBUSER,DBPASS)) { puts("Failure!"); puts("This Could Because"); puts("A Your Username or Passwo

RE:Wa way OT

2001-09-01 Thread Mike
Thanks to all that answered. I found PC Pine for my Win2K works and QMAIL for the Linux E-mail Server w/Pine works as well. Cheers M;) There is nothing sadder than a mosquito sucking on a mummy. Give it up little guy. - Jack Handey > > I am looking build my own E-mail Server for my Domain an

Re: creating a new table from existing one

2001-09-01 Thread John Hunter
I have a working solution to the problem in the post above but am wondering if there is a better more efficient way. I was able to get the first quote simply by virtue of the fact that the table is ordered by trade_date, and created a temporary table sorted in descending order by trade_date to g

Is mysql_query() reentrant ?

2001-09-01 Thread Marc A. Mueller
Hi, I want my application (LINUX, C++) to send periodically an information to a MySQL-Server, regardless of whats it is actually doing at the moment. Can I use the alarm signal for this (is mysql_query() signal-reentrant) ? I'm using the normal mysql-library, not mysql++. Versions should not be

NewLine

2001-09-01 Thread Peter Harvey
>> It really depends on the client. MySQL does not inherently know how to >> process multiple statements. If you're sending SQL from a program you >> developed, you'll probably have to separate the statements and submit them >> individually. >> > >I may take exactly that approach. Thanks! > >Pet

[unixODBC][TCX][MyODBC]Can't connect to local MySQL server through socket

2001-09-01 Thread Peter Harvey
>> >> root@workstation3:/home/manuel > isql -v MySQLtest dbuser >> [unixODBC][TCX][MyODBC]Can't connect to local MySQL server through socket >> '/var/lib/mysql/mysql.sock' (2) >> [ISQL]ERROR: Could not SQLConnect >> root@workstation3:/home/manuel > >> >> It seems to try to connect to a local mysql

Re: mysqlshow shows list of blank (not empty) tables (FAQ?)

2001-09-01 Thread Simon J Mudd
On Sat, 1 Sep 2001, Sinisa Milivojevic wrote: > Simon J Mudd writes: > > I've not been using mysql for some time but did have it running for a > > couple of small databases I use at home. It doesn't appear to work now, > > the most obvious sympton being that msyqlshow shows a list of blank table

BDB or InnoDB ?

2001-09-01 Thread Jocelyn Bernier
Hi everybody, I am currently looking the transactional part of MySQL and I'm wandering which one is best to use in regard to efficiency and reliability. Which one is the most stable, etc? Thank you. __ Jocelyn Bernier 259 Racicot Saint-Jean-sur-Richelieu, QC J3B 8N3 [

Re: NewLine between statements

2001-09-01 Thread Peter Harvey
> It really depends on the client. MySQL does not inherently know how to > process multiple statements. If you're sending SQL from a program you > developed, you'll probably have to separate the statements and submit them > individually. > I may take exactly that approach. Thanks! Peter -- +-

Re: NewLine between statements

2001-09-01 Thread j.urban
It really depends on the client. MySQL does not inherently know how to process multiple statements. If you're sending SQL from a program you developed, you'll probably have to separate the statements and submit them individually. The clients that allow multiple statements (ie urSQL and the mysq

Re: MyODBC between MySQL-Server (Linux) and Linux-Client

2001-09-01 Thread Peter Harvey
> > root@workstation3:/home/manuel > isql -v MySQLtest dbuser > [unixODBC][TCX][MyODBC]Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (2) > [ISQL]ERROR: Could not SQLConnect > root@workstation3:/home/manuel > > > It seems to try to connect to a local mysql-server,

MyODBC between MySQL-Server (Linux) and Linux-Client

2001-09-01 Thread Manuel Ohnemus
I'm new to MySQL and now a problem occured: I'm running a mysql-server on linux with a database test. No I want to connect to this via MyODBC from Windows and Linux clients. So I installed /etc/odbc.ini on the server: [MySQLtest] Description = MySQL fuer DB 'test' auf localhost Driver = MySQL

Please help!!!!!!Re: order by...group by...complicated query

2001-09-01 Thread hassan el forkani
>hi, > >i am trying to build a message board in php with mysql as back end; > >what i want to do is to query the database in a certain way that the >result is returned in the correct order for php to display the discussion >thread properly > >here is my table structure: > >mysql> show fields fr

Re: mysqld as root

2001-09-01 Thread Sinisa Milivojevic
Jeremy Zawodny writes: > On Thu, Aug 30, 2001 at 02:12:33PM +0300, Sinisa Milivojevic wrote: > > The code, please. :-) > > I was just bit by the same problem the other day while shuffling > my.cnf files around on a server. Took me a minute to figure out what > was going on. > > Jeremy > -- >

Re: Trouble connecting to MySQL server using MySQLGUI and VCC

2001-09-01 Thread Sinisa Milivojevic
Chris Johnson writes: > The remote hosts you mention are not allowed to access the database. This > is a permissions problem, in particular the value of "hosts" in one of the > permissions tables. It sounds like they only allow connections from the > localhost or their own network. > > ..chris

Re: mysqlshow shows list of blank (not empty) tables (FAQ?)

2001-09-01 Thread Sinisa Milivojevic
Simon J Mudd writes: > I've not been using mysql for some time but did have it running for a > couple of small databases I use at home. It doesn't appear to work now, > the most obvious sympton being that msyqlshow shows a list of blank table > names. > > I'm sure that I'm doing something wron

Re: Optimum table and select

2001-09-01 Thread joseph . bueno
Hi, Edward Meyer wrote: > > I have a table with the following columns > id => int not null auto_increment > stockid => integer > tdate => date > price => float > primary key (id) > key (productid) > > The table has 8,000,000+ rows holding 8000+ different stockids. > > I have to pul

Re: Berkeley or InnoDB?

2001-09-01 Thread Ilya Martynov
AM> I'm porting an application to MySQL and I need to support transactions. AM> I will appreciate so much if someone could give me some impressions about AM> which one is better. BerkeleyDB or InnoDB? I belive that at least for big databases InnoDB is better because BerkeleyDB perfomance is good

RE: NewLine between statements

2001-09-01 Thread Don Read
On 01-Sep-2001 Peter Harvey wrote: > MySQL > > Anyone know what the deal is with sending multiple statements to the > server and getting errors at ";\n" on the first statement? Even the > result will come back with something other than '\n' in error messages. > > I am using MyODBC but I am not