Deleting Forums Using Mysql

Deleting forum from drupal, only delete terms, if you want to delete all its nodes, comments and terms from database, truncate the follwing tables from Drupal Database.

truncate comments;
truncate content_type_forum;
truncate forum;
truncate node;
truncate node_revisions;
truncate term_data;
truncate term_hierarchy;
truncate term_node;
truncate users;
truncate node_comment_statistics;

Other Option if you want to drop all the tables at once to restore the new data


drop table comments, content_type_forum, forum, node, node_revisions, term_data, term_hierarchy, term_node, users, node_comment_statistics;

Comments

Post a Comment

Popular posts from this blog

How to Reset Root Password in Drupal 7 with phpMyAdmin

Image
Copy the hash.. $S$C6x2r.aW5Nkg7st6/u.IKWjTerHXscjPtu4spwhCVZlP89UKcbb/ (that’s the hash for newPassword ).   Navigate to your phpMyAdmin (likely in your control panel online somewhere). Then browse the User table for the Root user, look like his. Take the copied hashed text and paste it into the pass field of the Root user and hit “Go”. See this If you want to reset Drupal pasword using Drush .
Read more

Syntax Highlighting with Blogger Engine

I was trying to style the code snippets highlighted as code as developer in my blog. Did it using some custom css but no positive impression. Recently googling, found an article abt that here . This can be done using syntaxhiglighter . Drop this code right before your </head> tag... and save. And here is the way how you can use it. 1. Using <script> tag with CDATA This will output.... // Commenting this function function custom_one($var) { if($one == $two) { $three = array( 'one', 'two' ); } } 2. Using the <pre> tag. // Commenting this function function custom_one($var) { if($one == $two) { $three = array( 'one', 'two' ); } } This will output.... // Commenting this function function custom_one($var) { if($one == $two) { $three = array( 'one', 'two' ); } }
Read more