Professional Web Applications Themes

Help on Shrink IBDATA1 file - MySQL

How can I shrink the file IBDATA1 on MYSQL directory? I use windows 2003. Thanks a lot. Roberto...

Sponsored Links
  1. #1

    Default Help on Shrink IBDATA1 file

    How can I shrink the file IBDATA1 on MYSQL directory?
    I use windows 2003.

    Thanks a lot.

    Roberto


    Sponsored Links
    Roberto Rasto Guest

  2. #2

    Default Re: Help on Shrink IBDATA1 file

    Roberto Rasto wrote:
    > How can I shrink the file IBDATA1 on MYSQL directory?
    > I use windows 2003.
    This is a common complaint about MySQL.
    The following is the only way to shrink the file:

    1. Back up all databases that use InnoDB tables.
    2. Drop all InnoDB tables.
    3. Remove the IBDATA1 file manually.
    4. Restore all InnoDB tables from your backups. This recreates the
    IBDATA1 file and fills it.

    This is very inconvenient, and it has been logged as a bug, but there is
    no other solution at this time.

    See discussion at [url]http://bugs.mysql.com/bug.php?id=1341[/url]

    Regards,
    Bill K.
    Bill Karwin Guest

Similar Threads

  1. Shrink Registry (CFVariables)
    By Kosch in forum Coldfusion Server Administration
    Replies: 2
    Last Post: August 31st, 11:03 AM
  2. How to Shrink PDF Files?
    By Mandy_Roberts@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 3
    Last Post: August 1st, 09:10 AM
  3. Shrink to fit
    By drewp88 webforumsuser@macromedia.com in forum Macromedia Flash Sitedesign
    Replies: 5
    Last Post: January 29th, 08:31 PM
  4. Shrink pic and stop
    By drewp88 webforumsuser@macromedia.com in forum Macromedia Flash Actionscript
    Replies: 5
    Last Post: January 28th, 06:31 PM
  5. How best to SHRINK large digital photos for email file sizes
    By Eunice Santorini in forum Photography
    Replies: 26
    Last Post: October 1st, 07:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139