Re-import / DB Reset

[itch]

Two q's...

 

1. Is there a way to reset my WHMCS db? I want to remove ALL clients, and ALL invoices in one go.

2. What happens if I run the clientExec import script, then and some more users/orders in clientExec, then run the import script again?

 

As you might have gathered, I got more signups in CE, and now need to re-import the whole thing. Or at least, that's what i want to do.

 

Any help would be greatly appreciated! Thanks in advance!

[penguin]

There is a WHMCS KB article that gives info on how to reset the database, however I've found that this drops things such as product addons and also leaves certain customer data in place. The following SQL query on your database will drop all client data, leaving all your configuration and products in place:

 

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` ;