I realize that the database username has to be the same in both the vB and the Drupal database.

However, with GoDaddy they do not allow the same username in two databases. I even tried with a different GoDaddy account and it doesn't allow it.

I'd appreciate finding a way to get around this restriction.

Comments

liam mcdermott’s picture

liam mcdermott commented
Status: Active » Closed (works as designed)

Sorry you're in a bad situation with GoDaddy and vBulletin to Drupal, if there were a simple way to code around the problem of needing access to two databases, I would have implemented it!

However, vBulletin to Drupal selects and inserts records to and from databases in the same SQL query. It literally says to MySQL, 'Take this stuff from the vBulletin database and dump it into the Drupal one.'

We could shift all the data using PHP: pull one row (or several rows) from the vBulletin database, switch to the Drupal database and paste. The problem is that this approach is very slow, which is why we can't use it.

So sorry there's no work-around in vBulletin to Drupal. My advice is to take a backup of your vBulletin database, put it in a MySQL database on your own computer, set up Drupal and vBulletin to Drupal and run the import from your computer.