Support Forum

If you want to show a shortcode in forum post - use [ instead of [ as you write it so you can see the shortcode 😉

We use and recommend UK2 for hosting - get a month free

Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register sp_MemberList Members

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
exporting all plugin data to another site
2nd February 2020
10:38 pm
Avatar
Member
Members
Forum Posts: 44
Member Since:
27th November 2018
sp_UserOfflineSmall Offline

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.

3rd February 2020
7:57 am
Avatar
Admin
Forum Posts: 864
Member Since:
4th March 2015
sp_UserOfflineSmall Offline

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.

If you are finding the plugin useful, please subscribe to the app - it's free for your congregation to use and only £9.99pm for a church subscription - free int'l bank transfers with Revolut

4th February 2020
7:31 pm
Avatar
Member
Members
Forum Posts: 44
Member Since:
27th November 2018
sp_UserOfflineSmall Offline

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.

4th February 2020
7:39 pm
Avatar
Member
Members
Forum Posts: 44
Member Since:
27th November 2018
sp_UserOfflineSmall Offline

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.

13th February 2020
10:02 pm
Avatar
Admin
Forum Posts: 864
Member Since:
4th March 2015
sp_UserOfflineSmall Offline

you only need the latest backup file by the way!

If you are finding the plugin useful, please subscribe to the app - it's free for your congregation to use and only £9.99pm for a church subscription - free int'l bank transfers with Revolut

Forum Timezone: Europe/London

Most Users Ever Online: 101

Currently Online:
3 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Pastor Andres: 97

Rich Cox: 94

David Z.: 84

rrfranks: 55

Allen: 51

seanmcint: 49

Jon: 44

Gavin: 41

Janeen: 23

365sussex: 21

Member Stats:

Guest Posters: 44

Members: 408

Moderators: 0

Admins: 1

Forum Stats:

Groups: 5

Forums: 14

Topics: 567

Posts: 2112

Administrators: andymoyle: 864