Recovery of data from Database

  • Question,
    This weekend all of a sudden at 2 or 3 am my web site started saying the server found no site.

    All users got was a blank page saying the Apachie server could not find anything on port 80.

    I figured I got hacked and I do a monthly backup of the entire server so I just yanked the hard drive out and pulled the backup.tgz off the hard drive.

    My question is, once I restore my entire turnkey wordpress site as it was 3 weeks ago. How do I then extract the most recent posts out of the database.

    I looked around and most help walk throughts are about backup and restore from within wordpress but I need to pull it out of the actual MySQL database it self I guess at this point.

    Or am I just SOL and have lost the last few weeks of data.

Viewing 4 replies - 1 through 4 (of 4 total)

  • I think the best you can do is restore your site to where it was 3 weeks ago (ie the time of the last backup).

    Thread Starter FrakAdmin

    (@frakadmin)

    K, Working on that at the moment.

    This time im going to run it as a virtualbox VM and back that up nightly..

    Damn hackers.

    Thread Starter FrakAdmin

    (@frakadmin)

    I have opened my backup and my hard drive and running a file by file compairson but im not accustomed to linux.

    The main thing I noticed was my .htaccess file shows my bulletproof mod in maintenance mode.
    Backup file:
    # BULLETPROOF .46.4 >>>>>>> SECURE .HTACCESS

    Current file from hard drive:
    # BULLETPROOF .46.4 MAINTENANCE .HTACCESS

    I didnt do this, I wonder if the mod is just glitched. I will see if I can figure out how to unbullet proof it.

    Still does not explain the apachie see’s nothing page as bulletproof mode normally puts up a dummy page.

    Thread Starter FrakAdmin

    (@frakadmin)

    Also I located my mysql database and have a MSQL Workbench up and running. Anyone ever reverse enginnered a MySQL database from file format?

    LOL I betting im swimming on my own with sharks here. but its fun atm so why not.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Recovery of data from Database’ is closed to new replies.