I have an older MySQL blog that I developed for myself as a learning experience. I used a few tutorials, etc, and the final result strongly resembles most other blog CMS systems like Movable Type or WordPress. But finally the anxiety of managing my own self-developed system got to me and here I am.
I recently set up WordPress, but I am unsure as to what would be the best way to convert my old blog entries to WordPress' format. Are there MySQL commands I can use to batch move one table's data into a different table with different headings?
I think the defaults for new table entries in WordPress' MySQL database will hold as long as I can copy my news entries and their dates. The news itself is in longtext, the news_title is VarChar(50), and the post dates are in timestamp.
I'm willing to forget about my existing comments if I can port the news items completely, but if there is a way to do it in MySQL I'd be enthralled.
Thanks in advance :)