Page 2 of 2

Posted: Thu Oct 18, 2007 4:06 pm
by u1amo01
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 for details.

Comments are imported correctly, but the counter at each posting shows "0 comments"


Posted: Thu Oct 18, 2007 5:52 pm
by garvinhicking

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
by u1amo01
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


AUTO_INCREMENT-Wert hinzufügen
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
by garvinhicking

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
by u1amo01
Mail sent.

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
by garvinhicking

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!

Best regards,