This is random, but a friend of mine got himself into the same situation a two weeks back and found this plugin to be helpful.
https://wordpress.org/plugins/media-sync/
But as Tom mentioned above in his comment, you’ll run into attachment post type issues.
Hope this helps you get half way there!!
Related Posts:
- MySQL SELECT increment counter
- Exclude Statement in SQL
- Custom form that store input in database
- Restoring WordPress posts from database only
- Can a post ID be 0?
- Issue with wp_insert_post and post_content field error Could not update post in the database
- wp_posts – guid update
- How to move existing WordPress wp-content folder along with database to new server and new domain name?
- what is the wp_5_posts table in the database?
- Migrating data between local and development server
- WordPress Database Charset/Collate
- How might I retrieve a featured post image from an external WP site and display it as a link back?
- What is the database table for pages?
- Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
- WordPress database becoming huge. How to analyze and optimize it? fear of running out of memory
- Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
- storing database in version control
- What’s the most efficient database method to add and query usermeta?
- How to solve slow WordPress site caused by attachment_metadata
- Is database safe after merging a branch of a more recent version over an older one?
- Hook to be used when creating a database table
- Delete all post meta except featured image
- Where is custom template file chosen for a post stored in the DB?
- How do i get user data from a custom table in the wordpress database by user ID?
- Large database causes slow load
- Safe way to find last inserted id in a table?
- WordPress DATABASE Update Manually?
- Is it possible to store visitors IPs in wp_postmeta table?
- I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
- Multiple postmeta with same name for one post in wp_postmeta table
- Which is more efficient? Using usermeta, or creating a new MySQL table?
- Export all content from wordpress
- Show content from database
- Customize JSON output
- CRUD operations using WordPress database API
- How do I get WordPress login to ignore the password input if a particular username is used?
- Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
- “Error establishing a database” connection on some sites
- change wp user status from wp_users table
- WordPress is not creating table in database after activating plugin,
- Is MariaDB’s Aria storage engine suitable for WordPress?
- Difficulty importing my live site to local
- How do I delete these post types in my WordPress database?
- Slow queries constantly getting stuck on WordPress database of ~100,000 posts
- How do I query wp_options for expired transient pairs with MySQL commands?
- WordPress returns to an old version
- WordPress running SQL query to update database from form
- How to fix database error duplicate entry
- How do I convert a MySQL database from utf8mb4 to utf8 encoding?
- WPDB SQL query with prepare() returning variable, not db value
- Get value form wordpress database
- Moving to another server database connection error [closed]
- Why user_pass column in wp_users table is varchar(64)
- Why this query is not showing any result on wordpresss home page?
- How to migrate a database from a server to another
- How to display content from external db with relevant urls
- Is there an easy way of exporting posts with their category already asigned and pictures from localhost?
- Connect to another WP install and grab post based on custom field
- Which table (and column) has the content of configured get_post_meta?
- Serialize data before inserting into the DB
- how to count click tab menu and insert to database
- Adding prefix to WordPress database tables breaks admin capabilities?
- What is the best way to resurrect and update my old WordPress site?
- Using $wpdb | checking entered email against existing emails in db
- content disappearing minutes after it’s published
- What is the most efficient way to reset a WordPress site?
- wp-cli: Error establishing a database connection: undefined constant DB_USER
- Add pdf to a website
- Optimizing function that automatically creates internal links based on post title string
- Outputting query results
- Help With a Large WordPress Based MySQL Database on Shared Hosting
- WordPress where clauses in db select
- Can two domains use the same database?
- _wp_attachment_metadata is not being added to database when PDF files uploaded
- adding user_id and name to a separate table whenever a user register based on role
- How do I loop/iterate through posts to edit all img tags?
- User saved through WordPress backend does not show up in database table users
- How to edit posts/pages without making the change live?
- Correct and secure way to access a custom SQL database in a custom PHP template file
- How to optimise this database query?
- How to retrieve user data based on role using SQL?
- Adding featured for post using database
- Does WordPress Support Using Named Pipes on the Windows Operating System?
- get_the_terms is not working
- Store id from database query in cookie
- Split database on large site?
- Store the wordpress “featured image” under »wp_posts« Database table
- Custom metabox does not store data
- Return image urls with specific base string?
- What WordPress file is saving new users to database
- wordpress database error
- How do i get value from wp_postmeta?
- Link to handle $_GET request
- WordPress sync with phpbb
- featured image not showing up with mysql_connect
- SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
- wp_usermeta key problem
- How to properly configure SSL connection to remote azure database for running queries within a WordPress environment
- Database Queries are crashing the server
- Uploading to WordPress Database