Downloading some script or application using WGET is a common an quick way to start some web application or website. In my case I can’t remember me parameters I don’t use very often.
For example we like to install WordPress right into our public_html directory (not into a sub-directory), move to the website’s root directory first:
# cd /home/username/public_html/
Download the application from the WordPress website: Continue reading Download, extract and move a tar.gz file
Login to your server’s console and download MySQLTuner (I use my user’s home directory)
If you don’t like to enter the user details for every test it’s possible to create a .my.cnf file in the same directory and add a mysql admin user to access your database
Use this kind of settings:
Continue reading Optimize your MySQL Server with MySQLTuner
I’m using eAccelerator on two servers now, for both I’m using DirectAdmin as control panel. One is based on Ubuntu and the other one is running on Cent-OS.
Download eAccelerator from their website and follow their instructions (you need root access to install eAccelerator and it’s required to install php5-dev tools first):
tar xjvf eaccelerator-0.9.6.1.tar.bz2
The “–with-php-config” setting is maybe not necessary, check your server for the right location.
It might be possible that you need to install the PHP dev tools first (yum install php-devel (Cent-OS or apt-get install php-dev) Continue reading How-to install eAccelerator?
MySQL joins simply takes two tables and joins them together using one or more common values which they both share. For example if you had a table users and a table posts and you wanted to get all posts by a certain user you could use a query to get all posts where posts.userid = users.user_id. Continue reading Introduction to MySQL Joins