Source connection settings are correct but it appears it's the wrong database
Hello:
Trying to convert from Wordpress to Drupal. Both databases are in MySQL on the same server. When using the utility from a remote Windows XP machine, and testing the connections with "Connect to Databases", I can connect to the Drupal DB just fine.
My attempt to connect to the Wordpress DB resulted in the error message in my subject line. Can you tell me a bit what conditions the utility checks to test whether it is the "wrong database"? Could the fact that they are on the same server be my problem? My Wordpress tables are all named differently, with a topic_subject naming convention.
Thanks in advance.
Actually, that's not quite true. When installing Wordpress, that's when you decide if a table prefix is appropriate or not. The default is "wp_" though you can name the prefix anything you want. If you wanted to name the prefix "w", without a trailing underscore, you could.
I believe the prefixing of table names dates back to the days when user's were restricted to only one database and so to group the various application tables a prefixing system was adopted.
These days, it's far simpler to create a database per application.
I don't know enough about Wordpress to really address the nuts and bolts here, but I can tell you more about my own experience. We had a Wordpress site that we basically inherited and need to migrate to Drupal. Within the Wordpress site, there are DB tables with different prefixes. Some are called, for example, "aa_tablename". Others are called "bb_tablename". The prefixes in our case may or may not have been specified at the time Wordpress was installed. But for general purposes they seem to have been used to delineate one blog from another.
In any case, when using this tool, we need to migrate one set of tables at a time per prefix. And, indeed, in the Converter GUI, the underscore character must be included. So in my example, "aa" would not work as a table prefix; "aa_" would.
And, to be perfectly clear, I'm not addressing how Wordpress is installed, only how we used the Wordpress to Drupal utility. When using the utility, it seems necessary to add that underscore when prompted for the tablename.
I feel silly for missing this, but all values in the "Table prefix" textbox of the converter GUI must end in an underscore character ("_").
Hopefully my folly will assist others.
Cheers.