By kadrienne on
I accidently edited a page without realizing it was changing another page - they had different names in the navigation but the same node value. I have the database backed up from the previous day and a full restore of the database didn't work. Will I be able to retrieve the content that was there before on that page (node)?
It was node/30 that I edited but need the original content back.
How can I just restore that page that I edited, where would I find it in the database? Thank you for your help!!!
Comments
_
You can locate the content by browsing the db with something like phpmyadmin. Look in the node_revisions table for the nid of "30".
didn't have revisions on in content type
Would the node-revisions table still be there if I didn't have this setting checked off in the content type? Also, I inherited this site from a former developer and do not know what the phpmyadmin password is, it is encrypted in the settings.php file so I need to rely on the hosting tech support to be able to "peruse" the database. Also they would be looking through a backed up version of the database. HOw would I guide them to do that?
Thank you for your help!
_
I believe the node_revisions table will be there regardless of whether or not you've actually used revisions-- it will just have one 'revision' per node in that case.
As for how to guide your host-- sorry , there's not much i can tell you there. I would hope their 'technical' support would be able to help you and not the other way around. ;-)
Thank you
Thank you for your help, I will try that out and hopefully they can help me. I'll post back later.
once retrieved what table does it go in?
In the event they are able to get node/30 content, to what table does this data go into? If they are successful in finding it and putting it into the correct table, then I should immediately be able to see the previous content that was on that page right? Thank you so much in advance!
_
I most definitely would not let the hosting company, or anyone else for that matter, enter the node content directly into the database. I would just use that content to paste into a new node through the drupal db UI. Then just update any links that point to node/30 to point to the new node.
question about the content
So, if they go into the node_revisions table, then to "get the content" they can just copy what field and send that to me. I don't mind making a new node from the Drupal UI, but I need the content that was there before and I don't know where to tell them in the revisions_table or a backed-up database where to grab the content (field).
_
I would think you could just have them copy the body field for you
By the way, your Drupal
By the way, your Drupal database username and password in settings.php are not encrypted. If you mean your hosting account's password for accessing your databases in phpmyadmin, Drupal doesn't know that, and you need to ask your host to find it or to reset it and give you a new one.
it doesn't let me in
So, the password on the database is not the same as the password on the phpmyadmin? The hosting company said that if i reset the password it would affect my drupal pages since it is tied to that database. Are there in effect 2 passwords then? Thank you for the clarification. I am new to this.
If you take a look at your
If you take a look at your site's settings.php file, at the $db_url line, you will find a user name and user password specific for the database which Drupal is using. But this is not useful for phpmyadmin.
To see all your databases in phpmyadmin usually you need your hosting account's password. Rarely, on some hosts, you also need an additional phpmyadmin password.
makes sense
Thank you that makes complete sense. I found in the code the drupal db password, but do not know the phpadmin pw. it is not the same as my hosting account password for whatever reason. We inherited this site from a previous owner that was contracted with and now we are the subcontractor and they do not know the phpadmin pw, however, i can have the hosting company reset it, but they were the ones who said that it would affect my drupal pages and db.
Depending on your host
Depending on your host phpmyadmin can have a completely different password - the "root" user password can be reset by the tech staff and made known to you.