• Welcome to Simple Machines Community Forum. Please login or sign up.
September 27, 2021, 09:26:53 AM

News:

Wondering if this will always be free?  See why free is better.


How do you shrink your database with phpadmin?

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

Previous topic - Next topic

jmcrey

Help!

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?

Kindred

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."

jmcrey

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.
"The best laid schemes o' mice an' men / Gang aft a-gley." - Robert Burns

Advertisement: