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?
- How to: Easily Move a WordPress Install from Development to Production?
- Database synchronization between dev/staging and production
- WordPress database synch between dev and prod
- Moved WordPress to New Server, Now Tries to Download a File
- Do you have any effective strategies for launching a v2 of a WP site?
- Migrating Markdown (from Drupal)
- Change site url when moving site to another url?
- Ways of managing staging and production wordpress sites?
- Migration issue – blog home page is blank
- Recover WordPress blog from an inactive domain name
- Broken CSS after changing the site URL
- Is it possible just by using wp-cli to migrate one multisite instance to single site?
- Most Flawless Way To Transfer from Dev to Prod [duplicate]
- Make WordPress “readonly” on a given site
- Is there an easy way to migrate a site from SiteFinity to WordPress?
- How to transfer changes from test environment to live site?
- References to other site everywhere in WordPress site
- Plugins to clone wordpress site and move to another url
- Change old URLs after the domain change
- Maintaining synced staging/production WP sites
- Syncing production with staging
- 500 Internal Server Error after attempting to switch from subdirectory to addon domain
- Export and overwrite pages on import?
- problem migrating files from https to http mock site – how to see mock site
- How do you add pages on a staging server, and then move them over to production
- How to upload local changes to a live server without overriding new posts/pages?
- URLs to images get messed up after migration
- How can I assign post a specific ID on creation?
- Migrate localhost to server
- What’s a better workflow for database migration?
- 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
- Does WordPress Import/Export tool actually exports media (images) as well?
- Links after moving my site to another domain
- Migrating my existing WP site to localhost
- What actions affect files, DB, or both?
- Will post id change when migrating to new site?
- 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?
- Critical Site Health Issue after WordPress Migration
- How to Work Seamlessly Between Development, Staging, and Production Sites in wordpress
- Migrated site redirects to localhost after successful login
- How do I redirect my blog posts to a subdomain?
- Error migrating from live website to localhost
- Copying wordpress to another server breaks it on original server
- Migration / convert an existing site to WordPress
- Why isn’t my imported database showing up? install.php pops up and adds new tables to the database
- Install WordPress on new server or just copy old files?
- 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?
- call_user_func_array() errors after migrating site with InstantWP
- Moving a WordPress site from one folder to another (one domain, one server)
- After finishing building a site on localhost, how do I transfer everything to a client’s server?
- how do i find out why links point to my old domain
- We have a static Hugo website and we want to migrate it to WordPress
- Save (same) permalink from wp-cli
- How do I force password reset even with wrong password entered?
- Changed site URL and now my Front Page doesn’t display correctly
- How can I migrate (export and import) wordpress users without loosing their password?
- WordPress Odd migration issue
- How to copy WordPress live website to Bitnami stack localhost?
- Localhost: WordPress redirecting to a different URL
- Tags not importing when using WordPress import system
- Ways to work offline with your WordPress
- Move from Subdomain to Root
- Migrate from CMS Made Simple to WordPress
- Migrating entire online site to local server gives “The requested URL /login/ was not found on this server.”
- migrating local dev site to live site with no downtime
- How do I fully migrate post images from one WordPress site to another?
- preventing the duplicate wp_insert_post
- WordPress Network (MU): Copy Main Site to Sub-Site
- Is there a way to migrate via wordpress dashboard?
- Trying to move an Expression Engine site to WordPress, but not having luck with content
- Changing WordPress domain
- Why is the domain name missing from the logout redirect?
- Migrate ProcessWire to WordPress
- Preserve password hashes when migrating to another server
- Cannot complete migration on LAMP
- Nginx mamp pro5 migration home page works all other do not
- Automatic Maintenance Mode during All in One Port
- migrating my wordpress site
- How to sync staging to production but keep plugin settings
- WordPress Staging Site
- Moving WordPress page to a new domain
- WordPress & WooCommerce: Localhost, Staging and production environments and how to sync them without losing data
- Published site reverts without changes to theme
- Is it possible to transfer my local installation entirely to the server?
- Why WordPress isn’t and/or can’t be domain agnostic
- How do I migrate a Website of this size ( Archive: 24GB, DB: 256 MB )
- migrated wordpress site not running properly, on Ubuntu localhost?
- The easiest way to migrate a wordpress website across servers
- Migrating hosts, 500 errors and plugin issues
- Moving my newly made site from subdirectory
- Can only access homepage and admin panel
- What is the difference between wp-admin>Export>All content and MySql dump and import