Drupal: importing thousands of lines from a mysql database. Easy ?

Question

hi,

I need to import a big databases into Drupal CCK nodes.

Let's say I have 1 million of lines to import. Each line is a Drupal node, and each field is a CCK field. (this is the mapping I have in mind).

Is this something risky to do, or do you think I can easily import the data in my new Drupal installation ?

Could you suggest me tools or modules for the import ? (the original database is Mysql.. should I perform some intermediate step such as export the database files to text files.. or.. ? )

thanks

Answer 1

This can be pretty easy. You should use the migrate, migrate extras, table wizard, schema and views. You setup the tables that you need to import in table wizard. In Migrate you create import jobs and map the fields. And then you can run the import job. It is surprisingly easy. The migrate extras enables importing more cck fields like filefields. You can also run the imports from drush so you don't run into the execution time limit.

There is also a great tutorial over at lullabot. http://www.lullabot.com/articles/drupal-data-imports-migrate-and-table-wizard