This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Mysql data retrieving Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Mysql data retrieving" Watch "Mysql data retrieving" New topic

Mysql data retrieving

ashish chakkara

Joined: Sep 13, 2012
Posts: 10


I accidently updated my Mysql db with previous backup(which is 1 week old) just now.So i can't find the data entered yesterday.
Is there any way to get the db upto yesterday?

Please help me

Jeff Verdegan

Joined: Jan 03, 2004
Posts: 6109

Was your backup in the form of SQL statements to execute? Or did you just replace the data files with the older versions?

If it was done by SQL statements, then you may still have a transaction log around that you can use. I don't know the details, or even if you'll be able to fix it, but you could google for something like mysql transaction log or mysql recovery or something like that.

ashish chakkara

Joined: Sep 13, 2012
Posts: 10

Hi Jeff,

Thank you,

Actually my back is a .sql file which was taken by mysqldump command(mysqldump -u username -pPASSWORD pPASSWORD >/mnt/abc_23oct2012.sql)
This was done 1 week ago.Today i accidently run the command mysql -u username -pPASSWORD pPASSWORD < /mnt/abc_23oct2012.sql
So what happend is that i lost i week data from my db.So what should i do to recover the lost data? please help me...

Campbell Ritchie

Joined: Oct 13, 2005
Posts: 38025
You have already been given suggestions. What happened when you followed them?
I think this discussion would sit better in our databases fora: moving.
Kemal Sokolovic

Joined: Jun 19, 2010
Posts: 825

OP, try what other(s) already suggested. But I wouldn't be optimistic about retreiving old data since you didn't create a backup before you updated database. Since autocommit is enabled by default (source) all (create, update, delete) statements are commited as soon as they completed successfully, so I suppose there is no way to do a rollback.

The quieter you are, the more you are able to hear.
I agree. Here's the link:
subject: Mysql data retrieving
Similar Threads
some queries about standalone application
What kind of file does MySQL create?
MYSQL 5.0 Connection Time Out
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
Excel File opening