Connect to MySql Databases
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.
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.
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
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.