Reverting MySQL to earlier state? PLEASE HELP ME!

Discussion in 'MySQL' started by bnbn1382, Sep 2, 2009.

  1. #1
    Yes, I had been recently hacked, and I want to revert the MySQL database.
    They someone deleted something, and my IPB forum isnt showing any forums.
    Although it says it does and posts do exist only by the specific link, i cannot create nor see from main page.

    www.forums.u-no.info

    ---

    I searched google, and MySQL said it is possible to restore to earlier state, and asked my Lunarpages Hostmaster.

    They said they will charge 75 dollars for this, and I do not believe this should be a 75 dollar charge. Infact, I do not have any money so I cannot do it.
    My site had suddenly become a big forum, and I need it back up quickly as I can.
    I lost about 4/5 of the registerers a day, and I cannot lose more. I lost about 80% of daily visitors also for getting hacked and not bringing the site up for 5 days.

    When I asked Lunarpages NOT THE WHOLE RESTORE, but just MySQL, they said it is going to be hard. I think it is pretty easy, and or I can do it myself. Is there any way that I can do it myself or they have to do it?
    I have all mysql control. If there is an example code I can run to revert or etc. Please tell me.
     
    bnbn1382, Sep 2, 2009 IP
  2. SmallPotatoes

    SmallPotatoes Peon

    Messages:
    1,321
    Likes Received:
    41
    Best Answers:
    0
    Trophy Points:
    0
    #2
    You need an old database dump, or the old versions of the table storage files, which I assume you don't have in your possession. Presumably the reason Lunarpages is charging you is because someone has to retrieve them from the backup, copy them to the server in question, shut down MySQL, move the new files into place, start up MySQL, and repair the tables. $75 is a bargain. I'd charge $500 or more for something like that.
     
    SmallPotatoes, Sep 2, 2009 IP
  3. bnbn1382

    bnbn1382 Peon

    Messages:
    134
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    So there is no way for me to do it?
    or do it free?

    I really need it up :(
     
    Last edited: Sep 2, 2009
    bnbn1382, Sep 2, 2009 IP
  4. SmallPotatoes

    SmallPotatoes Peon

    Messages:
    1,321
    Likes Received:
    41
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I don't think you can do it on your own unless you have been making database backups; you simply don't have the old data.
     
    SmallPotatoes, Sep 2, 2009 IP
  5. nyxano

    nyxano Peon

    Messages:
    417
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    0
    #5
    The error message that is being displayed is:
    Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 16384 bytes) in /home/youkn0/public_html/forums/admin/applications/forums/sources/classes/forums/class_forums.php on line 1005

    Do a Google search for "Allowed memory size of 33554432 bytes exhausted" and you may find the answer. Also ask LunarPages what it means. Maybe someone hacked your index.php file or php.ini file and messed with it. I don't think it has anything to do with the MySQL database itself.
     
    nyxano, Sep 3, 2009 IP