Update status (publish) of 60000 nodes

Question

hi

I have approximately 60.000 nodes in my Drupal installation.

They are all unpublished, and I need to publish all of them. I'm trying to publish them from "Content menu" but I can only select all nodes in a single page.

How can I select all nodes in my website ?

thanks

Answer 1

Do it with sql.

UPDATE node SET status = 1;

Answer 2

You can use Views Bulk Operations for that.