Advertisement:

Author Topic: How do you shrink your database with phpadmin?  (Read 421 times)

Offline jmcrey

  • Newbie
  • *
  • Posts: 5
How do you shrink your database with phpadmin?
« 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?

Offline Kindred

  • The Mean One
  • Lead Support Specialist
  • SMF Legend
  • *
  • Posts: 60,434
  • Gender: Male
    • Kindred-999 on GitHub
Re: How do you shrink your database with phpadmin?
« Reply #1 on: July 17, 2021, 12:37:27 AM »
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."

Offline jmcrey

  • Newbie
  • *
  • Posts: 5
Re: How do you shrink your database with phpadmin?
« Reply #2 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.

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 11,133
  • We were all equal in the end.
Re: How do you shrink your database with phpadmin?
« Reply #3 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.

However, leave godaddy

^ But do this first.
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns