Wordpress Themes - WP Forum at BFA
Click here to register or to donate.
Auto self-registration is not available here - far too many spammers. This forum has many, many backlinks and because of that there is an intense desire among spammers to drop their links here.

Wordpress Themes - WP Forum at BFA » WordPress Themes » Atahualpa 3 Wordpress theme » Header configuration & styling »

How Do I Restore Just the Settings From Database


  #1  
Old Aug 1, 2011, 06:56 AM
crogers32
 
16 posts · Feb 2009
So the other day, while I was sleeping my site inexplicably lost all of its settings. I have a feeling that another admin accidentally updated the theme, but that is neither here nor there. I have a backup of the database, but it is a multi-user site and items have been added to the database since the mix up. My question is, is there a way that I can restore just the settings from the backup or do I have to restore the entire database. Sorry if this is a redundant question, I searched the forum but couldn't find this answer. Thanks in advance for any help.
  #2  
Old Aug 1, 2011, 07:24 AM
juggledad's Avatar
juggledad
 
23,686 posts · Mar 2009
OSX 10.11.5 WP 4.x Atahualpa(all) Safari, Firefox, Chrome
This might seem like a lot of work, but may be the safest thing.

create a new database and restore the backup to that. Then create a new wordpress in install in a subfolder or test site. use phpmyadmin to edit the 'siteurl' and 'home' rows of the wp-option table to point to the new location

Then you can login and just use the Atahualpa export to get all teh settings.
__________________
"Tell me and I forget, teach me and I may remember, involve me and I learn." - Benjamin Franklin
Juggledad | Forum Moderator/Support
  #3  
Old Aug 1, 2011, 07:37 AM
crogers32
 
16 posts · Feb 2009
Thanks for the reply. What if I don't have a recent theme settings export (I know, punching myself)? Are the settings before the reset saved in my database backup?
  #4  
Old Aug 1, 2011, 07:48 AM
juggledad's Avatar
juggledad
 
23,686 posts · Mar 2009
OSX 10.11.5 WP 4.x Atahualpa(all) Safari, Firefox, Chrome
they should be. The atahualpa settings are stored in the wordpress database - in the wp-options table in the row 'bfa_ata4'
__________________
"Tell me and I forget, teach me and I may remember, involve me and I learn." - Benjamin Franklin
Juggledad | Forum Moderator/Support
  #5  
Old Aug 1, 2011, 07:49 AM
crogers32
 
16 posts · Feb 2009
perfect, thanks for your help.
  #6  
Old Aug 4, 2011, 06:39 AM
crogers32
 
16 posts · Feb 2009
So I restored the data from a backup of just that row, but the theme did not change back to the way it was. When I go back to the theme options page in the backend, none of my CSS inserts are there. Am I missing a step or am I just screwed?
  #7  
Old Aug 4, 2011, 06:47 AM
juggledad's Avatar
juggledad
 
23,686 posts · Mar 2009
OSX 10.11.5 WP 4.x Atahualpa(all) Safari, Firefox, Chrome
How did you restore that one row? Export/import it using phpMyAdmin?
__________________
"Tell me and I forget, teach me and I may remember, involve me and I learn." - Benjamin Franklin
Juggledad | Forum Moderator/Support
  #8  
Old Aug 4, 2011, 06:55 AM
crogers32
 
16 posts · Feb 2009
I just copy and pasted the option_value from the value in the backup. Clearly that is not the proper way to do it because when I save it it reverts back to the value I don't want rather than the one from the backup. I'm kind of a phpmyadmin newb if you hadn't guessed.
  #9  
Old Aug 4, 2011, 07:38 AM
juggledad's Avatar
juggledad
 
23,686 posts · Mar 2009
OSX 10.11.5 WP 4.x Atahualpa(all) Safari, Firefox, Chrome
This is why I suggested you create a new wordpress install and use the theme option to do the export.

You can do an export/import, but trying to explain all the steps is a little beyond the forum

This is why everyone should have a 'play' site that you can mess up without any issue. In this case you could export the original site, import it into the play site (changing the URL) and then do the export
__________________
"Tell me and I forget, teach me and I may remember, involve me and I learn." - Benjamin Franklin
Juggledad | Forum Moderator/Support
  #10  
Old Aug 4, 2011, 08:02 AM
crogers32
 
16 posts · Feb 2009
Thanks. Your original solution makes sense to me now.
  #11  
Old Aug 4, 2011, 09:28 AM
crogers32
 
16 posts · Feb 2009
Thank you again for all of your help. I have one more question (I think). I have installed wordpress on my local machine using MAMP. Everything works perfectly until I import the backup into the database on the local machine. Once I do this and open the backend of the local installation I am redirected to the site out on the web, so then I am not able to access the old settings. Is there something in the backup that is causing this redirect?
  #12  
Old Aug 4, 2011, 10:22 AM
juggledad's Avatar
juggledad
 
23,686 posts · Mar 2009
OSX 10.11.5 WP 4.x Atahualpa(all) Safari, Firefox, Chrome
Yes, in the wp-options table there are two rows that need to be changed to use the mamp address.
For example it mint be a 192.... Address so you have to change the wordpress URL and home rows to use that address.

One shows on the first page when you browse the wp-options ta le, and the other is on the second page.
__________________
"Tell me and I forget, teach me and I may remember, involve me and I learn." - Benjamin Franklin
Juggledad | Forum Moderator/Support

Bookmarks

Tags
database, restore, settings

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Database restored = all settings gone Garwen New Versions, & Updating 13 Jun 16, 2011 12:36 PM
Server crashed, need to restore settings... willwork Atahualpa 3 Wordpress theme 3 Mar 24, 2011 02:34 PM
[SOLVED] Restore atahualpa settings files guvenp New Versions, & Updating 2 Dec 12, 2010 02:43 AM
How do I restore my Website Worldsman Forum How-To 1 Mar 24, 2010 06:59 PM
[SOLVED] WP backups - will a restore also restore Atahualpa settings? runbei New Versions, & Updating 2 Feb 26, 2010 04:41 PM


All times are GMT -6. The time now is 04:42 PM.


Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.