Hello ! We recently upgraded our Master (Live server) to mysql version 3.23.28 - gamma. And the same version upgrade for our Slave server. We tried replicating our main database, which has nearly 35 tables. We did everything as per the MySQL documentation to Replicate the database and have a mirror-ed DB at our end. We were successful in mirroring our tables initially using LOAD TABLE FROM MASTER. But some of the tables on Slave server have very short life. They presumabely die, giving this sort of Error : Error 1016: Can't open file: 'ftp_customer.MYD'. <errno: 144> This also happens when MySQL server is shutdown and re-started. This happens to some of the tables. It seems, it is damaging the file structure of the table somehow on the Slave. We tried the MySQL Slave server on both WIN NT and Linux Redhat 6.x operating system. In both the cases, tables are getting damaged, and no data is retrieved from the Slave MySQL server henceforth. Please help us to fix this problem. Any idea why it is happening ? Thanks. Bijal Kothari _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. --------------------------------------------------------------------- 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
