Hi,

I have imported dummy data and worked on localhost (development machine).

I exported a SQL dump from phpmyadmin and replaced all local url with production url as usual.

When I imported it from production server, I don’t see any Specular theme shape nor settings.

However, if I import without URL change, at least I can see Specular theme feeling (all images, css, js from my local machine as HTML source has https://localhost/…)

This happens even when I moved to different develop machine.. (Of course, I checked wp-config.php, .htaccess, etc)

I also tried importing SQL file that didn’t have any changes, and changed from server side using below query but no luck.

UPDATE wpnp_posts SET post_content = REPLACE(post_content, ‘localhost/mysite’, ‘www. mysite.com’);
UPDATE wpnp_posts SET guid = REPLACE(guid, ‘localhost/mysite’, ‘www. mysite.com’);
UPDATE wpnp_postmeta SET meta_value = REPLACE(meta_value, ‘localhost/mysite’, ‘www. mysite.com’);
UPDATE wpnp_options SET option_value = REPLACE(option_value, ‘localhost/mysite’, ‘www. mysite.com’);

I found one solution that a bit annoys..

• import as ‘localhost’ (development setting)
• re-setup Specular setting (logo,colours, header setting, etc) from WP Admin page
• Re-select all images manually

Is there any way to deploy site easily?

Thanks…