KNK Posted January 5, 2023 Share Posted January 5, 2023 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 Link to comment Share on other sites More sharing options...
othellotech Posted January 14, 2023 Share Posted January 14, 2023 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.