Re: how to setup replication - MySQL 5.0.x - Migration and new databases

2010-07-14 Thread Michael Dykman
Options such as these are set in my.cnf/my.ini (depending on your host operating system). innodb_file_per_table is a very useful option but not neccessarily the best choice for a novice trying to set up replication. - michael dykman On Tue, Jul 13, 2010 at 5:43 AM, lejeczek pelj...@yahoo.co.uk

Re: how to setup replication - MySQL 5.0.x - Migration and new databases

2010-07-13 Thread lejeczek
I'm a novice myself and yes I must say on-line documentation is not easy nor comprehensive, let's take this page as an example: http://dev.mysql.com/doc/refman/5.1/en/replication-howto-rawdata.html if I don't use InnoDB Hot Backup, doc says.. ..Otherwise, you can obtain a reliable binary

Re: how to setup replication - MySQL 5.0.x - Migration and new databases

2010-06-10 Thread Götz Reinicke - IT-Koordinator
Am 08.06.10 12:05, schrieb Rob Wultsch: On Mon, Jun 7, 2010 at 11:59 PM, Götz Reinicke - IT-Koordinator goetz.reini...@filmakademie.de wrote: Hi, we do have different LAMP systems and recently I started to put some mysql databases on one, new master server. (RedHat, Fredora, MySQL 4.x -

Re: how to setup replication - MySQL 5.0.x - Migration and new databases

2010-06-10 Thread Joerg Bruehe
Hi all! Götz Reinicke - IT-Koordinator wrote: Am 08.06.10 12:05, schrieb Rob Wultsch: On Mon, Jun 7, 2010 at 11:59 PM, Götz Reinicke - IT-Koordinator goetz.reini...@filmakademie.de wrote: Hi, we do have different LAMP systems and recently I started to put some mysql databases on one, new

how to setup replication - MySQL 5.0.x - Migration and new databases

2010-06-08 Thread Götz Reinicke - IT-Koordinator
Hi, we do have different LAMP systems and recently I started to put some mysql databases on one, new master server. (RedHat, Fredora, MySQL 4.x - 5.0.xx) I did this by exporting some databases with mysqldump and importing tham on the new server. Now I'd like to add a slave mysqlserver and so I

Re: how to setup replication - MySQL 5.0.x - Migration and new databases

2010-06-08 Thread Rob Wultsch
On Mon, Jun 7, 2010 at 11:59 PM, Götz Reinicke - IT-Koordinator goetz.reini...@filmakademie.de wrote: Hi, we do have different LAMP systems and recently I started to put some mysql databases on one, new master server. (RedHat, Fredora, MySQL 4.x - 5.0.xx) MySQL 4.X is EOL. I strongly suggest