[opensource] Cleaning up MySQL?
saphetiger at post891.org
Tue Sep 18 10:02:35 EDT 2007
> Message: 6
> Date: Fri, 14 Sep 2007 12:31:48 -0400
> From: Paul Betts <paul at paulbetts.org>
> Subject: [opensource] Cleaning up MySQL?
> To: opensource at cse.ohio-state.edu
> Message-ID: <9198e3d1368e53a167edbf55673d6301 at localhost>
> Content-Type: text/plain; charset="UTF-8"
> Alright OSUOSS, does anyone know how to do anything about a MySQL database that's growing too big? I can't tell (though I have a pretty good idea) which tables are taking up the most disk space, and there may be a "clean up the files" command I'm missing. Thoughts? The database is only connected to Wordpress and Roundcube webmail, but it's using up 1.8 GB
> -- Paul Betts <paul at paulbetts.org> ------------------------------ _______________________________________________ Opensource mailing list Opensource at cse.ohio-state.edu http://mail.cse.ohio-state.edu/mailman/listinfo/opensource
Ok, well I usually would handle this by dumping it and cleaning out
extraneous entries. and then reimporting it over the existing database.
More information about the Opensource