Drupal 5.x
45,000 Wordpress posts converted to Drupal
Okay, the title said 45,000 posts but in reality how does converting or transferring, call it what you want, 45,936 posts from Wordpress 2.5 to Drupal 5.8 sound. I helped out a registered user HitBoy with the conversion, that is, I did it on my machine locally for him. Before I go any further here's a screen-shot of the Analyse Wordpress section.

I didn't specifically time the process but I reckon it was closer to the two hour mark than it was to the one hour mark, so transferring 45,000 posts is not a 5 minute process. Obviously, if done using remote databases it would take a little longer. How much longer, well I don't know and I'd only be guessing.
HitBoy's going to make a follow-up entry in Check My Site thread and there he'll promote his site, so at least you can see that it is possible to convert massive amounts of data.
During this process I was chatting to HitBoy about other things, as you do, and found out that he's starting a new venture, a hosting business. If you're after some free (or paid) web-hosting why not check him out at OpenSourceSetup. His site went live yesterday (Monday 29 July, 2008).
The link I provided IS NOT an affiliate link and I do not benefit in any way.
- 5 comments
- Read more
- 524 reads
Logging into a Remote Database
Okay, so you know all the connection details in order to connect to remote MySql databases and yet the converter claims it can't make a connection.
In order to connect to your remote MySql database(s) you need to activate the 'allow remote connections' setting at your server. If 'allow remote connections' is switched off, a connection will never be made.

Using cpanel as a guide, navigate to your database section and select "Manage Remote MySql Access". At the following screen merely enter your home computer IP address as an 'Access Host'. To simplify things further entering a % key will allow access to your MySql database from any computer.
If you can't find such a setting your hosting provider should be able to help.
Version 1.04 - available for download
1.04
Bug fixes and enhancements for Version 1.04.
|
Item
|
Issue
|
Description
|
|
1
|
1
|
Node Title and Comment Name - now correctly display symbols where before in certain cases HTML code was displayed. A secondary text file is included with the program. It is to reside in the same directory as the program. This file contains the relevant codes to be translated.
|
|
2
|
2
|
Comment headings now created (now enables comment links)
|
|
3
|
3
|
Comment thread field now correctly populated with Base 36 number system, previously was Base 10 (decimal). I doubt this was a cause of any dramas, it's just that I recently became aware of it.
|
|
4
|
4
|
Filter format option for comments. Same as for nodes, which was introduced in 1.03
|
|
5
|
|
|
|
|







Recent comments
2 weeks 5 days ago
2 weeks 5 days ago
4 weeks 2 days ago
4 weeks 2 days ago
4 weeks 2 days ago
4 weeks 2 days ago
4 weeks 3 days ago
4 weeks 3 days ago
4 weeks 3 days ago
4 weeks 3 days ago