View previous topic :: View next topic |
Author |
Message |
Waffa -
Joined: 03 Sep 2006 Posts: 1
|
Posted: Sun Sep 03, 2006 11:03 pm Post subject: Wrong command in PHPmyAdmin SQL query, any way to undo? |
|
|
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 |
|
Back to top |
|
 |
bprsk8r4272 -
Joined: 07 Mar 2006 Posts: 124 Location: Rochester, NY
|
|
Back to top |
|
 |
SpippoiliaCak -
Joined: 01 Mar 2011 Posts: 2 Location: Ireland
|
Posted: Wed May 11, 2011 9:35 pm Post subject: Wrong command in PHPmyAdmin SQL query any way to undo |
|
|
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 |
|
Back to top |
 |
 |
Toasty -
Joined: 21 Feb 2008 Posts: 296 Location: Chicago, IL
|
Posted: Tue May 17, 2011 10:19 pm Post subject: |
|
|
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 |
|
Back to top |
|
 |
|