Prime 357

We'll learn something

Site Menu

  • Home
  • Recent Posts
  • Forum
    • Programming Languages
      • C++
    • Website Design & Content Management
      • Wordpress >> Drupal
  • Blogs
  • Topics
    • C++
    • Changing hosts - Dummies Guide
    • Wordpress >> Drupal
  • Download Centre
  • Contact us
Home Wordpress to Drupal Wordpress 2.5 Program - Converter


Image - OpenID

User login

What is OpenID?
  • Log in using OpenID
  • Cancel OpenID login
  • Create new account
  • Request new password

Navigation

  • Recent posts

Topics

  • C++ (The Book)
  • Changing Hosts - a Dummies Guide
  • Wordpress to Drupal
    • Wordpress 2.1 - 2.2
    • Wordpress 2.5
      • General Requirements
      • Program - Converter
        • Connect to MySql Databases
          • Logging into a Remote Database
        • Import
        • Importing Progress
      • Search and Replace
      • Explanation of Import
      • Versions

Recent comments

  • Thanks..
    37 weeks 6 days ago
  • Hmmm,Interesting one,thx for
    39 weeks 10 hours ago
  • Buyer beware
    39 weeks 6 days ago
  • REPLY:Actual Processes Involved
    40 weeks 9 hours ago
  • Back to Ruby
    49 weeks 2 days ago
  • Links provided
    1 year 12 weeks ago
  • Module for wordpress to Drupal 6.x
    1 year 12 weeks ago
  • The wordpress plugin looks
    1 year 14 weeks ago
  • Good point..... You're
    1 year 14 weeks ago
  • Many thanks. If I'm going to
    1 year 14 weeks ago

New forum topics

  • Imported posts only visible to user1
  • What should the port number be
  • WordPress MU?
  • funny little bug in mac version
  • Error: Unable to Insert into Node_revisions table when converting from wordpress 2.6.0 to drupal 6.4
more

Sponsored links

Steve's Stuff
All about my running and from time to time other stuff

Improve Memory
All about memory techniques, excellent and relevant articles.

Connect to MySql Databases

Submitted by Steve on Thu, 17 Apr, 2008 - 22:08
  • CMS
  • converter
  • Drupal 5.x
  • Drupal 6.x
  • MySql
  • Wordpress 2.5

