Re: SELECT w/LIKE on Swedish character รถ finds ], why?

2002-03-26 Thread James Housley
Philip Semanchuk wrote: > > Hi everyone, > I am having a little trouble with searching for Swedish characters. When I > SELECT using LIKE I get matches that I do not expect. I have created a > simple test case that is entirely reproduced below. To summarize, I insert > one row into a single-colum

Re: Rotation of binary logs on replication master?

2002-03-21 Thread James Housley
Guy Davis wrote: > > Just wondering if any Linux users of MySQL out there had written a > logrotate configuration file for dealing with MySQL binary logs on a > replication Master. > > I want to rotate these logs (6.5 GB now) as some are over a month old. > However, I don't want to confuse any o

Re: High Availability questions

2002-03-20 Thread James Housley
Young Sul wrote: > > Hi, > > I've got a website that uses a mysql backend database. Due to the way in > which > the database and development has been architected, I'm unable to > load-balance > the database between multiple DB servers, taking advantage of replication > inherent > in mysql. (this

Re: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-06 Thread James Housley
Sam Iam wrote: > > We have a very high volume site (3 million page views a day) that's run > on 16 Apache / PHP web servers & 2 MySQL servers. We are using PHP with > persistent connections. Each MySQL serves 8 web servers & is supposed to > act as a failover machine for the other group of 8 web

Re: TIMESTAMP not acting as I'd like

2002-03-06 Thread James Housley
"[EMAIL PROTECTED]" wrote: > > Hi, > > small problem. I have a table set up like so. It has a number of entries > that were added on a certain date, I use TIMESTAMP to keep track of the date. > > +-+---+--+-+-+-- > --+ > | Field

Re: MySQL Database Replication

2002-03-05 Thread James Housley
Thi Cao wrote: > > Hello everyone, > > This is my first attempt at MySQL database replication. Can't seem to get > it to work yet. The problem reported in the error log of the slave server > is as follows: > > Error reading packet from server: Access denied for user 'repl@slave_host' > (Usin

Databases are disappearing

2002-03-03 Thread James Housley
Starting about 2 weeks ago I started having problems with my databases disappearing. mysqld is still running and can be shutdown via mysqladmin and such. But "mysql -ppassword -u root mysql" will produce a message similar to "Unable to find database 'mysql'", and this goes for all of the databas