Hello list.
Inorder to do some maintainance, I will be shutting down my production server running mysql4.1. I have already prepared a backup server which is running mysql4 and have imported the current database in it. Though one way of doing things can be to shut down the database on the production server and then take the dump and import it on the backup server and then after shifting has been done to retake the dump from backpserver and import it on the production system. My question is that is there any better way to do this. E.g. If there is a way to detect for new records anmd/or changes made to database, I can just take those changes and export them on the production system. Or can we compare the two databases on seperate servers and then sync them. If some one can please point me to the right direction or give me a pointer on what to look for? Thanks and Regards Naufal
