Category Archives: Database

A database is an organized collection of data ( Wikipedia )

WordPress Blog Post Frontend Error Tutorial

Running a WordPress.org (self hosted, versus a WordPress.com WordPress hosted) blog you are reading, a few times over several years have seen us stuck with the WordPress TwentyTen theme “Add Post” frontend webpage, to create a blog posting, “shooting ourselves … Continue reading

Posted in Database, eLearning, Tutorials | Tagged , , , , , , , , , , , , , , , , , | Leave a comment

PHP MySql Select Query UTF-8 Return Values Tutorial

Yes, ever since embracing emojis, we’re on the lookout for gobbledegook. And yes, a lot of the strategies we found on the “stumbled upon” Reading UTF-8 Content from MySql Table we were familiar with, but one we weren’t, which was … Continue reading

Posted in Database, eLearning, Tutorials | Tagged , , , , , , , , , , , , | Leave a comment

Perl CGI DBI Module Tutorial

Onto yesterday’s Perl CGI DateTime Module Primer Tutorial‘s … use of Perl module DateTime … today, we try out … use of Perl module DBI … to facilitate the connection and use of database functionalities, in our case MySql, as … Continue reading

Posted in Database, eLearning, Operating System, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Apache/PHP/MySql Web Hosting Website Migration Tutorial

Regarding Apache/PHP/MySql web hosting, when you see a chance for data migration, take it. The reason being, it is rare for any business run “close to the bone” to have enough resources to organize their own data migration initiative, though … Continue reading

Posted in Database, eLearning, Tutorials | Tagged , , , , , , , , , , , , , , , , | Leave a comment

CentOS Web Server cPanel Apache Status Tutorial

Our RJM Programming Linux CentOS Web Server cPanel Apache web server’s suite of software has a very useful report called Apache Status. We use it a bit like another Linux user without this report might use … ps -ef … … Continue reading

Posted in Database, eLearning, Operating System, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

MySql Repair Table Diskspace Error Log Consequence Tutorial

If you are managing a web server, you can run into times when … a total solution to a problem needs more research that will take time … but, perhaps … there is a solution that “eases the pain” of … Continue reading

Posted in Database, eLearning, Event-Driven Programming, Operating System, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

MySql Repair Table Failure Diskspace Consequence Tutorial

The previous MySql Repair Table Primer Tutorial outlined some phpMyAdmin administering of MySql (database) maintenance via SQL like … REPAIR TABLE wps_comments; … but what about if the SQL above fails or times out? Well, there can be implications, as … Continue reading

Posted in Database, eLearning, Operating System, Tutorials | Tagged , , , , , , , , , , , , , , , , , | Leave a comment