Okay
  Public Ticket #3666049
tables to migrate
Closed

Comments

  •  11
    Peter started the conversation

    hi there

    we are going to migrate to a new server

    we need to move the amelia tables only

    can you confirm what the default install tables are?

    also is there a csv option for appointmnets etc?

    thanks 

  •  1,564
    Marko replied

    Hello there,

    Thank you for reaching out to us.

    The basic license covers one domain, but an unlimited number of its sub-domains.

    -1. The best option is if you have the staging installation, on a sub-domain,

    you can activate the license on a limitless number of sub-sites like that.

    Also to note,

    you are only required to activate your license on the live/production version of a website.

    When you need to test the plugin on a staging/test/dev version website, or on your local /intranet installation,

    there you can just manually download the Plugin installation from your TMS Store account,

    and you can also manually update the license without activation.

    2. If you need to change the domain on the license,

    the easiest way is to log in to the 'old site' WP-Admin, go into our Plugin settings/Activation, and hit "deactivate" button on the licence there;

    Go in the new website, in the Plugin settings/Activation, and just paste the Purchase code there;

    It will automatically recognize that your license is now switched/registered to the new domain.

    -

    You can also do this through the Store Account.

     In our store go to "My Licenses" and click on the "Manage Domains" button:

    8694120960.png

    From there, you will be able to deactivate the old domain (while it's still active), and then simply activate the new domain in wpDataTables settings/Activation, once you move the site.

    -

    Regarding migrating the Amelia installation so that you don't lose any data;

    The easiest way is to clone your website. 

    You can do that by using the Duplicator plugin. It will generate a couple of files that you can transfer to the new domain and it will create an exact copy of your website.

    The Duplicator plugin can export only up to 500MB of data, so if your site is bigger than that, you can use the All-in-One WP Migration plugin.

    - Other than cloning your website, there's a way to migrate only Amelia's database tables.

    There are around 47 tables with wp_amelia_ prefix that need to be moved. Please note that wp_ is the default database prefix, but on your end, it could be anything, so look for your_prefix_amelia_ tables.

    Besides that, you also need to go to wp_options and search for option_name "amelia_settings" - which returns one row, so you need to copy the option_value and paste it in the same field on the other site. 

    Note that this contains all the info from your old website, so you will need to replace the URLs in this cell. 

    Should you have any further inquiries, we kindly request that you open separate tickets for each question and we will gladly help you there.

    We wish you all the best and hope you have a wonderful day ahead.  


    Kind Regards, 

    Marko Davidovic
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  11
    Peter replied

    Thank u

  •  1,564
    Marko replied

    Hello again,

    You are most welcome, and we are glad that we were able to help you. Should you have any further inquiries, we kindly request that you open separate tickets for each question and we will gladly help you there.

    We wish you all the best and hope you have a wonderful day ahead.  


    Kind Regards, 

    Marko Davidovic
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables