Accidently deleted a SQL database, now i cant see my site or get in to admin.

Discussion in 'MySQL' started by elroy81, Oct 6, 2008.

  1. #1
    elroy81, Oct 6, 2008 IP
  2. deluxdon

    deluxdon Catch Me If You Can...!!!™ Staff

    Messages:
    25,481
    Likes Received:
    1,943
    Best Answers:
    32
    Trophy Points:
    480
    #2
    Do you have backup of your SQL DB in your pc :confused: as its always advisable to take backup of your DB time to time.

    DON.
     
    deluxdon, Oct 6, 2008 IP
  3. elroy81

    elroy81 Active Member

    Messages:
    218
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    71
    #3
    Ive got backups of the other 4 database's but not the one i deleted. :(

    Is reinstalling wordpress the only way to go?
     
    elroy81, Oct 6, 2008 IP
  4. cougarxs

    cougarxs Peon

    Messages:
    662
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #4
    yes mate sadly your back to square one..

    maybe contact your hosting company if you have lost a lot of data / posts or articles, They also do big backups but may get annoyed sorting through them to pull out your site, my friend did the same, but was very valuable data so he was charged $20- to recover it.
     
    cougarxs, Oct 6, 2008 IP
  5. joint2

    joint2 Banned

    Messages:
    107
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    thats a better idea contact your hosting!!
     
    joint2, Oct 9, 2008 IP
  6. BuzzyDev

    BuzzyDev Guest

    Messages:
    47
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Hi,

    First contact your hosting company to see if they made regular backups. In normal conditions if you are working with mySQL, there exist binary logs where all transactions are stored in case of accidents for recovery.
    You may find useful reading this: http://community.eapps.com/showthread.php?p=351#post351 where I indicate steps to do in those cases.
    Note: this will help to recover data, not the definition of the database itself (you will have to recreate the tables, views, constraints, etc., etc.)

    Good luck
     
    BuzzyDev, Oct 9, 2008 IP
  7. 365seo

    365seo Peon

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    whos your host... you can usually get a backup if they are a decent host.
     
    365seo, Oct 10, 2008 IP
  8. captaincore

    captaincore Peon

    Messages:
    98
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    your hosting company probably takes regular backups of your db.
     
    captaincore, Oct 10, 2008 IP
  9. Scriptona

    Scriptona Notable Member

    Messages:
    4,957
    Likes Received:
    265
    Best Answers:
    0
    Trophy Points:
    280
    #9
    ask your hosting to restore your backup for you. they should be having daily/weekly backups.
     
    Scriptona, Oct 10, 2008 IP