File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Recover Mysql Dump file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Recover Mysql Dump file" Watch "Recover Mysql Dump file" New topic

Recover Mysql Dump file

vignesh Thamarai
Ranch Hand

Joined: Mar 10, 2009
Posts: 31
Iam pretty newbie to mysql, I backup my database as dump file, and then i restore my database after some time i used " mysql -u xxx -p xxx databasename > file.sql" , i use '>' symbol instead of '<' . now my entire file has been overwritten,before restore my file size is 85 mb now it is 0kb. is it anyway to recover my old file? please help me to solve my problem.
Ravishanker kumar
Ranch Hand

Joined: Jul 20, 2006
Posts: 53
I don't think that's possible If you have lost dump file that you had taken.
Please check, is there any feature available in mysql which allow to take dump up a specified date. Please let me know if you find some way to recover.
I agree. Here's the link:
subject: Recover Mysql Dump file
jQuery in Action, 3rd edition