Page 2 of 2
Posted: Thu Oct 18, 2007 4:06 pm
Looks like import from the new version WordPress 2.3 doesn't work properly. The categories were not imported. IMHO because the structure of the tables has changed.
WordPress 2.3 introduces our new taxonomy schema. This new schema replaces the categories, post2cat, and link2cat tables with three new tables that are more flexible.
See WordPress 2.3 Taxonomy Schema
Comments are imported correctly, but the counter at each posting shows "0 comments"
Posted: Thu Oct 18, 2007 5:52 pm
Do you maybe have an example dump of the taxonomy table so that I can see how it actually looks like? We only can import categories, not the tags (at least for now, because that would require the freetag plugin integration with the importer).
Posted: Thu Oct 18, 2007 6:45 pm
Hmm, if you tell me how to do this - I'm not an phpMyAdmin expert, sorry.
A dump of wp_term_taxonomy, right?
When I go to "Exportieren", there is the following marked by default:
export as: SQL
Tabellen- und Feldnamen in einfachen Anführungszeichen
Hexadezimalschreibweise für Binärfelder verwenden
Is this ok? And should I send it by mail? (not the whole table for sure
Posted: Thu Oct 18, 2007 7:46 pm
It should be three tables: wp_term_taxonomy, wp_term_relationships and wp_term.
Your PMA options would be fine, you need to both check "Struktur" and "Daten" so that everything is contained in the dump file. You can send it via mail to me, blog at garv dot in.
Posted: Thu Oct 18, 2007 8:50 pm
BTW, WordPress also offers to export Data as XML in a so called "WordPress eXtended RSS / WXR" to exchange content between two WordPress-Blogs. Maybe this could also be a way to import to s9y?
Posted: Thu Oct 18, 2007 10:12 pm
It surely would, but I'm quite sure it's some amount of work to be done. Maybe some volunteer steps up to check it out? It would be nice if s9y could also export its data in this WXR format. Maybe a good projects for Google Summer of Code.
I'll check out your mail and see what I can do!