By blb2397 on

Hi,
Newbie here
I have a SQL database with content and I want to add pages (nodes) to my new Drupal site. I want to add the pages with some SQL but I am not sure how. What records/fields in Drupal need to be updated? Ideally I can add several or all the pages from the old database all at once with a sql query. Sorry if it is not to clear but I am still learning.
Thanks All!

Comments

lhtown’s picture

lhtown commented

It is possible, but it is really easy to goof things up.

I haven't done it, but be aware that you will have to manually increment the autoincrement value that counts what number of post to add next so that you don't have two posts with the same number.

If you are talking about a few dozen or even a few hundred pages, it is probably a lot easier to add them the old fashioned way.

If you have your pages in the form of a database or csv file, there might be a module that could help you.

ggarry’s picture

ggarry commented

I am still new to drupal so can't help. If someone doesn't help you what I would do is download the database then add content download again and compare the files with http://www.prestosoft.com/edp_examdiff.asp or something similar.