binary bin problems on HPUX 11.0

2001-08-28 Thread William Chi
Hi, we are using mysql 3.23.33 on HPUX11 and every time we reboot the machine, it overwrites the binary log and starts from 001 again. This is only happening on a couple of machines. It doesn't do this if i manually restart mysql, only when the machine is rebooted. On one of the machines, mysql

Running multiple MySQL servers on one machine

2001-07-15 Thread William Chi
Hi, I was wondering if anyone has any opinions on the advantages and disadvantages of running multiple servers on one machine. Each server would be used to access different databases. Note also that these databases will both be replicated and there shall be multiple machines. Possibly some

Backups, Replication and the binlog

2001-05-15 Thread William Chi
Hi all! I have been attempting to set up a system that involves replication and have run into some minor problems. I am only replicating one database but not all of the tables in the database. So when changes are made to the replicated dataase, it is logged to the binary log even if it is from