Just Another Dang Blog

Recently I upgraded from Windows XP to Windows 7. Seems that the 32-bit and 64-bit architecture in regards to programs is still a bit confusing. I’m using Eclipse PDT 32-bit which at the moment the only current all in one version. Can be downloaded here.

My previous working setup was on WAMP( Windows, Apache, MySQL and PHP). On Windows I used a bundled app WampServer that did the job, just install the executable and your all set. On Mac it kinda needs a bit of work but basically you have to configure PHP, download-install MySQL and phpMyAdmin.

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 [...]

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 Update On phpMyAdmin select a table then go to Operations, Under Table Options you would see Rename Table to feature.

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 [...]