TOPIC: Unable to Start the Migration

Hi,
I am migrating the data from Drupal to Joomla.
I have two databases - Joomla - by name of - beta_joomlaone
Drupal database name - beta_portal

What should I use in database prefix - I have tried lots of combination - but it never starts.
I have also tried - backing up the - beta_portal and then import it inot beta_joomlaone - but after this - when i try to check - beta_joomlaone - I cannot see any specific table/database by name of beta_portal in this.

It is a bit confusing - Can you please guide me.

Thanks

Hey Mike,

You need to place the tables from the drupal database in the joomla database

In joomla we normally have this #__content the #__ is the prefix and it is normally replaced by a string such as jos_content, mvp_content etc. This prefix is dynamic - it's different for most installation (unless you specify a standard prefix yourself).

On most drupal installations there is no prefix. So the tables are just node, node_relations etc. But on some installations we have lvc_node, lvc_relations or whatever the user decided to enter.

We need to know this prefix and you need to have the drupal tables in the same joomla database.

Regards,
Daniel

Hello,

Thanks for your answer.
So....if i get this correctly - the migration will migrate from one single table at a time - so - content goes into content table ?
Actually - I tried to copy the drupal database - but because of the huge size (probably) - there was an error.
Now...nothing seems to be working.

Well, we don't really need any single table from drupal, but best would be if you can get them all there. After that you can delete them.

Hi Daniel,

Need some clarification.
For example - I have a database in joomla - by name of - "joomlaone" and a database in drupal by name of "portal"
The prefex for both databases is "betamana_"
Now,,,we have a "users" table in "portal" - which has all the information of users and this is the one we would like to migrate in joomla.
Let me know if the following steps are correct:
Step 1 - Backup the "users" table which under "portal" database - and then import this under - "joomlaone"
Step 2 - Go to Cmigrator and under the database prefix user - "betamana_" - and then do the migration.

Thanks

If your tables in joomlaone and portal have the same prefixes, then you won't be able to import the tables, because you'll get table name clashes.

You would have to go in portal and change the table prefixes to something else. Then you can import the portal tables in the joomlaone database. And then you can do the migration.

Regards,
Daniel

Wait what do you mean with prefix for both databases? The prefix for the database name is of no interest. The only interesting thing are the tables inside those databases. What's the prefix there? Do both databases have the same table prefix? If they do -> you would have to change that. If they don't, then you can import the portal tables in the joomlaone database without any issues.

Regards,
Daniel