We normally develop on a staging environment. When we migrate the website with all in one migration (could be any migration tool) the databases are 'disconneced'. We have to make the tables all over again. do you know how we can fix this?
Step 4 we import the development environment with the All-in-One-Migration plugin.
It is taken over all settings but the tables are pointing to a table in the old database from the development environment trk_wpdatatable_2 and I am not able to change the databasetable in the table itself. I need to create the table all over again.
We need to migrate WP Databable a lot so we are looking for an easy solution. But as soon as there is a table created on another database it is very difficult to migrate to another environment with another database. I also already connect via settings to another databse but I cannot change the database in the table. So the problem is when we try to enter data as an entry https://personeel.dnkz.nl/ the entry is not saved and is also not displayed. Please help us out!
Can you please check if perhaps the database prefix has changed for the new site?
Our plugin is expecting to see the same "path" to the tables, when you move them -
so, in your example, the table "trk_wpdatatable_2" , can you tell us what kind of error you get, i assume if you open the table it has no rows?
If that is the case, please check what is your site database prefix, and edit/ change it to be the same as it was on the previous site, make sure the DB prefix is " trk_ ".
Let us know if that helped?
-
If not, we can take a look at your WP-Admin of the current site, and we would also need access to your WordPress database ( either a link with credentials to PhPMyadmin or access to cPanel of the hosting)
Just make sure if you send us any access, to mark reply as PRIVATE, please. Thank you
Hi,
We normally develop on a staging environment. When we migrate the website with all in one migration (could be any migration tool) the databases are 'disconneced'. We have to make the tables all over again. do you know how we can fix this?
Thanks in advance!
Hello Laura,
Thank you for reaching out to us.
Can you please provide us with the steps taken for this issue to occur?
Looking forward to your reply.
Kind Regards,
Uros Jovanovic
uros.jovanovic@tmsproducts.io
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hi Uros,
Step 1 we install a plugin WP Migration on our development environment https://dnkzuren.agency6.nl/ with the plugin: All-in-One WP Migration.
Step 2 we export the the development environment with All-in-One-Migration.
Step 3 we install a new wordpress on https://personeel.dnkz.nl/ and we upload the plugin.
Step 4 we import the development environment with the All-in-One-Migration plugin.
It is taken over all settings but the tables are pointing to a table in the old database from the development environment trk_wpdatatable_2 and I am not able to change the databasetable in the table itself. I need to create the table all over again.
We need to migrate WP Databable a lot so we are looking for an easy solution. But as soon as there is a table created on another database it is very difficult to migrate to another environment with another database. I also already connect via settings to another databse but I cannot change the database in the table. So the problem is when we try to enter data as an entry https://personeel.dnkz.nl/ the entry is not saved and is also not displayed. Please help us out!
Kind regards,
Laura van Nieuwland
Hi, Laura
Can you please check if perhaps the database prefix has changed for the new site?
Our plugin is expecting to see the same "path" to the tables, when you move them -
so, in your example, the table "trk_wpdatatable_2" , can you tell us what kind of error you get, i assume if you open the table it has no rows?
If that is the case, please check what is your site database prefix, and edit/ change it to be the same as it was on the previous site, make sure the DB prefix is " trk_ ".
Let us know if that helped?
-
If not, we can take a look at your WP-Admin of the current site, and we would also need access to your WordPress database ( either a link with credentials to PhPMyadmin or access to cPanel of the hosting)
Just make sure if you send us any access, to mark reply as PRIVATE, please. Thank you
Kind Regards,
Miloš Jovanović
milos.jovanovic@tmsproducts.io
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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