Note: This is more a comment than an answer, but I wanted to format it nicely.
I don’t know about recording, but I imagine something like the following in SQL could work.
INSERT INTO DB1.Tbl1 ( id, x, y )
SELECT DB2.Tbl1.id, DB2.Tbl1.x, DB2.Tbl1.y
FROM DB2.Tbl1
ON DUPLICATE KEY
UPDATE x=x, y=y;
Beware, this is completely untested. You have to test it and read up on the documentation yourself.
Related Posts:
- Clone WordPress site from development server to live server
- How do I set up a test environment in a sub-folder?
- How can i convert my Delphi.NET project to Delphi Prism?
- WordPress database synch between dev and prod
- Do you have any effective strategies for launching a v2 of a WP site?
- Migrating Markdown (from Drupal)
- Ways of managing staging and production wordpress sites?
- Broken CSS after changing the site URL
- Most Flawless Way To Transfer from Dev to Prod [duplicate]
- Make WordPress “readonly” on a given site
- References to other site everywhere in WordPress site
- Plugins to clone wordpress site and move to another url
- 500 Internal Server Error after attempting to switch from subdirectory to addon domain
- How to upload local changes to a live server without overriding new posts/pages?
- How can I assign post a specific ID on creation?
- Migrate localhost to server
- Error establishing a database connection After Copy localhost wordpress site (with site url directly to hosting server’s url before copy)
- How to migrate from wordpress.com to self-hosted wordpress
- What actions affect files, DB, or both?
- Different color admin bars for dev, staging and production
- How to just migrate posts/pages from one site to another?
- Setting up WordPress playground and deploying to production server?
- How do i migrate a Multi site to individual site?
- Migrated site redirects to localhost after successful login
- Error migrating from live website to localhost
- Copying wordpress to another server breaks it on original server
- Remapping absolute URLs from other domains and from test domain
- Can I setup WordPress in a subdirectory and then point my URL to the subdirectory when I’m ready to go live?
- Save (same) permalink from wp-cli
- Changed site URL and now my Front Page doesn’t display correctly
- WordPress Odd migration issue
- Localhost: WordPress redirecting to a different URL
- Ways to work offline with your WordPress
- Move from Subdomain to Root
- migrating local dev site to live site with no downtime
- How do I fully migrate post images from one WordPress site to another?
- WordPress Network (MU): Copy Main Site to Sub-Site
- Is there a way to migrate via wordpress dashboard?
- Changing WordPress domain
- Cannot complete migration on LAMP
- WordPress Staging Site
- Published site reverts without changes to theme
- How do I migrate a Website of this size ( Archive: 24GB, DB: 256 MB )
- Can only access homepage and admin panel
- how to update link on live site from test site
- Mixed Content warnings google fonts
- Migrating to local server
- Import wordpress mysql database to unknown server / domain
- Images in the post still pointing to older domain after domain change
- Redirect to another page using contact form 7? [closed]
- The entire wordpress theme reset to default after uploaded to live
- Publishing WordPress from stage to production server
- How to do a clean transfer of WordPress site to a new server?
- Absolute Hyperlinks in WordPress Website Will Not Work In the Local Server
- Migrate posts and photos from a blog to another
- Migrating stats from WordPress.com blog to self-hosted WordPress.org blog
- Transfer WP from subdomain to main domain
- FTP not working on a specific WordPress site but working on others (and Filezilla) [closed]
- Duplicator Pro plugin with Docker on local?
- Guide to migrating a WordPress development site to a running live site
- Is there a way to migrate my wordpress blog to another website that uses a different domain?
- How do I move a WordPress site on the same server?
- Translation working on staging site, not on live one
- WordPress white screen of death
- Issue In Links after migrating from Live server to Localhost XAMPP
- Is it possible to migrate a wordpress website to another wordpress account?
- Long loading site after migration
- How to duplicate a website?
- White screen after moving site to new server
- What happens if I replace the files of a WordPress site with another WordPress site?
- How I shift me website from WordPress managed to linux hosting?
- How do I move my WordPress domain to another domain?
- my images are not showing when i upload them, they apear as placeholders
- Move wordpress files from one pc to another pc contents showing error
- Migrating a whole website to WordPress
- Migrating WP site to localhost using Duplicator
- Admin Custom Login loses settings on Code and Data migration
- Transfer WordPress intranet site from my pc to the company local server
- WordPress featured images: migrating from dev to live site
- Image paths wrong after migrating with wp-migrate-db-pro media files add-on
- One-way DB Migration Workflow
- Upgrading a wordpress site to its newest version
- How to transfer /wordpress folder from one Mac to another
- How to move a locally built wordpress website to live server using wordpress importer
- Copy template with plugins to another hosting provider
- All styles are looking for the site URL twice
- Image src empty after migration
- Migration to staging server, pages from other site loading in
- Is it possible to get an exported WP site in a zipped folder up and running? [closed]
- Export/Import xml
- Static HTML to WordPress migration
- Clone wordpress blog on localbox manually
- how to move a wordpress blog to my static site
- How to migrate, does WordPress hardcode or shortcode image URLs?
- Moving Site From Development to Production
- Migration Question
- Moving Large Number of WordPress posts from One wordpress site to another existing wordpress site
- How to migrate a local WP installation onto Digital Ocean
- WordPress migration from live server to localhost having 404 error? [closed]
- open_basedir restriction in effect after migration from LAMP to WIMP