SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

How do you shrink your database with phpadmin?

Started by jmcrey, July 17, 2021, 12:25:25 AM

Previous topic - Next topic



Godaddy migrated my site this morning to a new server then promptly disabled my database saying that it was too big.  They've given me 7 days to shrink it from 2GB to less than 1GB using phpadmin.

I'm not a database person and have no idea how to get rid of old posts, users, etc without logging into SMF.

Anyone know how to help me before they delete my data?


You can clear unneeded logs.

However, leave godaddy

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."


Thank you.  I emptied the log_errors and it dropped me down to 28mg.  Clearly I need to do maintenance more often.

Now I just have to wait for support to reactivate my DB.  The wait time is 121 minutes.

Your right, I need a new host site.

Sir Osis of Liver

If you had a 2gb error log, your 1.1 forum is running in php 5.5 or higher.  Depending on php version it will log tons of errors or stop running entirely.  You must upgrade to 2.0.18 asap.

Quote from: Kindred on July 17, 2021, 12:37:27 AM
However, leave godaddy

^ But do this first.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters