Re: Restoring failed due to Unexpected Error

2011-11-22 Thread Reindl Harald
yes - take your fingers away and go to a datarecovery company if it is not too late because you are damaging the disk more and more, NOW it is too late for backups! Am 22.11.2011 06:03, schrieb Adarsh Sharma: > Any comments to get the data back know. > My hard disk crashes about 90% but when I sta

Re: Restoring failed due to Unexpected Error

2011-11-21 Thread Adarsh Sharma
Any comments to get the data back know. My hard disk crashes about 90% but when I start any kind of backup or select output into a file from 40GB table , it stops after 30 GB & then stalled because there are bad sectors to read. Is it possible to get the remaining data ( 10GB) , as all backups

Re: Restoring failed due to Unexpected Error

2011-11-18 Thread Reindl Harald
Am 18.11.2011 14:18, schrieb Johan De Meersman: > - Original Message - >> From: "Reindl Harald" >> >> but anyways, the message sounds like a damaged compressed file > > Looks more like he's got an HTML file instead of an SQL file, to me. > > Have a look inside the file, maybe the HTML

Re: Restoring failed due to Unexpected Error

2011-11-18 Thread Johan De Meersman
- Original Message - > From: "Reindl Harald" > > but anyways, the message sounds like a damaged compressed file Looks more like he's got an HTML file instead of an SQL file, to me. Have a look inside the file, maybe the HTML is just a wrapper or something. How was the backup taken ? -

Re: Restoring failed due to Unexpected Error

2011-11-18 Thread Reindl Harald
Am 18.11.2011 12:41, schrieb Adarsh Sharma: > But when I restore the data below error exists :- > > [root@test1 hdd2-1]# gunzip < source.sql.gz | mysql test > > gunzip: stdin: unexpected end of file > ERROR 1064 (42000) at line 30309: You have an error in your SQL syntax; check > the manual th

Restoring failed due to Unexpected Error

2011-11-18 Thread Adarsh Sharma
Dear all, Today i need to restore the backup of a 40GB table in a new system. I create a script that takes the backup in compressed format ( 2.3 GB ).The existing hard disk crashes & I need to restore my data. But when I restore the data below error exists :- [root@test1 hdd2-1]# gunzip < sou