MySQL Compression?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Uiop
    New Member
    • Apr 2007
    • 1
    #1

    MySQL Compression?

    I have a MySQL database that is about 6GB and needs to be 4.5GB at the most. Is it possible to compress MySQL databases/tables? The large tables do not need to be modified, only read.

    Any help is very much appriciated.
    Tags: None
    • masdi2t
      New Member
      • Jul 2006
      • 37
      #2
      Originally posted by Uiop
      I have a MySQL database that is about 6GB and needs to be 4.5GB at the most. Is it possible to compress MySQL databases/tables? The large tables do not need to be modified, only read.

      Any help is very much appriciated.

      I think thats impossible mission :D
      we can not shrink database file size (cmiiw).
      but u can recreate ur database to get ur wish done.

      use mysqldump to dump ur database, drop ur old database, create new database than restore ur dump (but, its wise to backup ur copy of ur database before)

        Comment

        Previous template Next
        Working...