Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012
    Posts
    2

    Question Unanswered: Backup mysqldump by sqlquery

    Hi All,

    I' like to backup day by day from mysql. However I don't know how to do it ? How to get different of yesterday from today ...?

    For instance ;
    I took backup on yesterday (05-26-2012) at midnight and I'd like to backup for today at midnight. But Today Backup's shouldn't contains yesterday data...

    How can I do this ?

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    What you are looking for as an incremental backup. That is to say only the data changes between your last backup and now. Check this link:MySQL :: MySQL 5.1 Reference Manual :: 7.2 Database Backup Methods. You will need to activate binary logs to do this.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •