innonpeaks
Member
Posted 1 month ago #
The only thing I did was delete a couple of users and poof! All of a sudden all my pages have been deleted from Wordpress. My site is kerfluey, my boss is going to kill me. I have no idea where they went or how they disappeared. Honestly I haven't done anything else! Would have deleting those users nuked my pages?
(The pages being referred to are the pages under the Pages section, not the themes section, those seem to be intact)
Is there any way to restore the site to the way it was 2 days ago?
HEEEEEELLLPPPP!!!!!
Did you delete the users who had created those pages and, if so, when you deleted them, did you leave the option "What should be done with posts and links owned by this user?" as "Delete all posts and links."
If so, you'll need to dig out a database backup and restore from that.
innonpeaks
Member
Posted 1 month ago #
It is possible that the users that were deleted may have created some of the pages. I don't rmember that prompt but I may have gotten it. THough I would have thought it referred to posts as in blog posts, not page authoring.
Anyway, completely unsure how to restore from a backup...?
You definitely got the prompt. There's no way to nuke a user and NOT get that prompt. But I can see skimming it and not noticing that, in this ONE instance, posts = posts AND pages. Which ... yeah. Bad wording.
Anyhow. Do you make SQL backups of your database?
innonpeaks
Member
Posted 1 month ago #
I just called the host company and they said they only backup their mySQL from yesterday, but I made the deletions yesterday so I don't know. Is there a possible function in phpMyAdmin that might be able to restore it?
If there is a viable backup, will restoring it in the database automatically launch the pages?
IF you can get a backup, you can restore it. BUT. If you've made ANY other changes, you don't want to do this, since it'll wipe out those changes.
Ask your host for a copy of your database's backup.
In the meantime, is there a chance these pages were picked up by Google? If so, you can at least scrape the data and re-create them.
innonpeaks
Member
Posted 1 month ago #
The host company is going to do a restore, but again, it's a 24 hour restore so I don't know if it will work since I made the changes yesterday.
Google has the pages cached from the 9th but I don't know how that will help, I mean I can get the data but I didn't create these pages, so I don't know the heirarchy, the naming structure nothing....
Oh my god I am going to get fired.
Google has the pages cached from the 9th but I don't know how that will help, I mean I can get the data but I didn't create these pages, so I don't know the heirarchy, the naming structure nothing....
Sure you do :)
It's WordPress and Google so you know the following:
* The URL it's cached as.
* The Content of the page
All you have to do is make a new page with the right URL and put in the content google cached.
Job, saved.
Check out http://codex.wordpress.org/Pages for more info on how pages work.
innonpeaks
Member
Posted 1 month ago #
That's hopeful, but being pretty new (obviously) to Wordpress, I don't understand as the site seems to be creating dynamic pages. FOr instance if I look at one cached page it shows a URL as
http://www.innonpeaks.com/?page_id=334
How would I name the page that or direct the link to the right place? Oh man, I am twisting this all around aren't I?
So even if I scrape the basic content from the page there is no indication that the links and everything will work correctly is there?
And I know if I want to do things with text and whatnot that you don't use traditional html or php tags, so will that mess up the page won't it?
innonpeaks
Member
Posted 1 month ago #
The Host company says it has cached pages from a while ago as well. IS there any way to reverse-engineer this? Like use the cached pages from the host company to recreate a new DB picture?
Ugh. If you were using pretty permalinks, it'd've worked (I've done it before).
For that, your only hope is the db restore since, as you mentioned, you're new at this, and SQL hacking isn't difficult, but if you screw it up, it's very bad.
innonpeaks
Member
Posted 1 month ago #
Wouldn't WOrdpress be backing this stuff up as well somewhere..?
Wouldn't the page caches from the host company help out somehow?
No, WordPress itself doesn't perform backups.
All your data is in the database. When you delete data from the database (which is what you did), you have to restore the database to get it back.
innonpeaks
Member
Posted 1 month ago #
YErg. Do you know anything about restoring the database via phpMyAdmin, and whether there is a function of restore?
http://wordpress.org/search/phpmyadmin
take a look at the top 4 or so search results.
innonpeaks
Member
Posted 1 month ago #
Thanks for that, but all those solutions are based on having a file on your computer as a backup. WHich of course we don't have. Is there anyway that the database itself keeps a record of how it used to look so we can revert to that?
Is this even in the realm of the remotely possible?
Is there anyway that the database itself keeps a record of how it used to look so we can revert to that?
NO.
if you have an excel sheet with data in it, and you delete the data - It's (the data) gone, unless you have a backup of the original excel sheet WITH the data.
There isnt any difference here.
innonpeaks
Member
Posted 1 month ago #
Sweet! I am dead.
Thanks for the help everyone. It looks like I am going to have to scrape content and child pages from the cached pages on google, and then rebuild the pages, then relink all the links and then make sure all the SEO is where it's supposed to be and then hopefully it will look like it used to and function like it used to...
While you're at it, you may as well try and flip your site to Pretty Permalinks. It will help SEO.
http://codex.wordpress.org/Using_Permalinks
