How to restore from .sql backup file

  • fabthi

    (@fabthi)


    8 years ago

    Hi everybody
    my site got malware (thanks Godaddy) and I might need to use the backup file to try to restore but I don’t know how to do so.
    It’s a .sql file (only 603kb) I periodically receive on my email account.
    thanks

    Fabio

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Open your GoDaddy control panel and find the phpmyadmin application. Login to that to access your WordPress database.

    1) Export the current content of the database (just in case).

    2) Import the backup from your older .sql file

    As GoDaddy may have changed stuff since I last looked, you may want to confirm this with GoDaddy tech support.

    Thread Starter fabthi

    (@fabthi)

    Hi Steve
    thanks for your help!

    This is what I get when I am in my databases Management, as you see there’s not a download option but a Backup option which creates a backup copy which will be saved in this location:/_db_backups
    Should I then delete the actual Database using the Delete command and later add with “Restore” the backup file I received on my email?

    • This reply was modified 8 years ago by fabthi.
    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Use phpmyadmin, not the “actions” dropdown.

    Thread Starter fabthi

    (@fabthi)

    Phew, that’s a bit too much for myself, I don’t really know where to start
    https://s12.postimg.org/ydvcehepp/Schermata_2017_03_10_alle_17_19_58.png

    • This reply was modified 8 years ago by fabthi.
    • This reply was modified 8 years ago by fabthi.
    • This reply was modified 8 years ago by fabthi.
    Thread Starter fabthi

    (@fabthi)

    Hi Steve
    I found a GoDaddy support page on how to Import SQL files into MySQL databases, this one
    Only I’m not sure if this procedure will substitute the old corrupted database with the backup copy I will import.

    • This reply was modified 8 years ago by fabthi.
Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘How to restore from .sql backup file’ is closed to new replies.