Flash Sale for Premium Subscriptions

50% off annual premium licence subscription.

Get 50%off now

import existing database

About Support Installing Church Admin import existing database

  • This topic is empty.
Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #2730
    Avatar for rbinghamrbingham
    Member

    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

    #3764
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    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!

    #3767
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    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!

    #3773
    Avatar for rbinghamrbingham
    Member

    Thanks again Andy,

    Worked great when i finally got back to it.

    LaughLaugh

    #4641
    Avatar for rrfranksrrfranks
    Participant

    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?

    #4642
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    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!

    #4643
    Avatar for rrfranksrrfranks
    Participant

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

Viewing 7 posts - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.