Results 1 to 2 of 2
PhpMyadmin problem Forum: Web Hosting ForumReplies: 2
IIS, Xamp- Mysql Phpmyadmin did not work Forum: Web Hosting ForumReplies: 0
Using system, su, and a command with parameters... Forum: CGI Perl ForumReplies: 0
Script, logic or syntax wrong.....or have I got it all wrong Forum: PHP ForumReplies: 3
Hover command on a td Forum: CSS ForumReplies: 3
09-03-2006, 04:50 PM #1
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
09-04-2006, 08:28 PM #2
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.