How do I reset my WHMCS's database after testing, and making it ready for production use?

After you have done your tests on your new WHMCS installation, you may want to remove all dummy clients, invoices, products, etc

You can TRUNCATE the following database tables:

TRUNCATE `tblaccounts` ;
TRUNCATE `tblactivitylog` ;
TRUNCATE `tbladminlog` ;
TRUNCATE `tblaffiliates` ;
TRUNCATE `tblaffiliatesaccounts` ;
TRUNCATE `tblaffiliateshistory` ;
TRUNCATE `tblaffiliatespending` ;
TRUNCATE `tblbrowserlinks` ;
TRUNCATE `tblcancelrequests` ;
TRUNCATE `tblclients` ;
TRUNCATE `tblcontacts` ;
TRUNCATE `tblcredit` ;
TRUNCATE `tblcustomfieldsvalues` ;
TRUNCATE `tbldomains` ;
TRUNCATE `tbldomainsadditionalfields` ;
TRUNCATE `tblemails` ;
TRUNCATE `tblgatewaylog` ;
TRUNCATE `tblhosting` ;
TRUNCATE `tblhostingaddons` ;
TRUNCATE `tblhostingconfigoptions` ;
TRUNCATE `tblinvoiceitems` ;
TRUNCATE `tblinvoices` ;
TRUNCATE `tblnotes` ;
TRUNCATE `tblorders` ;
TRUNCATE `tblticketlog` ;
TRUNCATE `tblticketnotes` ;
TRUNCATE `tblticketreplies` ;
TRUNCATE `tbltickets` ;
TRUNCATE `tblupgrades` ;
TRUNCATE `tblwhoislog` ;

Use phpMyAdmin in your cPanel to TRUNCATE these tables.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I put WHMCS in Debug mode?

Add the following line to your {WHMCS root}/configuration.php file: $display_errors="on"; 

How to debug WHMCS SMTP problems

If you're having problems with SMTP in WHMCS, you can put the following code to...

Where can I download WHMCS from?

You can download the latest version of WHMCS from our downloads page....