Jump to content

netnow

Members
  • Content count

    4
  • Joined

  • Last visited

Community Reputation

0 Neutral

About netnow

  • Rank
    Newbie
  1. netnow

    WHMCS Deletion.

    Thanks for taking the time to reply Chris ... please review my 3rd post up. I am going to give it a try. I am assuming that if I remove the connection to the WHM servers the SQL commands will still be able to complete correctly. The only other question I can think of is: Is the list of tables to truncated complete? (i.e. up to date with the current version of WHMCS)?
  2. netnow

    WHMCS Deletion.

    Yes, I want to keep WHMCS config, connections etc, but want to remove all client data, including test invoices/transactions, then, start re importing them a few at a time.
  3. netnow

    WHMCS Deletion.

    Under the maintenance section, I found these SQL commands. It appears to be exactly what I want to do - reset, (empty), the client database in WHMCS only, leaving all the clients in tact on the WHM servers, maintaining all the WMHCS config settings and products. Should be as simple as creating an sql file and running it against the WHMCS database. Has anyone tried this? Any further tips? " TRUNCATE `mod_invoicedata` ; TRUNCATE `tblaccounts` ; TRUNCATE `tblactivitylog` ; TRUNCATE `tblaffiliates` ; TRUNCATE `tblaffiliatesaccounts` ; TRUNCATE `tblaffiliateshistory` ; TRUNCATE `tblaffiliatespending` ; TRUNCATE `tblaffiliateswithdrawals` ; TRUNCATE `tblbillableitems` ; TRUNCATE `tblcancelrequests` ; TRUNCATE `tblclients` ; TRUNCATE `tblclientsfiles` ; TRUNCATE `tblcontacts` ; TRUNCATE `tblcredit` ; TRUNCATE `tblcustomfieldsvalues` ; TRUNCATE `tbldomains` ; TRUNCATE `tbldomainsadditionalfields` ; TRUNCATE `tblemails` ; TRUNCATE `tblhosting` ; TRUNCATE `tblhostingaddons` ; TRUNCATE `tblhostingconfigoptions` ; TRUNCATE `tblinvoiceitems` ; TRUNCATE `tblinvoices` ; TRUNCATE `tblnotes` ; TRUNCATE `tblorders` ; TRUNCATE `tblquotes` ; TRUNCATE `tblquoteitems` ; TRUNCATE `tblsslorders` ; TRUNCATE `tblticketlog` ; TRUNCATE `tblticketnotes` ; TRUNCATE `tblticketreplies` ; TRUNCATE `tbltickets` ; TRUNCATE `tblupgrades` ;"
  4. netnow

    WHMCS Deletion.

    I need to be clear about: When I use the 'Delete client" link in the WHMCS Client Summary page, does it ONLY delete WHMCS data ? i.e. does abssolutely nothing to the hosting account on the WHMCS - > WHM server? As a side note, if anyone uses the Quickbooks plugin, does "Deleting' a client from WHMCS also so anything to the connected quickbooks account? -H
×

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated