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. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  17. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  18. MySQL SELECT increment counter
  19. phpMyAdmin – Error > Incorrect format parameter?
  20. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  21. Using wpdb to connect to a separate database
  22. MySQL Database User: Which Privileges are needed?
  23. Why is my database import losing text widget data?
  24. Multiple developers / editors working on a site in progress
  25. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  26. Will it break my site if I delete all transient records in wp_options table?
  27. Checking if Database Table exists
  28. Why WordPress choose data serialization over json_encode?
  29. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  30. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  31. Please explain how WordPress works with MySQL character set and collation at a low level
  32. Solution for database version control and deployment?
  33. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  34. How to fetch Data in WordPress using MySQLi or $wpdb
  35. WordPress Database lost auto increment
  36. Connect to database using wordpress wp-config file
  37. wpdb->insert multiple record at once
  38. How to migrate a HTTPS WordPress installation to localhost?
  39. Reset Post IDs to less than 64bit integer
  40. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  41. Restoring WordPress posts from database only
  42. WordPress database scalability from the code perspective
  43. How to define composite keys with dbDelta()
  44. insert data from a form:: Warning Empty query mysqli::query()
  45. How can I get $wpdb to show MySQL warnings?
  46. After Migration From dev, Only my Links to the Homepage Still Redirect to dev
  47. Merging development site with live site
  48. mySQL database size large, but tables size less
  49. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  50. spambot registering without providing email or password, bypassing registration process
  51. After renaming MySQL database, I can no longer access my Blog page
  52. How To connect to the same WordPress database with different database user
  53. Possible to restore wordpress database from mysql56 and sqlite files?
  54. WordPress Database Posts Table query
  55. How much post meta data is too much?
  56. Hang Up Followed By Can’t select database
  57. I cannot change anything in my wordpress database from within wordpress?
  58. How to extract some part of WordPress full source code
  59. Mysql Queries per Visit – Crazy High
  60. Missing latest posts and options after DB migration via phpMyAdmin
  61. Check if a database is well installed
  62. Create a new table on the database and save parameters from a contact form
  63. live site do not update after importing sql database
  64. Media library images “missing” after migrating them using SQL
  65. Why is converting my database to UTF-8 truncating entries?
  66. Widgets with *internal* links do not display after database migration
  67. using same mysql user with many databases
  68. Restoring .sql backup results in “Error establishing a database connection”
  69. “MySQL server has gone away” since update to 3.8
  70. Why are my WordPress post queries so slow?
  71. import (migration) user database to wp-users
  72. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  73. featured image not showing up with mysql_connect
  74. MySQL Database User: Which Privileges are needed?
  75. Import Excel (or csv) Table with user-data as subscribers to wordpress
  76. Moving database from WP 2.6 to 3.5 problem
  77. Print output of Table Creation
  78. Recommended Post Structure for DB Storage
  79. How to back-up a database on IIS
  80. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  81. export individual posts to text files or a single csv file
  82. Custom wordpress SQL statement for a website
  83. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  84. why you don’t Implement PDO for access every thing to database
  85. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  86. WordPress database connection failed, while mysql client is working [closed]
  87. How to find fresh (last modified) and sql backup?
  88. Uploading to WordPress Database
  89. Have WordPress Use a Different Database for users
  90. How to generate PDF dynamically based on values from the database in WordPress
  91. Understanding Redundant postmeta Tables in WordPress Database
  92. #1067 – Invalid default value for ‘post_date’ when trying to create a new column
  93. wp_update_post function exclude specific field
  94. Deleting WordPress posts and media files based on author via MYSQL database
  95. SQL errors when querying for something with apostrophes
  96. Naming conventions for database tables
  97. WordPress User Login not accepted although listed in DB
  98. Count views without get_post_meta
  99. Database not loading after transfer via phpmyadmin
  100. Problem while importing a site in WPLocal: SQL files fail to import

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)