mysql ibdata1 file size trouble. any help

Discussion in 'MySQL' started by gdtechind, Oct 20, 2005.

0
  1. #1
    there is one trouble i m facing abt mysql database on my server
    the ibdata1 file has grown to 3.3 GB in size
    we had lot of data in one database, but recently i deleted that database, but the file size for ibdata1 file is still the same.

    any way to reduce it in size. i am sure its size should be around 1 GB now as we have deleted lot of data and tables.

    Any ideas ?

    thanks
     
    gdtechind, Oct 20, 2005 IP
  2. Linknz

    Linknz Peon

    Messages:
    20
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Have you tried the tools in PHPMYADMIN
    from there you can compact and do a heap of database sorting to make sure it's compacted, try to clean the database usin it's functions..
     
    Linknz, Oct 22, 2005 IP
  3. cyclinder

    cyclinder Peon

    Messages:
    29
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    you should recreate the tables via mysql dump - currently you can not simply shrink the files
     
    cyclinder, Nov 25, 2005 IP