Importing WP Entries

butuki · 2005-03-08 06:47:31

I’m running several CMS applications at the moment, trying to see which one fits the bill the best. So far TextPattern, b2Evolution, and WordPress are running pretty close, with TextPattern definitely the most promising.

Finding the information and the tools necessary to import my old MT entries has definitely been easiest with WordPress. I’ve managed to set up the entire old blog with most of the old comments intact (my server suffered a major systems failure and then went bankrupt and lost most of my data before I could retrieve it).

Now I want to import all the entries I have over at the WordPress site into my TextPattern installation. I’ve looked all over the Net for information on how to do this and it is convoluted at best. I managed to download the WP Importer script that Dean wrote last year, but it is the 0.2 version and I have no idea if there is a newer, updated version.

I have my WP MySQL database zipped and downloaded onto my computer… may I ask what I must do next?

Thanks for the help.

Jai · 2005-03-08 07:13:02

RC3 has an import option for Wordpress, MT and others under the Admin tab. The WP import worked just fine for me… G’luck.

Jai

butuki · 2005-04-29 13:38:55

Gave importing WP entries a try again, this time through TextPattern rc3. I’ve imput all the proper information in the import page fields, but keep getting this error message:

<em>Warning: mysql_connect(): Access denied for user: ‘butuki_wrdp1@localhost’ (Using password: YES) in /home/laughing/public_html/textpattern/include/import/import_wp.php on line 10</em>

And:

<em>max_execution_time = 330
wp database values don’t work. Go back, replace them and try again</em>

The database values are all okay, except I’m not sure about putting “localhost” here, since I am accessing my mySQL database from another server. Should I be changing that value?

Woud appreciate any advice. I’ve posted this question a number of times but never really got any helpful suggestions.

Thanks.

miguel

Jai · 2005-04-29 14:52:27

Butuki: Yes, localhost if for your local machine. You could do an MySql dump from the other server, download it to the local machine, set up the WP database, and then use the import script. That’s how I did it.

Joakim: I imported multilingual content without problems — I suspect the WP and TxP database charsets don’t match. I use utf-8 on both ends, and have no problems.

Hope this helps.

butuki · 2005-04-29 15:23:27

Thanks Jai. I will give the MySql dump a try. Just curious. When you say set up the WP database, do you mean in the TextPattern import window? I can’t think of what other action it might mean.

Again, thanks for your suggestions.

Jai · 2005-04-29 18:04:22

Ah, sorry — you would need to set up the WP database tables, which means setting up WP locally (if you don’t have it already), and then importing the MySql dump into the local database. (This is because the TxP import script has SQL statements that access specific tables and fields in the WP database, and then uses the accessed data to populate corresponding tables and fields in the TxP database.) After that you’d just do what you did before with the TxP import tab (localhost, password, WP database name, etc.). Best,

carla · 2005-09-21 22:46:28

I’m receiving the same error (Warning: mysql_connect(): Access denied for user: ‘@localhost’ (Using password: YES), which I don’t understand, since the Textpattern db has the same host settings (same server, so “localhost”). Any other odd reason this error might appear when trying to import? Thanks. :)

tomklaver · 2006-02-13 07:58:30

I can get into phpMyAdmin, someone created a DB dump for me, now what do I do to import my Wordpress files?

Thanks.

carla · 2006-02-13 15:13:44

> tomklaver wrote:

> I can get into phpMyAdmin, someone created a DB dump for me, now what do I do to import my Wordpress files?

Go to http://www.yourdomain.tld/textpattern/index.php?event=import. Choose Wordpress from the “import from” drop-down menu, and then choose into which section you’d like to import these entries, and what you’d like the default invitation to leave a comment to read. I’m uploaded a screencapture of my TXP import page for reference to Flickr:
<a title=“clicky” href=“http://flickr.com/photos/hauntedpalace/99247109/”><img src=“http://static.flickr.com/30/99247109_f9eca12850_t.jpg” /></a>

tomklaver · 2006-02-13 18:04:43

Thanks a LOT for helping!

carla · 2006-02-13 18:21:53

> tomklaver wrote:

> Thanks a LOT for helping!

You are so welcome! So it all worked okay? Good!

Textpattern CMS

Textpattern CMS support forum

#1 2005-03-08 06:47:31

Importing WP Entries

#2 2005-03-08 07:13:02

Re: Importing WP Entries

#3 2005-04-29 13:38:55

Re: Importing WP Entries

#4 2005-04-29 14:52:27

Re: Importing WP Entries

#5 2005-04-29 15:23:27

Re: Importing WP Entries

#6 2005-04-29 18:04:22

Re: Importing WP Entries

#7 2005-09-21 22:46:28

Re: Importing WP Entries

#8 2006-02-13 07:58:30

Re: Importing WP Entries

#9 2006-02-13 15:13:44

Re: Importing WP Entries

#10 2006-02-13 18:04:43

Re: Importing WP Entries

#11 2006-02-13 18:21:53

Re: Importing WP Entries

Board footer