- This topic is empty.
-
Posts
-
I am rebuilding the church website on another domain before I migrate it over to the actual domain. I would like to have everything working before I move it and take it live.
I know it’s possible to export and import a CSV of the people list, but is it possible to export and then import ALL the data, including ministries and calendar, etc.? Thanks.
Click on Church Admin>Settings>Refresh DB and download the latest DB backup. As long as your WordPress db prefix is the same – you can restore it on the new site.
But things like images may be wrong as they stored as attachment_id in the database tables and unless you have copied the WordPress tables (posts and postmeta) that could go wrong.What I normally do is go into PHPMyAdmin – your hosting company will provide that via your control panel. I export the whole database.
Then I load it into the new location. Then I do these three queries to relocate the site to the new URL…
Change site url
UPDATE wp_options SET option_value = replace(option_value, ‘http://www.oldsiteurl.com’, ‘http://www.newsiteurl.com’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;
Change url in content
UPDATE wp_posts SET post_content = REPLACE (post_content, ‘http://www.oldsiteurl.com’, ‘http://www.newsiteurl.com’);
UPDATE wp_postmeta SET meta_value = REPLACE (meta_value, ‘http://www.oldsiteurl.com’,’http://www.newsiteurl.com’);If you have the APP – let me know URL changes or that will stop working.
Thanks very much, I will work on this today. We do have the app, but our URL is not changing—I just want everything working on a staging site so the elders can approve it, then I will migrate it back to the actual URL.
I use All-in-One WP Migration to migrate sites, and so far it’s worked flawlessly as far as changing urls throughout and such. So I’m hoping it will work in this case when I migrate back.
I don’t see any way to download the backup files all at once. Do I need to do those individually?
I’ve decided it will be much simpler just to get the new site approved and moved over without the admin stuff working, THEN restore DB backup into the same URL I copied from.
- You must be logged in to reply to this topic.
