Re: mysqlsnapshot and InnoDB tables

2002-10-28 Thread Amaya
Jeremy Zawodny dijo: > That depends. I don't know if it's "safe" to backup the InnoDB > tablespaces without shutting the server down. I suspect that it's not > because there is no way to force InnoDB to commit all logged > transactions. In practice it may not be a problem, but it could be. Cool

Re: mysqlsnapshot and InnoDB tables

2002-10-28 Thread Amaya
Jeremy Zawodny dijo: > That depends. I don't know if it's "safe" to backup the InnoDB > tablespaces without shutting the server down. I suspect that it's not > because there is no way to force InnoDB to commit all logged > transactions. In practice it may not be a problem, but it could be. Cool

Re: mysqlsnapshot and InnoDB tables

2002-10-28 Thread Jeremy Zawodny
On Fri, Oct 25, 2002 at 02:33:54PM +0200, Amaya wrote: > Dear friends, > > I have successfully setup MySQL replication enviroment in several > clusters at work. The thing is that it is a little cumbersome > proccess as I have to make a snapshot of the databases in the master > server everytime and

Re: mysqlsnapshot and InnoDB tables

2002-10-27 Thread Jeremy Zawodny
On Fri, Oct 25, 2002 at 02:33:54PM +0200, Amaya wrote: > Dear friends, > > I have successfully setup MySQL replication enviroment in several > clusters at work. The thing is that it is a little cumbersome > proccess as I have to make a snapshot of the databases in the master > server everytime and

mysqlsnapshot and InnoDB tables

2002-10-25 Thread Amaya
Dear friends, I have successfully setup MySQL replication enviroment in several clusters at work. The thing is that it is a little cumbersome proccess as I have to make a snapshot of the databases in the master server everytime and I have to stop the service in order to do it. I have just come ac

mysqlsnapshot and InnoDB tables

2002-10-25 Thread Amaya
Dear friends, I have successfully setup MySQL replication enviroment in several clusters at work. The thing is that it is a little cumbersome proccess as I have to make a snapshot of the databases in the master server everytime and I have to stop the service in order to do it. I have just come ac