Pages deleted according to the log, but I haven't deleted any pages...
Permalink
Okay so I just went to my site (zphiboklahoma.org) and all of the announcements have been deleted. The thing is, I haven't deleted any pages. I haven't even gone to the sitemap to have deleted anything. The last thing I did was export some pro-forms results. Now here's the truly weird part. The deleted pages aren't in the "trash can". I'm checking now to see what the last backup is. Any help/ideas of where that data got dumped to would be great!
That's just it, I'm the only one logged from MY IP even. The only thing that I did today in that site was to export a proform submission so I'm stumped AND I just migrated servers a couple of months ago and didn't set my backup routine on the new server so now I have to pay media temple $79 for the restoration. I just I should just be grateful there is one.
Ouch! That sounds like a lot just to restore a database backup!
Several months to setup a cron job sounds like an expensive lesson :-P
I'm assuming you checked the database to make sure it wasn't corrupted.
Several months to setup a cron job sounds like an expensive lesson :-P
I'm assuming you checked the database to make sure it wasn't corrupted.
IKR! I did log into the database. Not sure how to tell if it's corrupted, but I did get some kind of javascript error in phpmyadmin. I assumed that was IN phpmyadmin and had no bearing on this issue. Good suggestion - I'll check it out!
Thanks!
Thanks!
Make a backup of your database (of course!)
PHPMyAdmin - Repair & Optimize
To optimize tables, do the same except select Optimize Table
See attached image.
I've also attached a tools script that you can save as /tools/optimize.php
You can run this as Super Admin on a regular basis (probably not best when your site is busy) like so:
Hope that helps!
John
PHPMyAdmin - Repair & Optimize
1. Open the database to repair 2. On the right-hand frame scroll to the bottom of the tables 3. Click on Check All link 4. In the drop-down on the right select Repair Table
See attached image.
I've also attached a tools script that you can save as /tools/optimize.php
You can run this as Super Admin on a regular basis (probably not best when your site is busy) like so:
http://yoursite.com/index.php/tools/optimize (note no .php or access will be denied).
John
BTW, none of these will help if the records were actually deleted :(
:-) I tried it...They were deleted. Somehow there was a data dump, otherwise they would be in the trash and not completely missing.
Thanks John!
Thanks John!
I've never used ProForm, but I'd probably take a look at the source code checking for database delete queries.
Hopefully you have a recent backup. You should definitely setup a daily database backup on your host.
Sorry I don't have more help to offer with just the information given,
John