Are log files in drupal take a lot of space? I want to create a dump file but it's over 1000mb. What tables can be harmlessly emptied from the database directly or through drupal interface?

1 Answer 1


Usually all tables with cache_ prefix are safe to be emptied.

The log table records can take a lot of space, depending on your settings on how many log messages you want to save. You can configure this at admin/config/development/logging.

How many nodes/users do you have on the website? Do you have enabled the core search module? What other modules do you have?

If your website has tens of thousands of nodes and users, 1GB is a normal size of the database dump.

  • I have enabled many modules: views, panels, search, context, video, music and others. But I did what you said sir and my dump really got smaller. Thanks! Nov 5, 2012 at 20:32
  • You are welcome :) If this solved your problem, click on the green checkmark right next to the answer to accept it as a solution. Nov 6, 2012 at 6:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.