Just Another Dang Blog

Been using WAMP for several months now and once in awhile MySQL breaks. Somehow the user tables gets corrupted. To fix the problem instead of reinstalling the whole WAMP. Just replace the corrupted files. These 3 files are always corrupted.

user.MYI

user.MYD

user.frm

Download this mysqlusertables. Unzip the file, copy the 3 files inside.
Go into your C:\wamp\bin\mysql\mysql5.x.xx\data\mysql directory and [...]

Quick tip. The feature is not (yet) supported in phpMyAdmin but you can easily make the change by simply issuing this sql statement.

RENAME TABLE old_table TO new_table

This is useful if you don’t have access to phpmyadmin on your server but have access to ssh and ftp. Or you have a huge sql dump like 10MB or higher that you cannot import directly on phpmyadmin. In my case the phpmyadmin directory was password protected by Apache and I don’t have the right [...]

I miss using a Mac, saving up to get the latest MacBook Pro.
Here is quick tip for an alternative method on how to restart Apache using the Terminal. Long method is go to Preferences then Sharing and disable enable Personal Web Sharing.
Shortcut is
Open the Mac OS X Terminal window then type in.
sudo /usr/sbin/apachectl restart

I didn’t like using All in One Package during the my early years of learning how to install Apache, PHP and MySQL in my Windows box – there were programs like PHPTriad and similar which offers these three in one convenient installation without getting your hands dirty so to speak on the configuration. From [...]