Recent Topics

1 May 06, 2006 14:31    

Hi all. I've recently converted from my old no-name blogging software to b2evo, and I love it! Except for one little problem...

How can I import my old posts/comments from the old blog into b2?

Below is a dump of my old software's database structure, if that helps.

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 02, 2006 at 08:18 AM
-- Server version: 4.1.14
-- PHP Version: 4.3.11
--
-- Database: `flowers_blog`
--

-- --------------------------------------------------------

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
`id` int(11) NOT NULL auto_increment,
`message` longtext NOT NULL,
`name` varchar(30) NOT NULL default '',
`subject` varchar(40) NOT NULL default '',
`date` varchar(40) NOT NULL default '',
`email` varchar(40) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=343 ;

--
-- Table structure for table `reply`
--

CREATE TABLE `reply` (
`id` int(11) NOT NULL auto_increment,
`replyid` int(11) NOT NULL default '0',
`message` longtext NOT NULL,
`name` varchar(30) NOT NULL default '',
`ipaddy` text NOT NULL,
`dstamp` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1295 ;

3 May 11, 2006 12:22

Nope, sorry, that didn't help.

Any other ideas?

4 May 13, 2006 09:52

How many posts/comments are you trying to convert?

¥

5 May 16, 2006 13:05

Approximate 384 posts. I'm not exactly worried about the comments (I converted to b2evo because someone spammed ALL my posts over a weekend).

6 May 16, 2006 19:40

If you send me a sample of your sql I can try and come up with something that'll convert them for you.

¥

7 May 18, 2006 05:39

¥åßßå, the structure is in my original post. ;] but if you need the exported sql file, pm me with an email address, and i can send it to you. It's not large compressed.

9 May 18, 2006 14:19

Thanks, package is on it's way. Just be careful with it, that's 4 years of my life!

10 May 20, 2006 14:51

sent you an email with a converter page.

If you get stuck just holler.

¥

11 May 21, 2006 15:04

Odd... I've not gotten it. :( Can you PM it to me?

12 May 21, 2006 15:13

PM'd you with a copy of the email and a link to the file.

¥


Form is loading...