Hey everyone!

With the Labour Day holidays coming up, we’d like to let you know about our upcoming working hours:

Thursday, May 1st: Our team will be off during Labour Day.
Friday, May 2nd: We'll also be off for an extended holiday break.

We’ll be back on Monday, May 5th, ready to respond to all messages received during this time.

In the meantime, if you need help, feel free to:

https://www.youtube.com/@AmeliaWordPressBookingPlugin/videos

https://www.youtube.com/@wpDataTables/videos

Thank you for being so understanding, and we hope you enjoy the long weekend! 

Okay
  Public Ticket #3302231
Migriation of WP Amelia
Closed

Comments

  • Laurent started the conversation

    Hi,

    I have amelia installed on a website and we would like to use a new website for this firm. However, we would like to take all the amelia data with us. The new website itself is on a new staging platform.

    The old website was part of a multisite. 


    What could we do to migrate this easily? 


    Kind regards

    Laurent

  •  2,576
    Aleksandar replied

    Hello Laurent.

    I'm afraid there's no way to do this easily.

    Once you access your database, from where Amelia needs to be moved, you'll see a list of tables that start with "wp_amelia" (or your_prefix_amelia). You need to select all those tables, as shown in the screenshot below:

    7296824454.png


    Once you select them, scroll all the way down, and in the "With selected" drop-down click on "Export":

    5384527213.png


    A new screen will be presented which may look different, depending on the database manager you're using and its version, but in short - you don't need to select any specific options, just run a quick export by clicking on the Export button in the bottom:

    4556082631.png


    A new file will be saved to your computer with the name of the database, followed by the ".sql" file extension.

    Once you download that file, make sure that Amelia is installed on another site. After it's installed, access its database and check the prefix. If the prefix is the same, select all wp_amelia tables, as you did in the 1st step, and under "With selected" click on drop to delete all those tables.

    7904225308.png


    Then, confirm this action on the next screen, and once you're done you won't see any Amelia tables anymore.

    If the prefix is different, open the database_name.sql file and run "Find and Replace". Replace the old prefix (from the original database) with the new prefix and save that file.

    Back in the database of the new site, click on "Import" in the top menu:

    5887582069.png


    Select the database_name.sql file, scroll all the way down, and click on Import:

    Once that is done, all services, employees, appointments, and so on will be copied from site 1 to site 2. Now, for the settings - go back to the original database and access the "wp_options" database table (or your_prefix_options) and click on the Search button in the upper menu:

    Under option_name, type "amelia_settings" and hit Go at the bottom:

    6154582997.png


    This will return one row, so click on "Edit":

    7621826329.png


    When you edit it, under "option_value", you'll see a JSON input. This can be copied into the same location on another site, so select all the text in there:

    7545321849.png


    Copy it, and then access the same location on the new site (wp_options -> search for "amelia_settings" under option_name and then paste the copied data into option_value field).

    Once you save this, you'll need to modify the Redirect URI of Google and Outlook Calendar, so in the new site, access Amelia/Settings/Integrations/Google Calendar, and replace the domain of the old site with the domain of the new site. In our example, we need to replace "localhost/current":

    9290126214.png


     with "localhost/lite1":

    5010445071.png


    Switch to the Outlook Calendar tab, and do the same.

    If you configured Redirect URL after booking under Amelia/Settings/General Settings, you'll need to replace that as well, along with Successful Cancellation Redirect URL and Unsuccessful Cancellation Redirect URL found in Amelia Settings/Notification Settings.

    That would complete the data migration from one database (site) to another.

    Please let me know if you have any follow-up questions about this.


    Kind Regards, 

    Aleksandar Vuković
    [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