What Records Can I Delete With phpMyAdmin?

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
abrogard
Registered User
Posts: 329
Joined: Tue May 24, 2005 8:32 am
Location: australia
Name: arthur brogard

What Records Can I Delete With phpMyAdmin?

Post by abrogard »

I have a site I cannot access because I've exceeded the measly space allocation for the sql database provided by my hosting company. 70MB would you believe.

All I can do is delete records using phpMyAdmin.

Are there any records or perhaps even whole tables that it will be safe for me to delete in that way enough to create space so's I can get in and do it all properly?
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52768
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: What Records Can I Delete With phpMyAdmin?

Post by stevemaury »

All three search_* tables.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
abrogard
Registered User
Posts: 329
Joined: Tue May 24, 2005 8:32 am
Location: australia
Name: arthur brogard

Re: What Records Can I Delete With phpMyAdmin?

Post by abrogard »

That's good to know. Thanks very much for that.

:)
User avatar
2600
I've Been Banned!
Posts: 2567
Joined: Fri Nov 14, 2014 5:14 pm
Location: Area-51

Re: What Records Can I Delete With phpMyAdmin?

Post by 2600 »

Or you could prun old posts.
Morpheus: Unfortunately, no one can be told what The Matrix is. You'll have to see it for yourself.
Hack me.
Consider a canary token.
The nature of my chosen username
:ugeek:
User avatar
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco
Contact:

Re: What Records Can I Delete With phpMyAdmin?

Post by 3Di »

John connor wrote: Mon Jun 18, 2018 2:51 am Or you could prun old posts.
abrogard wrote: Sun Jun 17, 2018 10:32 pm I have a site I cannot access
:mrgreen:
🆓 Free support for our extensions also provided here: phpBB Studio
🚀 Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52768
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: What Records Can I Delete With phpMyAdmin?

Post by stevemaury »

Just to clarify, truncating the search tables will disable the search function, but they can be rebuilt at any time.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
abrogard
Registered User
Posts: 329
Joined: Tue May 24, 2005 8:32 am
Location: australia
Name: arthur brogard

Re: What Records Can I Delete With phpMyAdmin?

Post by abrogard »

Thanks for that clarification.

I thought it must be something like that.

But I think what I really need is a host who provides more space. 70MB just isn't enough even for minimally active sites like mine.
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52768
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: What Records Can I Delete With phpMyAdmin?

Post by stevemaury »

Exactly correct.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
User avatar
eeji
Registered User
Posts: 1461
Joined: Fri Dec 12, 2008 9:08 pm
Location: Manchester, UK
Contact:

Re: What Records Can I Delete With phpMyAdmin?

Post by eeji »

the phphbb_sessions table can also get quite large, this is also safe to truncate. Also optimise any tables with overhead - this may not release much space, but every little helps.
My phpBB styles: phpbbstyles.iansvivarium.com
My "board": iansvivarium.com
(yes, it's running phpBB!)
User avatar
Lumpy Burgertushie
Registered User
Posts: 69223
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: What Records Can I Delete With phpMyAdmin?

Post by Lumpy Burgertushie »

and once you get the board back working, make complete backups of the files and the database and go get a decent host.

most normal hosts don't restrict your database space or the number of databases you can have. normally the only restriction to database size is whatever the total size allocation for your hosting account is.


robert
Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
User avatar
AmigoJack
Registered User
Posts: 6108
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: What Records Can I Delete With phpMyAdmin?

Post by AmigoJack »

eeji wrote: Tue Jun 19, 2018 8:36 pmoptimise any tables with overhead
Don't do this: the optimization process temporarily needs the same amount of space or even more than the whole table already sizes, and with bad luck the table gets locked forever. Basically people have no idea about the risk: https://dev.mysql.com/doc/refman/8.0/en ... html#c9940
  • "The problem is probably not my English but you do not want to understand correctly. ... We will not come anybody anyway, nevertheless, it's best to shit this." Affin, 2018-11-20
  • "But this shit is not here for you. You can follow with your. Maybe the question, instead, was for you, who know, so you shoved us how you are." axe70, 2020-10-10
  • "My reaction is not to everyone, especially to you." Raptiye, 2021-02-28
User avatar
eeji
Registered User
Posts: 1461
Joined: Fri Dec 12, 2008 9:08 pm
Location: Manchester, UK
Contact:

Re: What Records Can I Delete With phpMyAdmin?

Post by eeji »

AmigoJack wrote: Wed Jun 20, 2018 7:20 am Don't do this: the optimization process temporarily needs the same amount of space or even more than the whole table already sizes, and with bad luck the table gets locked forever. Basically people have no idea about the risk: https://dev.mysql.com/doc/refman/8.0/en ... html#c9940
Thank you for the link, an interesting read and something new learned.
My phpBB styles: phpbbstyles.iansvivarium.com
My "board": iansvivarium.com
(yes, it's running phpBB!)
abrogard
Registered User
Posts: 329
Joined: Tue May 24, 2005 8:32 am
Location: australia
Name: arthur brogard

Re: What Records Can I Delete With phpMyAdmin?

Post by abrogard »

AmigoJack wrote: Wed Jun 20, 2018 7:20 am
eeji wrote: Tue Jun 19, 2018 8:36 pmoptimise any tables with overhead
Don't do this: the optimization process temporarily needs the same amount of space or even more than the whole table already sizes, and with bad luck the table gets locked forever. Basically people have no idea about the risk: https://dev.mysql.com/doc/refman/8.0/en ... html#c9940
Yes, thanks for that. I better inform my host. When I report I've no room and can't get into my software because of it he optimises my tables.

:)
Post Reply

Return to “[3.2.x] Support Forum”