MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

Replicating a new database (after replication has started)
Posted by: Alex Not Telling
Date: December 31, 2005 03:27AM

Hi,

I've got full replication running for about 100 databases between master and slave. Now, when someone adds a new database to the master, the slave doesn't create the new database. It then dies with an error like this (because the new database hasn't been created):

Error 'Can't find file: './chiro_gaverke/phpbba_sessions_keys.frm' (errno: 13)' on query. Default database: 'chiro_gaverke'. Query: 'INSERT INTO phpbba_sessions_keys(key_id, user_id, last_ip, last_login) VALUES ('5604e25958ceb2430adbda9e4d4281d5', 136, 'd5e04c3b', 1135961586)'

Does anyone know how I can have the slave also create the new database when it is created on the master?

Thanks in advance,
Alex

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Replicating a new database (after replication has started)
2286
Alex Not Telling
December 31, 2005 03:27AM
Re: Replicating a new database (after replication has started)
1596
Alex Not Telling
January 02, 2006 03:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.