WHM rebuild bandwidth db

 

1. Run the rebuild_bandwidthdb_root_cache script.

   /usr/local/cpanel/scripts/rebuild_bandwidthdb_root_cache

   Please note that the script will process bandwidth for every user on the server and not just the user you wish to manage.

Introduction

On occasion, you may need to reset a user's bandwidth to 0 before the end of the month. This article provides the procedure to reset a specific user's bandwidth to 0 for the month.

 

Procedure

1. Access the server's command line as the 'root' user via SSH or "Terminal" in WHM.
2. Move aside the user's bandwidth database file.

   mv -v /var/cpanel/bandwidth/$username.sqlite{,.$(date +%s)}

   Please note that "$username" must be replaced with the cPanel user's username.
3. Move aside the user's bandwidth cache file.

   mv -v /var/cpanel/bandwidth.cache/$username{,.$(date +%s)}

   Please note that "$username" must be replaced with the cPanel user's username.
4. Run the rebuild_bandwidthdb_root_cache script.

   /usr/local/cpanel/scripts/rebuild_bandwidthdb_root_cache

   Please note that the script will process bandwidth for every user on the server and not just the user you wish to manage.