By default, MySQL is enabled with strict_mode ON, which will most likely cause problems with older PHP applications written for MySQL 4. For example, strict mode will return an error on insert statements if an empty string is provided where an integer is expected. You may disable strict mode in one of two ways: Open […]
Easy! As you might know, on nginx there is no .htaccess file. So you must specify your routing in .vhost file. Here is an example of one zend page that is spining on nginx. Enjoy! server { listen 111.222.333.444:80; server_name website.ba www.website.ba; root /var/www/website.ba/web/public; index index.html index.htm index.php index.cgi index.pl index.xhtml; location ~ \.shtml$ { […]
In this post I’m going to write a short tutorial how to install cPanel / WHM to your CentOS machine. It’s simple and quick if you do everything correctly. First you must be aware of system requirements : – 512MB RAM – It’s suggested that you should have CentOS 4.x or 5.x or higher you […]
Often it is useful to export a SQL query result into a file. Especially CSVfiles are nice for this task. The following SQL query saves the result in a file called output.csv into the /tmp directory: SELECT * FROM my_table INTO OUTFILE ‘/tmp/output.csv’ FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’;