Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2011
    Location
    india- new delhi
    Posts
    31

    Unanswered: back up of database between two dates

    I m trying to get the database backup with condition [between two days], can anybody tell me how i make it?
    Amit Pathak
    S/w Developer
    Zero Systems Pvt Ltd..

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Backups are basically dumb copies of data. The intelligence is actually placed in your recovery strategy. If you read up about point in time recovery this might help you. But identifying data present in the database between two dates is not a backup, this should be treated as functionality designed into your application i.e. add an additional column createddate and/or lastupdateddate and populate these fields so that using this you correctly identify the rows that have changed between two dates.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  3. #3
    Join Date
    Feb 2011
    Location
    india- new delhi
    Posts
    31
    Quote Originally Posted by it-iss.com View Post
    Backups are basically dumb copies of data. The intelligence is actually placed in your recovery strategy. If you read up about point in time recovery this might help you. But identifying data present in the database between two dates is not a backup, this should be treated as functionality designed into your application i.e. add an additional column createddate and/or lastupdateddate and populate these fields so that using this you correctly identify the rows that have changed between two dates.
    yes sir i was thinking the same, we need to add a coloumn for date and then fire queries to get the data between two dates,
    one thing is more suppose that i run a query which give the data from mulitple tables, is this possile to make backup of data which i get from query, is it possible to make a backup of data which we get from any query?
    Amit Pathak
    S/w Developer
    Zero Systems Pvt Ltd..

  4. #4
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    No not from any query but directly from the tables themselves. I suggest you read up about the mysqldump application and look at the various options available.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  5. #5
    Join Date
    Feb 2011
    Location
    india- new delhi
    Posts
    31

    thank you so much

    Quote Originally Posted by it-iss.com View Post
    No not from any query but directly from the tables themselves. I suggest you read up about the mysqldump application and look at the various options available.
    thank you so much, i understand what u want to say, sir i asked a quesion regarding log file,please give some guildeline regarding that, i changed my my.cnf file but when i open mysql.log it alwasy empty, why, how i can see log file data?
    Last edited by rohitamitpathak; 03-28-11 at 09:44.
    Amit Pathak
    S/w Developer
    Zero Systems Pvt Ltd..

Tags for this Thread

Posting Permissions

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