Here’s how to check, repair and optimize all your mysql tables in all databases on a server… mysqlcheck -u root -p – -auto-repair –check –optimize –all-databases Note: you do not have to have root to do this, simply replace -u root with -u yourusername That’s it.. (Remember if you are using a tool like phpmyadmin […]
Read MoreIf you’ve ever administered a DNS (name server), than you know that serial numbers mean a lot. But what happens when you have several [hundreds|thousands] of zone that you need to make a mass-change to. That’s easy enough, there’s tons of ways to do that with sed, awk, or simple tools like “replace”. However, once […]
Read MoreRecently, I’ve seen cPanel upgrade throwing errors during upcp such as: # /scripts/upcp /scripts/upcp syntax OK Running Futex Check/Fix……Done Undefined subroutine &Cpanel::Update::automatic_updates_enabled called at /scripts/upcp line 273. Fix: wget -O /root/updatenow.static http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/updatenow.static && perl /root/updatenow.static –manual Then force the upgrade: /scripts/upcp –force Share on FacebookTweet
Read More
Erik
Tuesday, March 22, 2011
linux administration - tips, notes and projects
1 Comment