Solved it by creating an update sql command from the backup insert sql, saving in a file using Notepad++, and imported via phpmyadmin. Maybe there had been an issue with extra newline characters or missing backslash escape characters when I tried before.
Migrate Users From laravel to wordpress
Recovery – Restore Database after moving folder location locally
Sql query to get all metadata for a post
How delete post_content records of specific category from phpmyadmin
Occasional Error Establishing a Database Connection
Whats the best practise on how to store json data from a custom settings page?
How to insert a value to decimal type field using wpdb->prepare?
You are not seeing a stack trace because this information is being logged via the error_log() function within the wpdb::print_error() method. error_log() simply sends a message to the logs. The behaviour you’re expecting with a full stack trace would require trigger_error() to be used.
Thanks to @Hobo’s answer which gave me the clue for moving pm2 condition to the join statement SELECT p.ID, p.post_content, p.post_title, p.post_excerpt, pm1.meta_value as meal_date, pm2.meta_value as meal_plan, t.name as meal_type FROM wp_posts AS p LEFT JOIN wp_term_relationships AS r ON (p.ID = r.object_id) INNER JOIN wp_term_taxonomy AS x ON (r.term_taxonomy_id = x.term_taxonomy_id) INNER JOIN … Read more