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
import existing database
1st June 2017
4:49 am
Avatar
Member
Members
Forum Posts: 3
Member Since:
1st June 2017
sp_UserOfflineSmall Offline

Hello Andy,
Any way to import my database from a previous site to a new site?

Would sure save me a lot of time.

Thanks

1st June 2017
8:24 am
Avatar
Admin
Forum Posts: 867
Member Since:
4th March 2015
sp_UserOfflineSmall Offline

Sure, I'll knock up an importer plugin later today. It's not the sort of thing I would want to leave in the main plugin as you could wipe everything quite easily if someone nasty hacked you!

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

2nd June 2017
11:43 am
Avatar
Admin
Forum Posts: 867
Member Since:
4th March 2015
sp_UserOfflineSmall Offline

Here's a DB importer plugin. https://www.churchadminplugin.com/wp-content/uploads/2017/06/church-admin-importer.zip
It'll accept a gz compressed file of mysql statements and run a database query on each line. No checks are made, it will just do what you give it. So BE CAREFUL! I take no responsibility for data destruction - use at own risk.

Upload the church admin database backup and it will rewrite the tables (you can use it upload a gz compressed sql file)

Deactivate and delete after use!

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

19th June 2017
5:02 pm
Avatar
Member
Members
Forum Posts: 3
Member Since:
1st June 2017
sp_UserOfflineSmall Offline

Thanks again Andy,

Worked great when i finally got back to it.

LaughLaugh

10th June 2020
6:18 pm
Avatar
Andover, KS USA
Member
Members
Forum Posts: 57
Member Since:
22nd November 2017
sp_UserOfflineSmall Offline

Hi Andy! I have a complicated question. Basically the database for our website got corrupted...the backup that we had for our site was corrupted...so we ended up deleting our database and starting all over with a new site. I do have a backup of our Church Admin file, but when I tried to "Restore DB backup" the process runs, but there is no information in Church Admin at the end of the process. I am not a computer programmer, but it appears that it is looking for our old website database (which no longer exists). I even tried installing the importer mentioned above and it did not work as well. Is there any way to reinstall the "sql.gz" file that I have?

10th June 2020
6:21 pm
Avatar
Admin
Forum Posts: 867
Member Since:
4th March 2015
sp_UserOfflineSmall Offline

That's not complicated 😉
Send it over (support@ my domain above!). I'll need to know the new database name and the wordpress prefix (default is wp_). I'll fix it and send it back!

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

10th June 2020
6:40 pm
Avatar
Andover, KS USA
Member
Members
Forum Posts: 57
Member Since:
22nd November 2017
sp_UserOfflineSmall Offline

Thank you!!!! It is on its way to you now.

Forum Timezone: Europe/London

Most Users Ever Online: 101

Currently Online:
5 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Pastor Andres: 97

Rich Cox: 94

David Z.: 84

rrfranks: 57

seanmcint: 52

Allen: 51

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: 570

Posts: 2120

Administrators: andymoyle: 867