copied a forum to another site via sql, now need a way of getting the forum content without retyping everything
Quote from smile on May 4, 2018, 3:32 pmHi ya
I have copied a forum from one site to another using sql. But when I add the shortcode on the page I have to start from scratch in the creating the forum. I know the content is there for as I go through it starts to appear.
But is there a quicker way of doing this. As I copied the spl database with all the data I thought it would copy across when I imported it on the other site.
I have already moved it once and had to re-create the forum. Now it has more content and I need to move it again.
So is there a quicker, better way to display all the content in the forum without actually having to retype it all out, considering the content is there already but just hidden in some way
Hope you have help
Thank you
Hi ya
I have copied a forum from one site to another using sql. But when I add the shortcode on the page I have to start from scratch in the creating the forum. I know the content is there for as I go through it starts to appear.
But is there a quicker way of doing this. As I copied the spl database with all the data I thought it would copy across when I imported it on the other site.
I have already moved it once and had to re-create the forum. Now it has more content and I need to move it again.
So is there a quicker, better way to display all the content in the forum without actually having to retype it all out, considering the content is there already but just hidden in some way
Hope you have help
Thank you
Quote from Asgaros on May 4, 2018, 11:38 pmHello @smile
I think you have to re-create the categories and set the parent_id‘s of your forums to the corresponding id of the category directly in the wp_forum_forums database-table with a tool like phpMyAdmin.
Hello @smile
I think you have to re-create the categories and set the parent_id‘s of your forums to the corresponding id of the category directly in the wp_forum_forums database-table with a tool like phpMyAdmin.
Quote from smile on May 5, 2018, 5:00 pmThanks for replying
I have been doing this. I thought there would have been away to not have to do this. Kind of like when you export and import blog post they appear complete.
Thank any way
Great forum plugin by the way
Thanks for replying
I have been doing this. I thought there would have been away to not have to do this. Kind of like when you export and import blog post they appear complete.
Thank any way
Great forum plugin by the way
Quote from Asgaros on May 7, 2018, 8:47 pmYes, the reason for this is that the categories are saved as terms/taxonomies inside the database.
Yes, the reason for this is that the categories are saved as terms/taxonomies inside the database.
Quote from smile on May 14, 2018, 3:41 pmhi ya,
I copied the terms/taxonomies from the old site to the new site. creates all the main categories within the forum structure.
I even added some subforums thinking the content would appear. nope, I have to type before the titles appear. The same for the topics.
Its all visible in my original database.
now, how do I import all the content without retyping it.
I’ve tried importing from one database to the new place and it won’t work. I changed parent ids within the sql file, ~( also tried csv file) to match new ids on new site..
I’ve been on this all weekend.
Any way to do this?
hi ya,
I copied the terms/taxonomies from the old site to the new site. creates all the main categories within the forum structure.
I even added some subforums thinking the content would appear. nope, I have to type before the titles appear. The same for the topics.
Its all visible in my original database.
now, how do I import all the content without retyping it.
I’ve tried importing from one database to the new place and it won’t work. I changed parent ids within the sql file, ~( also tried csv file) to match new ids on new site..
I’ve been on this all weekend.
Any way to do this?
Quote from Asgaros on May 14, 2018, 7:45 pmHello @smile
After importing the terms/taxonomies at least the categories should appear in the structure-administration.
For each category you can see its unique ID. It could be possible that those IDs changed compared to your old forum because databases usually uses an incremental counter for IDs. In this case you have to check the parent_id value in the wp_forum_forums table and set its value to the corresponding ID of the category in which the forum should be located in.
If its still not working you can contact me at developer (at) thomasbelser.net so I can have a look.
Hello @smile
After importing the terms/taxonomies at least the categories should appear in the structure-administration.
For each category you can see its unique ID. It could be possible that those IDs changed compared to your old forum because databases usually uses an incremental counter for IDs. In this case you have to check the parent_id value in the wp_forum_forums table and set its value to the corresponding ID of the category in which the forum should be located in.
If its still not working you can contact me at developer (at) thomasbelser.net so I can have a look.
Quote from smile on May 15, 2018, 8:09 pmHi ya,
After importing terms/taxonomies nothing appeared. Your right about the incremental counter.
In the end, I had to rewrite everything out again. I copied and pasted but I hope I don’t need to move it again.
thank you for your offer of help by the way much appreciated
Hi ya,
After importing terms/taxonomies nothing appeared. Your right about the incremental counter.
In the end, I had to rewrite everything out again. I copied and pasted but I hope I don’t need to move it again.
thank you for your offer of help by the way much appreciated