I encountered a problem with Godaddy today when renewing a domain using my credit card which I have stored on Godaddy, suddenly I’m getting the Â error “There was a problem authorizing your credit. Please verify your payment information or use an alternate form of payment.” After some googling I found out it is common on […]
Over the past few months I’ve changed my working environment(IDE) for PHP from Dreamweaver, which I have been using for the last past years with occasional use of PHP Designer 2007, 2008. It did the work but I wanted more features and tools. Then I switched to ZendStudio built on Eclipse. It was complete and […]
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 […]