166 users online (0 members and 166 guests)  

  Results 1 to 2 of 2


  1. PhpMyadmin problem    Forum: Web Hosting Forum
    Replies: 2
  2. IIS, Xamp- Mysql Phpmyadmin did not work    Forum: Web Hosting Forum
    Replies: 0
  3. Replies: 0
  4. Replies: 3
  5. Hover command on a td    Forum: CSS Forum
    Replies: 3
  1. #1
    Waffa's Avatar
    New User

    Join Date
    Sep 2006

    Wrong command in PHPmyAdmin SQL query, any way to undo?


    I really hope someone can help me.

    I did something stupid in PHPmyAdmin SQL query, to delete spamBot posts by ip from viper guestbook, i used query like that:

    delete from phpbb__ENTRY where IP = 'ip1' OR 'ip2'

    but i should have run:

    delete from phpbb__ENTRY where IP='ip1' or IP='ip2'

    - instead of giving a error message, phphmyadmin deleted ALL my posts!

    So.. but if i look at Table: VGB_ENTRY, i see:

    Space usageType Usage
    Data 13,444 KB
    Index 82,944 Bytes
    Overhead 13,444 KB
    Effective 82,944 Bytes
    Total 13,525 KB

    VGB_ENTRY (records)0 MyISAM (size)13.2 MB 13,444 KB

    - so the posts are somewhere still i think... 13MB .. is there a way to recover it? Undo it?

    I use virtual server, so i do not have access to the full server, just the cPanel

    Maybe some option i can save it to my HD and then work on it.. no idea what to do

    PHP version 4.4.0
    MySQL version 4.0.27-standard
    cPanel Build 10.8.2-RELEASE 119
    Kernel version: 2.4.21-37.0.1.ELsmp

  2. #2
    uthus's Avatar
    Senior Member

    Join Date
    Feb 2006
    Ft Hood

    Re: Wrong command in PHPmyAdmin SQL query, any way to undo?

    ask your host if they keep backups of your db. i know that if i delete something, it's gone. i don't back up. i'm a bad, bad boy.


Tags for this Thread