No announcement yet.

Need to lower my forum space

  • Filter
  • Time
  • Show
Clear All
new posts

  • Need to lower my forum space

    MY mySQL is 189 mb big right now. How do I reduce it without delete posts and members?

  • #2
    What's the 'minimum word length' you've set for searches? If it's 3, then try increasing to 4 and reindex your site. This should save a bit of space.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    • #3
      maybe you should delete old attachments since they're all stored in the mysql database
      NXSupport Admin


      • #4
        How do I do that? I dunno how to delete them


        • #5
          Ok, dont the index. Now it's at 176 mb. Still quite bit.


          • #6
            using phpMyAdmin, click on your forum DB name and you'll see all the tables listed.

            click the "empty" link in the "attachment" row

            if you don't have phpMyAdmin, I *think* the telnet command from the mysql prompt would be:

            DELETE * FROM attachment


            • #7
              That sucks da big one..


              • #8
                Re: Need to lower my forum space

                Originally posted by Fred
                MY mySQL is 189 mb big right now. How do I reduce it without delete posts and members?

                also posted Fred
                Hey buddy, if you neded hosting. I charge $2.50 per gig of bandwidth and $1 per 50mb space. I got my own servers, ect.


                • #9
                  um i was wondering that:

                  We have 4 servers, we can handle any traffic. Trust me. Just email me at [email protected]. If you need 2000 gigs of traffic, thats fine. We'll sort out the details later.
                  to answer your question

                  DELETE from attachments WHERE attachmentid < x

                  where x is the attachment id up to which you want deleting.
                  Christopher Padfield
                  Web Based Helpdesk
                  DeskPRO v3.0.3 Released - Download Demo Now!


                  • #10
                    There's a hack by tubedogg for managing attachments, also includes a function to delete them.

                    I'd give you the url but I'm on the run...
                    Chen Avinadav
                    Better to remain silent and be thought a fool than to speak out and remove all doubt.

                    גם אני מאוכזב מסיקור תחרות לתור מוטור של NRG הרשת ע"י מעריב


                    • #11
                      Thanks guys, I'll do the phpmyadmin thing.


                      • #12
                        Didn't do much really. Something must be messed with the tables.


                        • #13
                          Take a look in the new version of phpMyAdmin (the one released a month or two ago) and it should show you which tables are taking up space. Post the table names of those that are using a lot of space.


                          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.