mysql crashe-binary logs

Hello, I use mysql 3.23.49 on Solaris and I have started binary logging.. I had no problem for quite a long time but the last days I see this message in the error log file mysqld restarted /usr/local/mysql/libexec/mysqld: ready for connections Any idea why this is happening? -- MySQL General M

mysql replication problem

Hi, I am replicating a table between 2 servers. The table on the master executes many transactions that should be replicated to the table on the slave.. The table on the slave is only readable... I have noticed that the changes on the master are not replicated at once but it takes about 2 hours to

Mysql replication problem

Hello, I use mysql version 3.23.49 and I have set up replication but once in a while I get the error below on the slave.. "Error reading packet from server: Lost connection to MySQL server during query (read_errno 134,server_errno=2013)" Then the slave reconnects to the master and the replicatio

Re: Not unique table/alias

Hi, I think that when you use a table for one operation pe select or insert, the table is locked and you cannot execute another operation. In your statement if you use different tables for the two operations, I don't think you'll have a problem... Ciprian I. Acatrinei wrote: Hi, mysql> INSERT

Re: error:mysqld got signal 11

Hello Victoria, I have installed mysql 3.23.49 for Sorlaris and I have installed it from the source distribution. Do you have any idea about my problem? Thanks :-) Victoria Reznichenko wrote: >Vaso, >Thursday, September 26, 2002, 9:54:06 AM, you wrote: > >VK> I have started mysql server keepin

error:mysqld got signal 11

Hello, I have started mysql server keeping binary logs and once in a while I execute "reset master". Irregularly mysqld crashes and in the error logs I read the lines bellow: mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it

Error during replication in mysql

Hello, I have implemented replication between 2 tables in MySQL since then, once in a while I see this error in the error log files "Error reading packet from server: Lost connection to MySQL server during query (read_errno 134,server_errno=2013)" Any ideas? Thanks.. --

Replication and firewalls

Hi everyone, While I was reading MySQL manual about replication I came up with some questions. According to the manual, we create a user i.e. repl user on the master and we give him FILE privilege. Isn’t this privilege dangerous enough? I mean if we assume that there is a firewall between master