Ask a Question related to MySQL, Design and Development.
-
Roberto Rasto #1
Help on Shrink IBDATA1 file
How can I shrink the file IBDATA1 on MYSQL directory?
I use windows 2003.
Thanks a lot.
Roberto
Roberto Rasto Guest
-
Shrink Registry (CFVariables)
Hi We've been having a few problems with our servers recently and looking into it I discovered that the software registry hive on both servers... -
How to Shrink PDF Files?
If you are not already doing so, try creating your PDF by making a postscript file and distilling it. The resulting PDF should be incredibly smaller. -
Shrink to fit
Hi I'm very new, trying to do a very simple site for a coming attraction. Here's my plan: 1. Have two layers of content. On the bottom layer, a... -
Shrink pic and stop
Hi everyone, I'm a newbie and getting frustrated trying to do this. Any help greatly appreciated. My objective: 1. Two layers of content 2. ... -
How best to SHRINK large digital photos for email file sizes
I do NOT know how best to 'shrink' photographs for sending in the mail. My digital camera takes shots at 5 Megapixels, which in 'fine' mode,... -
Bill Karwin #2 Re: Help on Shrink IBDATA1 file
Roberto Rasto wrote:
This is a common complaint about MySQL.> How can I shrink the file IBDATA1 on MYSQL directory?
> I use windows 2003.
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
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
