Posts Tagged ‘MySQL’

If you’re a PHP-MySQL developer, then you know & appreciate the freedom that these 2 open source applications have given us. What started out as a hobby many years ago, turned into one of the most widely used scripting languages on the internet. Coupled with MySQL you have a very powerful set of tools to [...]

Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • De.lirio.us
  • email
  • Furl
  • laaik.it
  • LinkedIn
  • MySpace
  • Slashdot
  • StumbleUpon
  • Technorati
  • YahooMyWeb
  • Print
  • TwitThis
Sunday, December 13th, 2009 at 23:04 0 comments

Here’s a quick & ditry trick to repair all MySQL databases on a server, in one go. Run the following commands on your server, in the console as root. mysqlcheck –all-databases -r #repair mysqlcheck –all-databases -a #analyze mysqlcheck –all-databases -o #optimize Share and Enjoy:

Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • De.lirio.us
  • email
  • Furl
  • laaik.it
  • LinkedIn
  • MySpace
  • Slashdot
  • StumbleUpon
  • Technorati
  • YahooMyWeb
  • Print
  • TwitThis
Wednesday, April 22nd, 2009 at 22:36 0 comments