Data wrongly deleted from mysql table. How to recover?

Discussion in 'MySQL' started by hope2life, Oct 16, 2009.

  1. #1
    Hi,
    I am running a directory. I have a table in mysql database. I wrongly deleted all the entries in this table and as result all data from my directory disappeared. Is it possible to recover the data deleted from mysql table? I asked godaddy but they are asking for $150 which is too much for me.
     
    hope2life, Oct 16, 2009 IP
  2. chisara

    chisara Peon

    Messages:
    141
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Your only option is to restore from backup.
    If you have no backup and left it to your hoster then you have to pay the 150$ restore fee, assuming the hoster makes backups.

    Keep in mind most backups are only retained during a short period of time.
     
    chisara, Oct 16, 2009 IP
  3. hope2life

    hope2life Active Member

    Messages:
    1,641
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    90
    #3
    Hi,
    Thanks! for your reply. I didnt take any backup. And I cannot afford $150 .So lets the data go. I will upload new data again.
     
    hope2life, Oct 16, 2009 IP
  4. phones2me

    phones2me Peon

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    ALWAYS backup your data - just for this sort of thing

    (isnt hindsight wonderful)
     
    phones2me, Oct 16, 2009 IP