> > Is there any "best-practices" wisdom on what is the most preferable > > method of backing up moderately (~10-20,000 record) MySQL 4 > > databases? A mysql dump to store records as text, the > format provided > > by the BACKUP sql command, or some other method? I am not asking > > about replication, rotating backups, or remote storage, and I am not > > concerned about the size of the backup files. Replication might be > > the best scenario for some sites but this case is not high finance.
I read this over and over.. I am curious why replication is such high finance?? I run it here. The Production system is a high finance machine and the replicated box is a old clunker basically.. It doesn't take much for the stuff to be replicated over.. The high dollar has queries, this and that. The replicated machine is just simply keeping up with the changes.. That's it. You could do that with just about any decent machine.. I would think.. sure, there is going to be the few that load and change data constantly.. But I still think that would be ok.. (have to test it). Do you guys agree? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]