I have a client I'm building a whole new webiste for. We would like to start from scratch to avoid taking a lot of crap with us to the new website.
However, for Amelia, we would like to take everything with us, so the plugin feels the same in the new site as in the old (the services, employees, the made appointments,....)
If I seach a bit I could only find an old article that says we could do it by copying the PHPmyadmin tables. Is that really so? That's a bit dissapointing for a "premium booking plugin". 90% of plugins I use have export/import features. Strange that one of my priciest plugin Amelia does not have this.
If you really don't have this:
A) Could you please pass this to the developpers again? I saw others where before me.
Option 1: A easy import / export for all data would be really nice.
Option 2: A migrate wizard would be awesome. This wizard is able to check on the old site what needs to be done and what is actieve (for example an outlook connection). This wizard exports everyting in a downloadable file. On the new site the wizard checks this. The wizard imports all given data and marks additional todo's like: "please set cronjob", "please make connection for outlook calendar",...
B) Could you give me the most recent info on how to do this mannualy?
Unfortunately, this is still the only way to move Amelia's data to another website. We're going to work on the export/import option, but at this time it's not a priority so I can't provide you with an ETA.
The procedure is still the same:
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 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:
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 the 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 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.
Hi,
I have a client I'm building a whole new webiste for. We would like to start from scratch to avoid taking a lot of crap with us to the new website.
However, for Amelia, we would like to take everything with us, so the plugin feels the same in the new site as in the old (the services, employees, the made appointments,....)
If I seach a bit I could only find an old article that says we could do it by copying the PHPmyadmin tables. Is that really so? That's a bit dissapointing for a "premium booking plugin". 90% of plugins I use have export/import features. Strange that one of my priciest plugin Amelia does not have this.
If you really don't have this:
A) Could you please pass this to the developpers again? I saw others where before me.
Option 1: A easy import / export for all data would be really nice.
Option 2: A migrate wizard would be awesome. This wizard is able to check on the old site what needs to be done and what is actieve (for example an outlook connection). This wizard exports everyting in a downloadable file. On the new site the wizard checks this. The wizard imports all given data and marks additional todo's like: "please set cronjob", "please make connection for outlook calendar",...
B) Could you give me the most recent info on how to do this mannualy?
Thanks.
Laurent
Hello Laurent.
Unfortunately, this is still the only way to move Amelia's data to another website. We're going to work on the export/import option, but at this time it's not a priority so I can't provide you with an ETA.
The procedure is still the same:
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 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:
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 the 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 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.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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