1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Accidentally deleted Mysql database of wordpress, [HELP]

Discussion in 'Web Hosting' started by Mc Bruce Lee, Jan 25, 2016.

  1. Mc Bruce Lee

    Mc Bruce Lee Junior Member

    Joined:
    Feb 5, 2013
    Messages:
    166
    Likes Received:
    16
    Hello, So I accidentally deleted mysql database of my wordpress, but My site is still running, I can access all the file in the filezilla but I just can't access the admin area of wordpress to make any changes.


    I did made a back up few months ago, I don't want to back up the whole site from the older version because I have much less content on my back up . Is it possible to copy ONLY the mysql data from the old version of wordpress?


    So how can I recover my database without losing any content. thanks.
     
  2. keadams26

    keadams26 Regular Member

    Joined:
    May 9, 2009
    Messages:
    469
    Likes Received:
    274
    Home Page:
    Try contacting your host and see if they have a backup. Any hosting company that's halfway decent performs automatic backups (assuming yours wasn't too big). Anyway, start by asking your hosting company.
     
    • Thanks Thanks x 1
  3. Asif WILSON Khan

    Asif WILSON Khan Executive VIP Jr. VIP

    Joined:
    Nov 10, 2012
    Messages:
    12,171
    Likes Received:
    33,768
    Gender:
    Male
    Occupation:
    Fun Lovin' Criminal
    Location:
    London
    Home Page:
    If you deleted the database then I don't think the site would still be functional unless you are using some form of caching maybe.
    The first thing you should do is contact your host and see when they last did a backup, they will probably have a more up to date backup.
    You should also use Filezilla and backup everything on the server locally before you do anything else.
     
  4. qrazy

    qrazy Senior Member

    Joined:
    Mar 19, 2012
    Messages:
    1,115
    Likes Received:
    1,725
    Location:
    Banana Republic
    You can try to use MySql recovery options if your database was configured to take back-ups. Also check with your host to see if they do auto backup of databases.
     
  5. ioZoom

    ioZoom Registered Member

    Joined:
    Dec 3, 2015
    Messages:
    63
    Likes Received:
    8
    Occupation:
    CEO of IO Zoom, a VPS hosting company
    Location:
    Houston, Texas
    Home Page:
    If you are on a shared hosting platform then your hosting provider should (99% of the time) have a backup for you so ask them to restore from the latest backup but make sure you ask for the date of the backup first.
     
  6. alexa45

    alexa45 Newbie

    Joined:
    Dec 8, 2015
    Messages:
    16
    Likes Received:
    0
    Ohm, After deleting it's still accessible through website and it's another good news so there is somewhere the database is still available. Hosting provider should know the thing, Just let them know. Following to know the last update.
     
  7. anikilator

    anikilator Newbie

    Joined:
    Dec 26, 2012
    Messages:
    16
    Likes Received:
    1
    What they said to you. Your hosting provider should provide you with a more recent backup
     
  8. bermanHost

    bermanHost Regular Member

    Joined:
    Aug 19, 2014
    Messages:
    478
    Likes Received:
    40
    Shared hosting company(decent ones) keep backups in three forms monthly, weekly and daily. You can ask your hosting provider whether they have the daily backup or not and they have it you can ask them to restore it for you.
     
  9. ncv4a

    ncv4a Newbie

    Joined:
    Jan 26, 2016
    Messages:
    7
    Likes Received:
    2
    Gender:
    Male
    hi, please send me your skype, I cannot reply you via message because I sill haven't got enough post. ( re: pinterest account)