MySQL Replicaiton

2003-08-29 Thread Leo Genyuk
I am having problems to start MySQL replication. I followed all the steps outlined on the website, but replicaiton is not working. slave status shows the following: mysql> show slave status\G *** 1. row *** Master_Host: mail.dbi.tju.edu

ERROR 1186: Binlog closed, cannot RESET MASTER

2003-07-14 Thread Leo Genyuk
I am getting the following error after trying to flush the master: mysql> flush master; ERROR 1186: Binlog closed, cannot RESET MASTER I am using mysql Ver 12.20 Distrib 4.0.13, for sun-solaris2.9 (sparc) Does anyone know what this might be? Thank you in advance, Leo. -- MySQL General Mailing

Updating MySQL db's

2003-06-25 Thread Leo Genyuk
I have two server running Appache + PHP + MySQL. Server #1 is production and server#2 is development. I would like to keep MySQL DB on server#2 up to date. That is any changes happening on server#1 I would like to be reflected on server#2. Does anyone know how to do this? Thank you in advance.

Can't drop a database

2003-06-19 Thread Leo Genyuk
Hello. I am running MySQL database on Sun Solaris 9. # mysql -V mysql Ver 11.18 Distrib 3.23.54, for sun-solaris2.8 (sparc) I am having a problem dropping a database. All the tables in the database have been dropped successfully, but the database does not want to go away. To be more specific, w