Database Replication

2002-04-02 Thread Eric Baines
I have setup replication between two servers. Everything works great. I wanted to change the location of the bin-log file. I tried 'log-bin=/somedirectory/replication.log' but I get this error 'replication.1 not found (Errcode: 2)'. I took this from the manual:

Auto_increment and TimeStamp Fields

2002-03-25 Thread Eric Baines
I have created a table with a Primary Key that is an auto_incrementing field. I was able to receive the auto_increment values by issuing a last_insert_id(). When I added a timestamp to this table, the last_insert_id() no longer returned any value except 0. Is there a MySQL rule that you can

Re: Auto_increment and TimeStamp Fields

2002-03-25 Thread Eric Baines
] To: Eric Baines [EMAIL PROTECTED], [EMAIL PROTECTED] cc: 03/25/02 03:02 PMSubject: Re: Auto_increment