Hello, I am trying to setup replication to be used basicaly as a hot backup. My production database uses INNODB tables. I would like my Replication database to just my MyISAM since I do not need transactions on that one. Just a copy of the data. I followed the process to create the slave but since I am using INNODB tables tar'ing up the mysql directory and moving it to the slave does not work.
What must I do? Would I be best to export everything to a file using mysqldump then reimport it? Thanks, Serge. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php