This is a list of handy MySQL commands that I use from time to time. At the bottom are functions, statements and clauses you can use with MySQL. Below when you see # it means from the unix shell. When you see mysql> it means from a MySQL prompt after logging into MySQL. The description…

MySQL is dead. Long live MySQL. Now that oracle owns MySQL, it will certainly kill it as quickly and quietly as possible. If you were a large corporation, why would you want to have a stable, open source, widely used software platform competing with your fee related software that is generating a profit from the…

I recently had a client that went to backup a specific account using the cpanel backup script ‘pkgacct username’ located in the /scripts folder. Whenever he tried to use this script, the backup would fail. I found the error was not related to the cpanel script itself but to the gzip command itself. I needed…

I went to bed the other night after browsing the web for about an hour. I knew I was going to have a hard time waking up, so I setup a task on my linux laptop to wake me at 7:00am with a mp3 I wanted to wake up to. “What the heck do you…

Pipe, as the name implies, is a sort of hollow tube (a pipe) where you can put data into one end and use the output on the other end. It takes the output from one command and uses it as the input for the following command. This functionality is only one of the many features…

I just wanted to spend a few moments talking about backups. I just finished an email to a client who had 3 major databases crash because of Innodb issues which corrupted the tables beyond repair. I went to restore them and found the daily backup corrupted also. usually, there are weekly and monthly backup enabled…

When starting your Linux server you may see services that are starting which may slow the boot process. i will show you how to enable/disable certain services and which ones are essential for your system. First, a few words about runlevels. Each runlevel has a different purpose. In most Linux distributions runlevels are organized as…

Apache uses modules called MPM’s or Multi-Processing Modules for the most basic functions of a web server. The default apache setup contains a selection of of these MPM’s which are responsible for binding to network ports on the server, accepting and dispatching child processes to handle the requests from a browser in order to display…

In order to modify this page, login to your server via ssh and cd over to /usr/local/apache/htdocs cd /usr/local/apache/htdocs Here, you can edit the file index.html vim index.html If you list the content of /usr/local/apache/htdocs you will see that you can also modify the content of other error pages that apache outputs as well. Also,…

http://opensource.com/ This site is one of the ways in which Red Hat gives something back to the open source community. Our desire is to create a connection point for conversations about the broader impact that open source can have–and is having–even beyond the software world. We think of this site as a “Red Hat community…