If you do any sort of web development, it is more than likely that CPANEL and phpMyAdmin are good friends of yours…and you depend on them. Even though those are extremely handy to create/modify databases and create backups, it is extremely helpful to know how to do the same thing by using only SSH and […]
I have run into some database problems over the years, but had to do something different today when I saw that this site had a problematic table (wp_posts). When I looked at the issue first, I got the message “MySQL error code 145 = Table was marked as crashed and should be repaired”. To repair […]
Finally after two years of contemplating the updates to Apache 2.x, MySQL 5.x, and PHP 5.x, I finally updated my server to the latest version os Apache, MySQL, and PHP. I was not too concerned about custom work or any of my WordPress sites, but I was concerned XOOPS and/or XOOPS modules would have some […]
If you all the sudden get database errors (select, cannot login, cannot write, etc) – and everything looks ok (from the database end of things) check to make sure you have not run out of disk space. How do I know? Well – let’s say last night I had to do a major fall clean-up. […]
After several days of researching and reading about how to solve a MySQL replication problem, I found a great resource on MySQL I thought I would share: MySQL Tips.
After working with Ben for almost eight years he had decided to move on. I wanted to wish Ben all the luck in the world. We had a great time working together for many years…as he put up with my on again off again relationship with Mac OS X Server and I put up with […]
After talking to Scott I finally have a plugin which I am excited to develop and excited to share with the WordPress community…a plugin that will allow WordPress admins to see exactly how many people are subscribing to your WordPress RSS feed and who these people are. Why would I do this when Feedburner is […]
A big thanks to Scott for pointing me in the right direction. I just got back from the store with the huge book he recommended – PHP and MySQL Web Development. I plan to start work on my first “from scratch” WordPress plugin in the next few days. [tags]PHP, MySQL, WordPress[/tags]
What got me up early Saturday and then up at 1am on Sunday? Server hardware failure…which led to some database corruption. I have never had to deal with database corruption, so I did not even know my problem was database corruption until after calling the helpful tech guys at Liquid Web. (I am not one […]
After finally getting some to to set up my development environment, I began thinking…why am I not using Apache 2.2 and PHP 5.1.2? What made me think about this? “Legacy Release” The phrase “legacy release” is what httpd.apache.org described Apache 1.3.x as in their news section. I have been using Apache 1.x for several years […]
Somethings, I just forget…again and again. Yeah, I need to go through the W3C School’s SQL tutorial and learn more about it and databases in general, but for now, here are some helpful tips for people like me that rely on MySQL, but often fall into the same novice traps/problems. I do not install MySQL […]
