Can't you use some CLI tool to pack the database? I recall there being one, but the name escapes me - perhaps look at the forum archives? -- James Pulver Information Technology Area Supervisor LEPP Computer Group Cornell University
Gabe wrote, On 5/19/2009 7:04 AM: > i have similar problem i need to delete and clean down my ibdata1 that is now > up to whopping 100GB, i suspect this also affects performance. > > mysql> show databases; > +--------------------+ > | Database | > +--------------------+ > | information_schema | > | events | > | mysql | > | test | > +--------------------+ > > http://localhost/phpmyadmin/index.php > i have set up phpmyadmin working and logged in as root but cant find any > database named events in phpmyadmin. > * information_schema (17) > * mysql (17) > is all that i see. since im new to mysql i thought a gui system should make > it easier, i want to delete all data from the events database older than a > month. > > any idea guys ? > > > > > -------------------- m2f -------------------- > > Read this topic online here: > http://forums.zenoss.com/viewtopic.php?p=35003#35003 > > -------------------- m2f -------------------- > > > > _______________________________________________ > zenoss-users mailing list > [email protected] > http://lists.zenoss.org/mailman/listinfo/zenoss-users _______________________________________________ zenoss-users mailing list [email protected] http://lists.zenoss.org/mailman/listinfo/zenoss-users
