By bw1drup on

This is a general question on the best practices for editing a Drupal site directly by editing the mysql database.
One of my sites had an issue with the people 'user' table over 46k mostly bots from before finding a good bot blocker.
All the suggested solutions proved difficult ( ie Delete_All module and views_bulk_operations module ).
Since I am the only content editor ( no other conflicting users ) editing all the bot through the MySQL database SQL Delete seemed to work well.
Could someone suggest just what you can or should not do via MySQl editing?

⋅ Categories: Drupal 7.x

Comments

nevets’s picture

nevets commented

In general it is a bad practice to edit the database tables directly. In this case if the bots could create content, deleting the user directly will leave "orphaned" content in the database. In general, you risk only cleaning of problem while creating a bigger one.