Re: Replication problems (server_errno=1236)

2003-06-03 Thread Calvin Hill
Nils, I agree with you, you do have to have all the log files, which is why I reset the master. According to the manual: 4.10.7.5 RESET MASTER (master) Deletes all binary logs listed in the index file, resetting the binlog index file to be empty. Previously na

Replication problems (server_errno=1236)

2003-06-03 Thread Calvin Hill
Hello, I'm running MySQL Ver 12.18 Distrib 4.0.12 I had replication set up and working perfectly between two machines in a round robin fashion. (Serv 1 updates Serv 2 and Serv 2 updates Serv 1.) Recently serv 2 locked up, upon restarting, it automatically began to update with the files fr

Re: Won't compile on Mac OS X 10.2

2002-08-25 Thread Calvin Hill
On 8/25/02 11:36 PM, "Joel Rees" <[EMAIL PROTECTED]> wrote: > For some reason my client sub-directory did not get re-named to bin > and, as I said, I cannot connect. Keep getting: > > % mysql > ERROR 2002: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (2) You might want

Problem with joining multiple tables

2002-08-15 Thread Calvin Hill
I am having some problems getting multiple joins to work. I have the following code: mysql> select customers.customer_id, last, first, company, count(work_order.work_order_number) as WO -> from customers left join work_order -> on (customers.customer_id=work_order.customer_id) -> whe

Help With Joins

2002-08-13 Thread Calvin Hill
I am having some problems getting multiple joins to work. I have the following code: mysql> select customers.customer_id, last, first, company, count(work_order.work_order_number) as WO -> from customers left join work_order -> on (customers.customer_id=work_order.customer_id) -> wher