News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

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
Слaва
Украинi

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.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Advertisement: