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: 298 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. _________________ Audit the secure configuration of your server headers! |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|