If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > back up of database between two dates

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-28-11, 03:33
rohitamitpathak rohitamitpathak is offline
Registered User
 
Join Date: Feb 2011
Location: india- new delhi
Posts: 31
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..
Reply With Quote
  #2 (permalink)  
Old 03-28-11, 06:18
it-iss.com it-iss.com is offline
Registered User
 
Join Date: Sep 2009
Location: San Sebastian, Spain
Posts: 623
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
Senior Oracle/MySQL DBA
http://www.it-iss.com
Reply With Quote
  #3 (permalink)  
Old 03-28-11, 07:26
rohitamitpathak rohitamitpathak is offline
Registered User
 
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..
Reply With Quote
  #4 (permalink)  
Old 03-28-11, 07:55
it-iss.com it-iss.com is offline
Registered User
 
Join Date: Sep 2009
Location: San Sebastian, Spain
Posts: 623
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
Senior Oracle/MySQL DBA
http://www.it-iss.com
Reply With Quote
  #5 (permalink)  
Old 03-28-11, 08:41
rohitamitpathak rohitamitpathak is offline
Registered User
 
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?
__________________
Amit Pathak
S/w Developer
Zero Systems Pvt Ltd..

Last edited by rohitamitpathak; 03-28-11 at 08:44.
Reply With Quote
Reply

Tags
mysql backup

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On