Migrating to WordPress Recipe Plugin and Some SQL Issues

To answer your questions:

Is this possible with an SQL command or just manually?

  1. Possibly. This would require you to map the data from your old table to the new WordPress table, since your old custom PHP script won’t be on WordPress. Merging your data from your old recipe table into WordPress won’t work since it is a completely new platform that you are migrating to and doing so will mess up your WordPress website.

Or are there any other ways to do this?

  1. A few ways:
    • Manual: If you don’t have that many recipes, you can manually copy-and-paste the data into your new WordPress website and plugin (Cooked). While this may be a tedious process, it’s a clean way.
    • Automated: Export the data from your old recipe table into an XML or CVS file and have that imported to WordPress. You can use a plugin that imports the XML/CSV (such as this one) by mapping the data to your new table and rows. I’ve personally haven’t use the plugin that I just linked to you, but it will require some testing on your end.
    • Professional: If the above are too tedious for you and you’re not comfortable with your technical skills, I’d look into hiring a WordPress professional who can help you with the migration process. This would cost you, unless you’re willing to pay. Prices vary on each web developer. You can post your job listing here.

Related Posts:

  1. Performing CRUD operations on front end in wordpress
  2. Creating 20,000 Posts or Pages using a .csv file?
  3. How to properly insert data into custom table via plugin
  4. How does WordPress handle MySQL row lock errors?
  5. Can I explicitly specify ENGINE=InnoDB in WordPress?
  6. Bad Request (Invalid Hostname) on working server, database problem
  7. Changing BIGINT to INT
  8. What is the easiest way to implement cascading database upgrade for my plugin?
  9. greatest() function returns undefined property
  10. How to write one comment and publish on every post using database or plugin?
  11. How to determine what is generating large amount of database queries?
  12. Retrieving a Value from a wp-database
  13. WordPress Settings Lost After Site Migration
  14. Help With MySQL to WPDB Query Conversion
  15. Prevent duplicate records in plugin table
  16. How do I run SQL queries on a WordPress web page? [closed]
  17. How can I perform high-level database merging for WordPress within continues delivery?
  18. WordPress Backend HA (Automatic failover)
  19. Automatic switch to backup database on fail
  20. Multiple instance of data in plugin custom database table on plugin activation
  21. Better ads plugin has 500.000 entries in wp_postmeta
  22. How to create multiple database tables on plugin activation?
  23. Does deleting a Plugin via the WordPress admin ‘completely’ remove the code?
  24. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  25. Speeding SQL queries for a large database?
  26. dbDelta not adding additional columns in plugin database update
  27. Always get creating a new table with foreign key
  28. How to do database for download stats?
  29. DB Query not working in Plugin
  30. External wpdb connections in different plugins on single page
  31. WordPress plugin: efficient way to store large data
  32. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  33. Integrating Custom Database with WordPress
  34. How to display results from a data table with an encrypted user id?
  35. add_action for publish_post doesn’t work
  36. how can we migrate wordpress 5.9 website from aws ec2 to new installed wp 5.9 oci compute
  37. JOIN and SUM different statement results (Mailster Database)
  38. How to get specific column data conditionally in database in WordPress?
  39. Memcaching recurring SQL Queries
  40. What database state changes happen after a post is manually “updated” with no changes?
  41. Cant create table on plugin activation
  42. How to get database connection details without longing to cpanel in WordPress?
  43. Display a number value from mysql query in WP
  44. Store GravityForm data in phpmyadmin (mysql)
  45. Moving a few select DB tables to a new WP instance
  46. WordPress database problem wp_posts, primary key
  47. errno: 150 “Foreign key constraint is incorrectly formed” [closed]
  48. Database error when user logs in
  49. HyperDB failover Delay
  50. Write mysql credentials in plugin
  51. Duplicator live to wamp https to http
  52. Get all the related data from WordPress DB
  53. How can I delete the options from DB when the plugin is deleted?
  54. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  55. Case statement in MySQL
  56. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  57. How do I show data from gravity forms in my template? [closed]
  58. How to transfer a WordPress blog to a different domain?
  59. Search and replace text across all posts
  60. How to store ACF custom fields data in a custom table
  61. Plugin Not Working, But Only On GoDaddy Hosted site
  62. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  63. How to Join two tables from separate databases within WordPress
  64. WordPress plugin DB upgrade
  65. Ajax with jQuery UI dialog not working
  66. How to migrate from Mark Jaquith’s Subscribe to Comments plugin to Gurken’s new version?
  67. Is the wordpress user-model changed in wpmu?
  68. Creating Tables on Network Activation
  69. Where to hook my plugin’s action
  70. SQL Error wp_commentmeta – incorrect table definition
  71. Building an email signup form. Where should the information be saved in the DB?
  72. Database Tables Lost Indexes? How to Recover?
  73. Enabling plugin failed because MySQL user do not have CREATE permissions
  74. new multisite, old db
  75. Creating a CSV with PHP inside the plugin directory
  76. pagination on data fetched using SQL query
  77. correct validate and sql query
  78. Using ‘mysqli_connect’ ‘crashes’ WordPress client-side
  79. How to create plugin/ page that reads from database
  80. problem with sql query
  81. Deactivation Hook does not remove database
  82. Assign all Post in Wp to a specific Category
  83. SQL query to set posts in bulk based on the post content
  84. Storing The Data Collected by Ninja Forms into Another (custom) Database [closed]
  85. Using AJAX to run SQL statement and populate dropdown
  86. How to make a Product page without ordering and database
  87. How can I display selected content from a seperate database in an Activity style widget?
  88. WP Function does not trigger on Webhook API Call
  89. $wpdb->delete not working for me
  90. How to add specific script to WordPress webpage that will working with user input and databases
  91. How to use WordPress header function and footer function and not load word press database
  92. How to securely controlling data without keeping it in postmeta?
  93. database – multiple wordpress installations using same database – can they share plugin settings?
  94. Create Database Tables on Plugin Activation hook
  95. Slow WordPress admin panel with a total query time of 1664ms
  96. Posts are deleted everyday at night
  97. Display Plugin information on specific url
  98. Custom Table doesn’t create on plugin activation
  99. Split Million WordPress Post’s Into Multiple Database Server
  100. Can’t save formdata in DB