Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?

I would suggest inserting your tours as posts (or custom posts) and using a custom reference table with the id matching the post id of the Tour post.

You could use WordPress’s built in meta box functions to be able to edit each Tour in the edit posts page.

You could update your reference table by hooking into the ‘save_post’ action.

There will be a considerable look-up speed improvement if you choose to create this reference table as MYISAM and use fixed column widths along with indexing searchable columns.

With that much data, you could use this option to not only tap in to much of the great WordPress built-in functionality, but ensure speedy look-ups on the extra data.

Related Posts:

  1. Migrating database / content of non-CMS site to WordPress
  2. How to solve slow WordPress site caused by attachment_metadata
  3. Delete all post meta except featured image
  4. Delete all post meta except featured image Using SQL
  5. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  6. Trouble Migrating all data blog from WordPress.com to WordPress.org
  7. Migrating from PDO using SQLite to clean new install using MySQL
  8. Migration: Copying database content to a different server
  9. “BS_” rows in postmeta table
  10. How do i get value from wp_postmeta?
  11. SQL query : Select a thumbnail for a media
  12. Importing Concrete5 content to WordPress
  13. Rename a table in MySQL
  14. How should I tackle –secure-file-priv in MySQL?
  15. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  16. Checking if Database Table exists
  17. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  18. How to fetch Data in WordPress using MySQLi or $wpdb
  19. Connect to database using wordpress wp-config file
  20. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  21. How to define composite keys with dbDelta()
  22. Is it possible to define two databases for one installation?
  23. Dealing with Many Meta Values, 30+
  24. What is the most secure way to store post meta data in WP?
  25. Syncing local content with development / staging sites
  26. Huge wp_options table
  27. “MySQL server has gone away” since update to 3.8
  28. Can I transfer a mysql database to another site?
  29. WordPress and automated MySQL backups to a different host
  30. MySQL Syntax Error upon restoring database from backup [closed]
  31. Help running a MySQL query to update all wp_#_options tables in a Multisite install
  32. Weird issue with database migration and SSL links
  33. Size article thumbnails and retrieve them directly from database
  34. Is it safe to convert tables from MyISAM to InnoDB?
  35. Emojis getting converted to “?”
  36. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  37. How do I properly update the WordPress database password?
  38. wpdb_prepare with multiple or condition
  39. WordPress Install and Database on separate hosting?
  40. delete post meta from db, even if does not exist?
  41. Where does the actual data stored by add_post_meta
  42. Moving minor updates between local and live sites – just database?
  43. WordPress not reflecting changed of the database
  44. Error establishing database connection – high traffic?
  45. Using GROUP CONCAT in my-sql query with wp_usermeta table
  46. Routine to convert custom post meta from old to new value
  47. How to move the WordPress site Layout from test site to Production site?
  48. Able to use all admin pages but in the frontend there is a “Error establishing a database connection”-Error
  49. Create table from array with prepare
  50. Migrating to WordPress Recipe Plugin and Some SQL Issues
  51. How to fix database error duplicate entry
  52. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  53. Why this query is not showing any result on wordpresss home page?
  54. Best practice to limit results in get_row()?
  55. Why does changing Database Table Prefixes result in loss of content?
  56. WordPress url transformation script
  57. Moving WordPress site to new domain – database import [duplicate]
  58. How to connect and insert data in database of wordpress?
  59. Buddypress avatar image in database [closed]
  60. $wpdb->get_var – What value is returned when zero records are found?
  61. Installing local to live WP into subdirectory
  62. Database migration issues – Error #1046 No database selected
  63. echo site_url() returns a different value than what is in the database siteurl field
  64. Only allow user to access a link once a year, based on their joining date
  65. Counting post and changing roles in mysql database. Query not code
  66. MSQL database wp_postmeta has meta key tve_revision
  67. _wp_attachment_metadata is not being added to database when PDF files uploaded
  68. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  69. How to fix Uploaded to this post option to see group of images uploaded to a post?
  70. Migrating meta_key and meta_value from old theme to new one
  71. How can I find user role in Mysql?
  72. How do you enable scripts on a WordPress installation in Softaculous?
  73. Featured image from custom to WordPress database
  74. WordPress Database Query works in phpMyAdmin but not in the code
  75. WordPress Migration – Issue with admin panel changes
  76. Do I need to be selective about where I search and replace when pointing a domain to a subfolder used for development?
  77. Delete all users meta that named: user_avatar
  78. How to edit posts/pages without making the change live?
  79. mySQL database size large, but tables size less
  80. spambot registering without providing email or password, bypassing registration process
  81. After renaming MySQL database, I can no longer access my Blog page
  82. How To connect to the same WordPress database with different database user
  83. Possible to restore wordpress database from mysql56 and sqlite files?
  84. How much post meta data is too much?
  85. I cannot change anything in my wordpress database from within wordpress?
  86. Missing latest posts and options after DB migration via phpMyAdmin
  87. Create a new table on the database and save parameters from a contact form
  88. Media library images “missing” after migrating them using SQL
  89. Widgets with *internal* links do not display after database migration
  90. Restoring .sql backup results in “Error establishing a database connection”
  91. “MySQL server has gone away” since update to 3.8
  92. featured image not showing up with mysql_connect
  93. How to back-up a database on IIS
  94. why you don’t Implement PDO for access every thing to database
  95. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  96. How to find fresh (last modified) and sql backup?
  97. Understanding Redundant postmeta Tables in WordPress Database
  98. SQL errors when querying for something with apostrophes
  99. Naming conventions for database tables
  100. Database not loading after transfer via phpmyadmin

Leave a Comment