Howto Anything.: How to Say Hello in Different Languages

Howto Anything.: How to Say Hello in Different Languages

PHP Linux installation or php upgrade howto

Q. How do I install PHP under Red Hat enterprise Linux?

A. PHP (Hypertext Preprocesso) is a server-side web programming language that you can embed into HTML pages. When a user accesses a PHP-based page, PHP dynamically creates a web page that is then passed to the browser.

PHP works with Apache, Lighttpd and other webservers. PHP offers built-in database integration for several commercial and non-commercial database management systems. It also has the ability to perform many useful Web-related tasks using a large set of built-in functions.

PHP generally runs on a web server, taking PHP code as its input and creating Web pages as output, but command-line scripting and client-side GUI applications are part of the three primary uses of PHP as well. PHP can be deployed on any web server and on almost every OS platform free of charge.

Installing PHP is easy these days.

Red Hat enterprise Linux PHP installation
If you would like to install or upgrade PHP use up2date command:
# up2date php

CentOS/Fedora core Linux PHP installation
If you would like to install PHP use yum command
# yum install php
If you would like to upgrade PHP use yum command
# yum update php

Debian / Ubentu Linux PHP installation
If you would like to install or upgrade PHP use atp-get command
# apt-get install php4-cgi php4-cli
# sudo apt-get install php4-cgi php4-cli

To install PHP 5
# apt-get install php5-cgi php5-cli
# sudo apt-get install php5-cgi php5-cli

FreeBSD PHP installation
Use pkg_add command as follows:
# pkg_add -v -r php

How to make a Database Backup by phpMyAdmin

How to make a Database Backup (also known as exporting a db) using the MySQL Database Administration Tool phpMyAdmin v2.8.0.2.

Open phpMyAdmin.
Click on the database from the left column. If you have more than one database, then select the database from the drop menu.
After the page opens, click on the Export tab on the top horizontal menu.
After the page opens, on the Export Box select all.
Right underneath make sure SQL is selected.
- (If you are migrating from local to remote installation then follow the instructions in red, otherwise skip it.)
In SQL export compatibility: select - MySQL40
- NOTE Some earlier versions of phpMyAdmin do not have this SQL export compatibility feature.
Select
- Structure
- Add DROP TABLE
- Add IF NO EXISTS
- Add AUTO_INCREMENT VALUE
- Enclose table and field names with backquotes.
Select
- Data
- Complete inserts
- Extended inserts
- Use hexadecimal for binary fields.
Select Save as file
In File name template: _SERVER_name your db here. (Here you can use any name you want)
In Compression specify your choice.
Click Go.