Adding custom columns/fields to Joomla article, section and user

Run:
ALTER TABLE `jos_content` ADD `article_image` VARCHAR( 255 ) NOT NULL
in for instance phpMyAdmin.

25 Excellent Ajax Techniques and Examples

Source: http://sixrevisions.com/ajax/ajax_techniques/
Ajax allows for rich-internet applications that mimic the responsiveness and complex user interfaces typically associated with desktop applications.

Hide Joomla Subdirectory (Subfolder)

Source: http://joomlawebhosting.ca/joomla-15-tips/57-hide-joomla-subdirectory-subfolder.html
Instead of installing Joomla in the web root (public_html), some like to put
the Joomla files in a subfolder for better housekeeping.

Tạo vị trí mới trong template joomla 1.5 và 2.5

Mở file chứa template của bạn, chẳng hạn "\templates\thuvientapchi\index.php", xác định chỗ mà bạn muốn thêm một vị trí module mới và đặt vào đoạn mã sau:

Tải tập tin bằng lệnh wget trong linux

Nguồn: http://khanh.com.vn/post/2011/04/11/Tai-tap-tin-bang-lenh-wget-trong-linux.aspx

1. Tại sao dùng wget?

Trong môi trường UNIX/Linux, chúng ta có thể di chuyển tới các thư mục một cách nhanh chóng bằng lệnh cd (change directory) trong cửa sổ lệnh Terminal.

Backing up And Restoring MySQL Innodb Database

Source: http://blog.ijun.org/2010/02/backing-up-and-restoring-mysql-innodb.html
Backing up And Restoring MySQL Innodb Database

MySQL backups are performed using the common mysqldump tool. This is a command line utility that ships with MySQL and you use at as follows:
% mysqldump --user=user --password=pass --opt DBNAME > dumpfile.sql

Backup your MySQL databases manually with mysqldump

Source: http://www.ducea.com/2006/05/20/backup-your-mysql-databases-manually-with-mysqldump/

I often need to make a quick backup of one mysql database. This happens right before there will be some major changes to the database, or before performing an upgrade on the mysql server software. Now I don’t recommend this to be done regularly, but still, I use this extensively in this kind of situations… If you are looking for an automated solution to backup your databases you might want to check my other post: “Backup your MySQL databases automatically”

Dumping MySQL Stored Procedures, Functions and Triggers

Source: http://www.ducea.com/2007/07/25/dumping-mysql-stored-procedures-functions-and-triggers/

MySQL 5 has introduced some new interesting features, like stored procedures and triggers.
I will show in this small post how we can backup and restore these components using mysqldump.

Backup your MySQL databases automatically with AutoMySQLBackup

Source: http://www.ducea.com/2006/05/27/backup-your-mysql-databases-automatically-with-automysqlbackup/

If you site relies on MySQL and stores its sensitive data in a MySQL database, you will most definitely want to backup that information so that it can be restored in case of any disaster (manual mistake to delete some data, software errors, hardware errors, server compromise, etc.). In a previous post I have presented that MySQL provides the basic tool (mysqldump) to perform database backups. This is required because backing up a database is a little different than backing up regular files.

Dumping large MySQL InnoDB tables

Source: http://www.ducea.com/2006/10/26/dumping-large-mysql-innodb-tables/

Backing up MySQL databases normally involves running mysqldump (either manually or from a script). If you have worked with very big mysql tables (let’s say over 10GB) you already know that dumping such a table will take a while (of course this will depend from many things like hardware, mysql configuration, etc. but still whatever you do it will still take a long time for such big tables).

How to recover MySQL data from Innodb?

Source: http://egil.biz/how-to-recover-mysql-data-from-innodb/

Unfortunately some times you need to recover MySQL data from ibdata1. It’s many reasons why your getting corrupted Innodb files that cannot automatically be restored of the mysqld daemon.