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.
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.