Re: Daily Incremental Backups on Mysql

[Daniel Kasak]

Jerry Swanson wrote:
Is it possible to do "daily incremental backups" on mysql? 

Thanks
 

Yes.
mysqldump will give you a starting point, and the binary transaction 
logs give you your incremental backups - copy these somewhere each day - 
onto a backup tape or something. Read the documentation for mysqldump 
and for processing the binary transaction logs.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]