KNK 0 Posted January 5 Hey. My current WHMCS database is messy and broken due my fault. Orders ID are messed, and invoices show deleted bc I deleted them instead of cancelling etc... I plan 2 make a new WHMCS install and just copy the customers data. Do I just need to export: tblclients to move the active clients? Because on the page: admin/clients.php I have 177 Records Found and on admin/user/list I have 372 Records Found (How do I delete all this users that don't have an account?) Also, once I move the clients table to the new WHMCS database is it possible to copy their services/products as well or I need to create a new order for each once I move them?Thank you, guys. 0 Quote Share this post Link to post Share on other sites
othellotech 5 Posted January 14 You don't need to start again, clearing (trunc) the orders, invoices, hosting, domains, accounts tables and use sql (or whmcs config) to set what the next id/numbers should be - this is simpler than trying to pull selective data over. As to tidying users - yes. delete from tblusers_clients where there is no matching tblclients.id to client_id then delete from tblusers where there is no matching tblusers.id to auth_user_id 0 Quote Share this post Link to post Share on other sites
