Hello! When I first set up my mySQL 4.1 server, I did not have the "innodb_file_per_table" option set. I have since set this option, and re-created all my tables so that they are now in individual innoDB files. However, the original, 44GB ibdata1 file still exists and I can't find any good way of shrinking it down to a manageable size. I know that the file is mostly filled with junk now, but I'm also fairly sure that there is -some- important data store in there...so the question is this:
How can I reduce the size of the ibdata1 file down to a manageable size, without breaking my mySQL server, and without backing up every database on my system (a 50GB proposition), and then deleting all databases and the ibdata1 file, and then re-creating everything from the backup? Is there, in fact, anything important in that ibdata1 file, or can I just shut down mySQL, move that file somewhere else, and then re-start mySQL? Is this possible, or am I stuck having my database server off-line for hours while the backup/restore procedure happens? Thanks for any help you can give! Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-0001 Office (516) 908-4185 Fax http://www.meitech.com/
smime.p7s
Description: S/MIME cryptographic signature
