How to restore from .sql backup file

  • fabthi

    (@fabthi)


    9 years, 3 months 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

    9 years, 3 months ago

    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)

    9 years, 3 months ago

    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 9 years, 3 months ago by fabthi.
    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    9 years, 3 months ago

    Use phpmyadmin, not the “actions” dropdown.

    Thread Starter fabthi

    (@fabthi)

    9 years, 3 months ago

    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 9 years, 3 months ago by fabthi.
    • This reply was modified 9 years, 3 months ago by fabthi.
    • This reply was modified 9 years, 3 months ago by fabthi.
    Thread Starter fabthi

    (@fabthi)

    9 years, 3 months ago

    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 9 years, 3 months 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.