Re: MySQL upgrade from 5.0.51a to 5.1.53

2010-12-28 Thread 杨涛涛
Hi all, I did a upgrade from 5.0 to 5.1 yesterday. And I paste some of my steps on the following. 1. Use mysqldump to dump all the data to the disk. 2. Backup all the data including mysql system files to a safe place. 3. Remove all the file related to mysql. 4. Install the new 5

Re: Another replication question

2010-12-28 Thread 杨涛涛
Ok, I'll not post any more! Just reading! David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com My Msn: yueliangdao0...@gmail.com 在 2010年12月23日 下午8:14,Johan De Meersman 写道: > Glad to hear I'm not the only one annoy

Re: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

2010-12-28 Thread Yves Goergen
On 21.12.2010 11:27 CE(S)T, 杨涛涛 wrote: > Maybe you should give a password to MySQL's root. And I think this note will > disappear. I would be extremely dumb not to set any password on MySQL's root account at all! Of course (I hope I made that clear before) a password has been set while installing

Re: Back-up Plan for Large Database

2010-12-28 Thread Brent Clark
On 27/12/2010 19:14, Wagner Bianchi wrote: *You have no guarantee the data on the slave matches the master 100%.* * * Try it with *semi-synchronous* replication. Best regards. -- Wagner Bianchi Hiya Thats why you nagios monitor replication of your slaves (I do master master replication moni