WHMCS Database too large

[techforever92]

We tried to run daily cron and the cron successfully starts but it does not complete successfully.

 

I contacted WHMCS regarding the same and they replied saying that WHMCS can handle upto 20 mb data and our database was around 16GB in size so it couldn't proceed further with the request.

 

They suggested to reduce the size of the database table "tblticketreplies" but we have all our tickets in that database so if we delete the tickets then how will we get the history of all the deleted ticket conversions.

 

Is there any alternative way where I can restore my deleted ticket conversions or I can move my existing tickets to some other destination after I delete "tblticketreplies".

 

I would be glad if I receive a positive reply.

 

Thank you.

[PropelMWS]

Hell techforever92,

 

That is indeed a very large WHMCS database. One of my clients had a similar problem.

 

(1) Separate your 1 cron job into smaller cron using option flags (do_ and skip_)

 

(2) If you have 16GB of data then you have Years and Years of old (never seen or accessed tickets)

- create a new db table and copy over all your ticket data. (not seen by WHMCS cron)

- Run a query against your existing tickets and delete all tickets older than 2 years ago. (If you do not know how to do this without an explanation then I highly recommend that you do not try it on your own)

 

Result = Your database will be alot smaller, you retain "relevant" (2 years) ticket data for everyday search/usage and your have a permanent archive of All your old ticket data. Oh and your cron works better by separating it from one large cron into smaller crons.

 

Let me know how that works for you and if you need any additional help.

 

Best,

Trevor~

[easyhosting]

you could also do a daily backup of your whole site via rsync or cpremote to a backup server. this will backup your site, your WHMCS and all your databases