Hi,
I just created an staging environment for my domain. I made a script copying files and db from production to staging. After copying I overwrite urls wordpress db. However, the themes settings are anyhow lost doing this.
Where are the theme settings stored? How can I maintain them copying from production to staging?
thx, I really appreciate your help!
Manu
I believe there is an “export and import” settings in the theme panel.
Hi,
The settings are stored as an wordpress option td_008 in your database.
You can try to import and export your theme settings from Theme Panel http://screencast.com/t/HXBNiyBvmAh
You will have there all your settings stored http://screencast.com/t/K2OktqggB0b8
You can save the theme settings in a text file and paste them back when you want and import them.
Hope this works
Thanks
I do know the import export function, and it works.
However I m copying production to staging once a day thus I’d like to automate the copying from production to staging through a script. My scripts deletes all tables in staging, copies them from the production database and then replaces the production domain through the staging domain. I make a full copy of the database however the td settings are not transferred. Why? How can I automate it?
Thx guys, I really appreciate your help!
Hi,
the theme settings are located in the wp_options table with an option name of “td_008”. It’s a single row with all the settings serialized in the option_value field: http://screencast.com/t/nm1ybaUH0
a sample select for our wp option:
SELECT * FROM YOUR_DATABASE.wp_options where option_name ="td_008";
Hi Radu,
What I do is move the tables from production to staging.
Than replace the domain urls with:
UPDATE wp_options SET option_value = REPLACE(option_value, ‘http://www.mydomain.de’, ‘http://staging.domain.de’);
The theme settings in td_008 are correct in the database until staging.mydomain.de is opend in the browser. On loading the staging page in the browser, the theme settings are deleted from the database. I’m not understanding why? And how to avoid this behaviour?
Could you please tell me how to copy them?
Thx, I really appreciate your help!
Probably this is related to php serialize function which has references to the length of a serialized string. changing www to staging changes the length, thus php isn’T able to deserialize it.
Wordpress describes the problem and solution here: http://codex.wordpress.org/Moving_WordPress
I gonna check tomorrow. Maybe the subdomain sta would be much easier than staging.
Hi,
You can give it a try. Let us know if you have any other theme related issues.
Thanks
Hey Lucian,
Checked it. Is working now probably. Using sta instead of staging as subdomain now.
Thx
