Update status (publish) of 60000 nodes

I have approximately 60.000 node开发者_如何学Cs 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

Do it with sql.

UPDATE node SET status = 1;

You can use Views Bulk Operations for that.