Text only | Text with Images

Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: jmcrey on July 17, 2021, 12:25:25 AM

Title: How do you shrink your database with phpadmin?
Post by: jmcrey on July 17, 2021, 12:25:25 AM
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?
Title: Re: How do you shrink your database with phpadmin?
Post by: Kindred on July 17, 2021, 12:37:27 AM
You can clear unneeded logs.

However, leave godaddy
Title: Re: How do you shrink your database with phpadmin?
Post by: jmcrey on July 17, 2021, 01:04:50 AM
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.
Title: Re: How do you shrink your database with phpadmin?
Post by: Sir Osis of Liver on July 18, 2021, 12:12:28 AM
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.
Text only | Text with Images