473,320 Members | 2,097 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

MySql ibdata1 compact space

Hello I have a problem with mysql.

Using the tables of type INNODB, mysql it has created the archives
(ibdata1) whose dimensions exceed the 3G.

I have cancelled all the database but the occupied space is remained
the same one. How I can make in order to compattare this space?

Thanks

May 26 '06 #1
2 13050
be******@esact.it wrote:
Hello I have a problem with mysql.

Using the tables of type INNODB, mysql it has created the archives
(ibdata1) whose dimensions exceed the 3G.

I have cancelled all the database but the occupied space is remained
the same one. How I can make in order to compattare this space?


If you've dropped all the InnoDB tables, you can stop the MySQL Server,
manually delete ibdata1 and the InnoDB log files, and then restart MySQL
Server. MySQL Server will recreate a smaller ibdata1 file when it restarts.

If you have any InnoDB tables you want to keep, you must back them up
first with mysqldump, drop them, and restore them afterward.

See http://bugs.mysql.com/bug.php?id=1287

Regards,
Bill K.
May 26 '06 #2
Thanks for the answer

May 29 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Eduardo Pérez Ureta | last post by:
I'm looking for an easy way to use mysql from user (no root, no mysql system account) space. I don't want the user of my application to have to use a password to connect to the database. I want to...
0
by: Asif Iqbal | last post by:
Hi I am running MySQL 4.0.13 with my-medium.cnf (attached) on a Solaris 8, 4x450 Mhz, 4gb RAM. All my tables are InnoDB. Currently my ibdata1 is 1.8 gb. I have about 1 gig space left on the same...
0
by: Pyung Yoon | last post by:
Hi, I have a strange problem with innodb tables. I have about 10 innodb tables, a few of which can have tens of thousands of entries. These huge tables are clean up regularly. But the size of...
39
by: Mairhtin O'Feannag | last post by:
Hello, I have a client (customer) who asked the question : "Why would I buy and use UDB, when MySql is free?" I had to say I was stunned. I have no experience with MySql, so I was left sort...
1
by: jlee | last post by:
I'm pretty much a newbie on mysql, and I need some help. I am running mysql Ver 12.22 Distrib 4.0.24, for portbld-freebsd5.4 (i386) on a server hosting an active website. The site's developer...
2
by: fuzzybr80 | last post by:
I am using MySQL 5.0 with a number of innodb tables whose ibdata files are growing quite quickly and filling up the /var partition (file is /var/mysql/ibdata1). Earlier on I followed instructions...
7
by: Randy | last post by:
Folks: We have a web-based app that's _really_ slowing down because multiple clients are writing their own private data into a single, central database. I guess the previous programmer did...
5
by: lyealain | last post by:
waht should i do to recover the database after i reinstall the mysql .. i did not export the previous database table out... GOD... i still have the ibdata1 which is more than 800MB in my Mysql...
0
by: support1 | last post by:
Hi, I have 10GB of harddisk space and now the harddisk space remaining 2GB because of the IBData1 size too big. As I'm check in the administrator tool. There is no any option to reduce or delete...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.