Re: Add a replicated DB w/o rebooting the server

Hi Norbert,

Ok, when I said reboot the server I was referring to restart the mysql proceess. I see that my expression was not clear enough :)

And I would prefer not to restart the mysql process because some services may not have persistent connections. Therefore, if I restart the server those connections would be lost...

So, any way to add the database without having to restart the mysql process?

Regards,
Oriol.

Norbert Tretkowski wrote:
> Am Mittwoch, den 31.10.2007, 11:21 +0100 schrieb Oriol Capsada:
>
>> Everything I have read about adding a new database to a slave
>> replication talks about adding a new line in the configuration file (for
>> example a replicate-wild-do-table) and then restart the server.
>>
>> Is it possible to do so without having to reboot the server?
>>
>
> You don't need to reboot the whole server, it's enough to restart just
> the mysqld server process (e.g. with '/etc/init.d/mysql restart').
>
> Norbert
>
>
>

-- 
==========================
Oriol Capsada
VozTelecom
Systems & Networking Dep.
oriolc@voztele.com
http://www.voztele.com
==========================


-- 
MySQL Replication Mailing List
For list archives: 
http://lists.mysql.com/replication
To unsubscribe:    
http://lists.mysql.com/replication?unsub=lists@pantek.com