Before any importing can be done a connection must first be made to both the Wordpress and Drupal databases. From the main opening window, clicking the 'Continue to Importer Form' button will open the connection form (if a connection hasn't already been established) or purposely clicking 'Connect to Databases' button.

Image - Wordpress Connection Screen

All connection details must be entered correctly and connection is established via clicking the 'Connect' button. When successful connections have been established to both databases only then will the 'OK' button become active. Clicking the 'OK' button will progress the user to the 'Importing' screen.

Please be aware that upon successful connection the connection settings are saved in a text file (connect.txt) in the same directory where this program resides. This 'connect.txt' file is insecure in that the passwords are easily determined. If this file is present upon loading then the connection settings are automatically filled in.

The following is a brief description of the information required.

Version

Select the appropriate Wordpress and Drupal versions. As of this writing only Wordrpess version 2.5 is available and for Drupal you have a choice between 5.x and 6.x.

Image - Drupal Connection Screenshot

Host

If accessing the MySql database remotely, that is, on a hosted server, somewhere, other than your computer, then you will need to input the IP number. If you are unsure of the IP number it can be found at your hosting administration site (CPanel), failing that, your hosting company can provide it.

If you are accessing the MySql database locally, that is, on your home computer, then 'localhost' should suffice. If 'localhost' doesn't work then '127.0.0.1' will.

Port

The default is '3306'. Regardless of whether you are accessing your MySql database remotely (across the internet) or locally (on your computer) the number will probably be '3306'. If not, your hosting company can provide the correct figure.

Database Name

The name of the MySql database file of either the Wordpress or Drupal database (depending upon whether your at the 'source' or 'target' connection setting tab. If unsure, simply check the relevant 'config' or 'settings' php file from either system.

Username

Enter the 'Username' that has access rights to the database. Again, if unsure, check the 'config' or 'settings' php file from either system for confirmation. If you are accessing the MySql database files locally, that is, on your computer, and have installed MySql with all default settings, then the odds are that the user name will be 'root' and no password.

Password

Self-explanatory. If unsure check the 'config' or 'settings' php file from either system for confirmation.

Table Prefix

If your database (Drupal, Wordpress) was setup with the inclusion of table prefixes, then the correct table prefix must be entered. If no prefixes then no entry is required.

  • Logging into a Remote Database
‹ Program - Converter up Logging into a Remote Database ›
  • Printer-friendly version
  • Add new comment
  • 2474 reads
Fri, 25 Apr, 2008 - 06:05
#1
axelseap (not verified)
just thought i'd leave this

just thought i'd leave this useful tidbit for others.

i tried this on a linux machine and for some reason it cannot connect when the host is localhost, however i was able to make it work using 127.0.0.1 for the host

Top
  • reply
Fri, 25 Apr, 2008 - 16:33
#2
Steve
User offline. Last seen 6 days 5 hours ago. Offline
Joined: 27 Mar 2008
/etc/hosts

Thanks for that advice and I'll update this aspect in the main page above.

I'm not a Linux expert but I'm half assuming that if you type into your browser 'localhost' then nothing should occur either. If you check localhost Definition it explains things better than I could.

Here's an excerpt

The name for the loopback address can be changed by the root account (i.e., administrative user) by editing the /etc/hosts file with a text editor, such as gedit or vi.

I hope this helps.

Steve
Steve's Stuff
Improve Memory

Top
  • reply
Fri, 25 Apr, 2008 - 23:35
#3
axelseap (not verified)
actually the baffling part is

actually the baffling part is that typing localhost into the browser does work.

Top
  • reply
Sat, 26 Apr, 2008 - 00:27
#4
Steve
User offline. Last seen 6 days 5 hours ago. Offline
Joined: 27 Mar 2008
Somehow I thought you might

Somehow I thought you might come back with that. I'm in the process of getting my Apache, MySql & PHP running on my Linux machine so I'll keep this in mind.

Steve
Steve's Stuff
Improve Memory

Top
  • reply
Wed, 25 Jun, 2008 - 05:36
#5
intheloop (not verified)
Error excecuting program under Linux

Hi! Sorry if this is the wrong place to ask for help, but I am trying to use the WP to Drupal converter on Linux (Ubuntu 8.04.) I gave the program execute permissions and tried to excecute it, but I get this error:

Runtime Error 4: Failed Assertion
Press OK to Continue
Press Cancel to Quit.

Please report what caused this error
along with the information below.

../Common/plugin.cpp: 6893
Failure Condition: 0
The application cannot continue because a needed file cannot be installed. libstdc++.so.5: cannot open shared object file: No such file or directory

Thanks for the program, hope I can make it work!

Top
  • reply
Wed, 25 Jun, 2008 - 10:08
#6
Steve
User offline. Last seen 6 days 5 hours ago. Offline
Joined: 27 Mar 2008
Ubuntu Linux

Have a look at this thread as I came across this exact same issue when testing on my virtual Linux install (Ubuntu 7.x). Hope this helps.

Steve
Steve's Stuff
Improve Memory

Top
  • reply
Wed, 25 Jun, 2008 - 11:54
#7
intheloop (not verified)
Thanks! That worked and the

Thanks! That worked and the process appears to have been generally successful. I am going to look in more detail at what worked and what didn't, but here are a few quick observations:
- (In the converter program) Under Ubuntu 8.04 with a custom theme, there is a minor interface glitch, such that the full content of the drop down menu is not visible. This is not a major issue, just a minor annoyance
- Images appear to not have been correctly converted. I don't know, however, if the problem is just broken paths. I will check later.
- Code to embed small badges, specifically from the Ubuntu Brainstorm website, does not appear to have been imported successfully.

On first glance, it looks like everything else worked great, though. Thanks for the great work on this program, it saved me hours of copy and pasting!

I will probably report back later with more details.

Top
  • reply
Sat, 28 Jun, 2008 - 13:14
#8
intheloop (not verified)
I don't know what was going

I don't know what was going on at that time, but images and the Brainstorm code both seem to be working now.

Top
  • reply
  • Post reply

 Subscribe in a reader

free hit counter


RoopleTheme