Hello Yolande,

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:

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

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:

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.

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:

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

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

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:

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

 with "localhost/lite1":

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

If you configured the Redirect URL after booking under Amelia/Settings/General Settings, you'll need to replace that as well, along with the 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.