×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Unable to Start the Migration

Unable to Start the Migration 6 years 10 months ago #32485

  • Tyson Mike
  • Tyson Mike's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 0
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

Unable to Start the Migration 6 years 10 months ago #32489

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
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

Unable to Start the Migration 6 years 10 months ago #32512

  • Tyson Mike
  • Tyson Mike's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 0
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.

Unable to Start the Migration 6 years 9 months ago #32563

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
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.

Unable to Start the Migration 6 years 9 months ago #32588

  • Tyson Mike
  • Tyson Mike's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 0
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

Unable to Start the Migration 6 years 9 months ago #32589

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
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

Unable to Start the Migration 6 years 9 months ago #32590

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
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
  • Page:
  • 1
Time to create page: 0.172 seconds