This week's book giveaway is in the JavaScript forum.
We're giving away four copies of Getting MEAN with Mongo, Express, Angular, and Node and have Simon Holmes on-line!
See this thread for details.
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
Author

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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Recover Mysql Dump file