Cowboy Denny Posted September 22, 2020 Posted September 22, 2020 Could someone help me figure out how I can go about exporting existing records from a database in pages from one site and import those records to the same database at the new site? I really don't want to re-create each record manually.. which I have done before and it totally sucks and takes a ton of time. Seems like there must be a way. I exported the database from site1 and imported database.xml to site2 which doesn't include records but includes everything those records should need (I believe). I just don't know how to get the records over. Thanks in advance for any guidance
rfcontreras Posted September 27, 2020 Posted September 27, 2020 Export and import the structure, and then you'll need some mysql fiddling to dump the table and import it to the new table on the other site. Not super easy but doable.
jaeitee Posted September 28, 2020 Posted September 28, 2020 On 9/23/2020 at 12:07 AM, DJ ZAh said: I exported the database from site1 and imported database.xml to site2 which doesn't include records but includes everything those records should need (I believe). I just don't know how to get the records over. Thanks in advance for any guidance Use phpMyAdmin or something similar (I like TablePlus https://tableplus.com/ personally ) and open your custom_database_x table. Check your custom fields (ie: field_50, field_51) etc all match your old database. If they do not match: Clone custom_database_x table. Rename the old field_x numbers to match the new field_x numbers.Optionally I reorder the field structure to help visually reading the database, otherwise don't worry about this. If they do match or after completing the step above: Copy the rows from the old database and paste them straight in to the new database. Warning: Make sure you have backups before doing this, personally I just clone the whole custom database table as I find that's easiest to revert if something goes wrong. My last import this way was 1738 records as I merged two separate Pages databases, no issues so far 🙂
Cowboy Denny Posted October 7, 2020 Author Posted October 7, 2020 Thanks everyone for your suggestions.
mcsg Posted November 18, 2020 Posted November 18, 2020 On 9/27/2020 at 4:19 AM, A Zayed said: User IPS converter app. @A Zayed Could you elaborate on this? I do not see any place to select a Pages database from within the converter app.
A Zayed Posted November 28, 2020 Posted November 28, 2020 On 11/18/2020 at 8:06 AM, mcsg said: @A Zayed Could you elaborate on this? I do not see any place to select a Pages database from within the converter app. Sorry, I misunderstood the question... discard my reply.
mcsg Posted February 6, 2021 Posted February 6, 2021 On 9/27/2020 at 8:38 PM, jaeitee said: Use phpMyAdmin or something similar (I like TablePlus https://tableplus.com/ personally ) and open your custom_database_x table. Check your custom fields (ie: field_50, field_51) etc all match your old database. If they do not match: Clone custom_database_x table. Rename the old field_x numbers to match the new field_x numbers.Optionally I reorder the field structure to help visually reading the database, otherwise don't worry about this. If they do match or after completing the step above: Copy the rows from the old database and paste them straight in to the new database. Warning: Make sure you have backups before doing this, personally I just clone the whole custom database table as I find that's easiest to revert if something goes wrong. My last import this way was 1738 records as I merged two separate Pages databases, no issues so far 🙂 @jaeitee Thanks for the step by step. How do you handle tags? And images? Have you migrated any related databases (e.g. People records inside Company records)? Those records are in a many-many table `cms_database_fields_reciprocal_map`
Recommended Posts