Jump to content

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

   

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

Important Information

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