3 years, 6 months ago imteddyParticipant
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 http://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?
3 years, 6 months ago RucoKeymaster
I suggest you to use WP migrate DB plugin to replace all the links in DB.
We use this plugin when we move the site to other host, domain.
You must be logged in to reply to this topic.