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

 
Post new topic   Reply to topic    Aprelium Forum Index -> Databases
View previous topic :: View next topic  
Author Message
Waffa
-


Joined: 03 Sep 2006
Posts: 1

PostPosted: Sun Sep 03, 2006 11:03 pm    Post subject: Wrong command in PHPmyAdmin SQL query, any way to undo? Reply with quote

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 View user's profile Send private message
bprsk8r4272
-


Joined: 07 Mar 2006
Posts: 124
Location: Rochester, NY

PostPosted: Mon Sep 04, 2006 12:06 am    Post subject: Reply with quote

this is something you should be asking phpBB there website is http://www.phpBB.com/phpBB/index.php
_________________
Back to top View user's profile Send private message Send e-mail Visit poster's website AIM Address MSN Messenger
SpippoiliaCak
-


Joined: 01 Mar 2011
Posts: 2
Location: Ireland

PostPosted: Wed May 11, 2011 9:35 pm    Post subject: Wrong command in PHPmyAdmin SQL query any way to undo Reply with quote

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 View user's profile Send private message Send e-mail ICQ Number
Toasty
-


Joined: 21 Feb 2008
Posts: 298
Location: Chicago, IL

PostPosted: Tue May 17, 2011 10:19 pm    Post subject: Reply with quote

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 View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> Databases All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
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


Powered by phpBB phpBB Group