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

[Waffa]

Hello

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

[bprsk8r4272]

this is something you should be asking phpBB there website is http://www.phpBB.com/phpBB/index.php
_________________

[SpippoiliaCak]

Just sort it by ID then limit it to just 1 row. So on the end of the SQL query you would add LIMIT 0,1

[Toasty]

The reason you never got an error is because that's a valid SQL command in valid syntax, thus there was no error state. It was a user-error, not a machine error.

The only way you're going to fix that is backing up from a database dump, but you should really consider dumping PHPBB, it's a waste of code.
_________________
Security Blog