Importing from b2?

One way to do this would be to start with WordPress in a directory of it’s own.
Do the import, get everything looking just fine, then move it to root.
You could double post to each blog for the short time it took if you wanted, and you have the advantage of keeping any ‘issues’ away from the public view 🙂

I’m getting a similar issue trying to import files from b2 to WordPress. I’ve got things set up properly after running install.php, such that I’ve got a usable, albeit separate, instance of WordPress from my b2 data and document root. Running the import-b2.php script, step 1 seems to work, but step 2 has numerous errors. My existing site is available at http://blog.netho.net/ for anyone who wishes to give it a look. Thanks.
[output from step 2 below]
First we’re going to add excerpt, post, and password functionality…
Database error: [Duplicate column name ‘post_excerpt’]
ALTER TABLE wp_posts ADD COLUMN post_excerpt text NOT NULL;
Database error: [Duplicate column name ‘post_status’]
ALTER TABLE wp_posts ADD post_status ENUM(‘publish’,’draft’,’private’) NOT NULL, ADD comment_status ENUM(‘open’,’closed’) NOT NULL, ADD ping_status ENUM(‘open’,’closed’) NOT NULL, ADD post_password varchar(20) NOT NULL;
That went well! Now let’s clean up the b2 database structure a bit…
Database error: [Can’t DROP ‘ID’. Check that column/key exists]
ALTER TABLE wp_posts DROP INDEX ID
One down, two to go…
Database error: [Table ‘b2.wp_settings’ doesn’t exist]
ALTER TABLE wp_settings DROP INDEX ID
So far so good.
Database error: [Can’t DROP ‘post_karma’. Check that column/key exists]
ALTER TABLE wp_posts DROP post_karma
Almost there…
Database error: [Can’t DROP ‘ID’. Check that column/key exists]
ALTER TABLE wp_users DROP INDEX ID

I tried that link, and I’m still getting errors… I have no clue what I’m doing wrong because I followed the instructions 🙁

I figured it out… if anyone else has problems, I could probably walk them through.

all, I think I’m running into similar problems importing B2… can anyone help? I have b2 and wordpress in separate databases. I run the import-b2.php file and it seems all good, gives me the same errors in step 2 which I was led to believe I can ignore, and gives me the “welcome to the family” link… I click on that, it takes me to my admin interface and there’s no sign of my posts having been migrated in.

I’m kind of new to this, but I’ve gone through this frontwards and backwards and can’t find the problem.

Thanks!

thanks for the offer… i “figured it out” more or less.

cheers.