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
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
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
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
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