Hi Backups/recovery procedures for MySQL are very simple, and efficient.
The approach I take, is to - Implement a replicated dual master and - Flush mysql db logs - Use mysqldump <db> | gzip -c > <db>.sql.gz at a quiet time - Copy mysql logs This is essentially, the same process one would use with oracle. Simon ----- Original Message ----- From: "Jean Hagen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 31, 2003 10:24 PM Subject: Backup conventions > Hi, I'm a new user of MySQL on Linux. > > I have been an Oracle DBA; and know that anyone familiar with Oracle takes > backup procedures very seriously.... > > Anyone have recommendations for nightly backup procedures for MySQL > (transactional) databases? The literature seems a little ambiguous on this. > > I did 'turn on' the general, binary and error logs. Does anyone shut down > the MySQL daemon regularly? Anyone use mysqldump, or do folks simply use a > file system backup? We have tons of databases and tons of tables, so I'm > not really considering the lock/flush procedure on tables... > > Any suggestions? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > The information in this e-mail and any attached files is confidential. > It is intended solely for the use of the addressee. > Any unauthorised disclosure or use is prohibited. > > If you are not the intended recipient of the message, > please notify the sender immediately and do not disclose the contents > to any other person, use it for any purpose, or store or copy the > information in any medium. > > This message has been scanned for viruses and dangerous content by > MailScanner, http://www.mailscanner.info, and is believed to be clean. > > > -- This message has been scanned for viruses and dangerous content by MailScanner, http://www.mailscanner.info, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]