[Linux] Put backslash \ to the filename that contains space

Let say you have folder like below:

myFolder
 |_ text file one.txt
 |_ text file two.txt
 |_ text file three.txt

Type the command like below:

ls myFolder/* | sed 's/ /\\ /g'

Output:

myFolder/text\ file\ one.txt
myFolder/text\ file\ two.txt
myFolder/text\ file\ three.txt

[PHP] - Download mutiple BLOB data and convert into file system

Last week I was struggled on how to convert data that stored on DB BLOB into the file system. There are more than 100 rows on that tables. Whoooaaaarrgghhhh!!. So how I’m gonna save it? The user needs those files in soft copy (I mean the file will be save in a thumbdrive). After few hours googling and read some forums, I came out with the solution that can be useful to others.

 
/**
 * @author MJMZ
 * @copyright 2012
 * Description : This file will be used to convert all the BLOB
 * contents and save into the file system.
 *
 */
 
include("../../../lib/db_common.php");
 
/* get document_id, document_name, folder_id, document_fileType, document_fileName */
$sql = 'SELECT document_id,
        document_name,
        folder_id,
        document_fileType,
        document_fileName
        FROM portal_document_upload';
$result = $db->query($sql);
 
$doc = array();
 
while($rows = mysql_fetch_array($result))
{
    $doc[] = array('docId' => $rows['document_id'],
                   'exacFilename' => $rows['document_fileName'],
                   'filename' => $rows['document_name'],
                   'filetype' => $rows['document_fileType']);
}
 
foreach($doc as $a => $key)
{
    // get the file extension : This code will only work only
    // if file got 1 extension. If the file got many extension
    // such as filename.tar.gz, this code will not work at all.
    // Try find another solution for that particular file.
    $fileXtension = pathinfo($key['exacFilename'], PATHINFO_EXTENSION);
 
    // If we select the blob in the first query, it will
    // cause bad queries @ mysql log.
    // So we select the blob in foreach based on their document_id.
    $sql_file_contents = "SELECT document_fileData
                          FROM portal_document_upload
                          WHERE document_id ='".$key['docId']."'";
    $theFile = $db->query($sql_file_contents);
    $row = mysql_fetch_array($theFile);
 
    // For precaution, we find the empty string @ filename
    // and replace them with _ (underscore) in order to avoid
    // the filename missing their extension.
    $rawFile = str_replace(" ","_", $key['filename']).".".$fileXtension;

    // the path for downloaded file.
    $path = "/home/httpd/files_convert/".$rawFile;
 
    if (file_put_contents($path, $row['document_fileData']) === FALSE ) {
        echo "Could not write PDF File";
    } else {
        file_put_contents($path, $row['document_fileData']);
    }
 
 }
 
?>

Now go to the $path folder that you declared in above script. Select all files, right click and save to thumbdrive.

[Linux] - Automatically backup project and database @ Midnight using cron

Since the tragedy happened cause by someone, the entire server of our application "SRM" will not be recovered at all. This including the program’s source code and MySQL database. So we decided to do a daily backup of both the database and source code during 00:00:00 o’clock. This script will only work on linux server. You can use the same code. Just change certain variable value.

################################################
# Backup source code and MySQL DB
# softboxkid - 09 Mar 2012
################################################

# Please change the value of below variables:
# DO NOT CHANGE THE VARIABLE NAME.

DBNAME=your_db_name
DBPASS=your_db_password
DBUSER=your_db_user
FOLDER_NAME=the_folder_name_for_backup

DATE=`date +%Y%m%d_%H%M`

echo "Backup in progress..."
echo "Start time". $(date +%k:%M:%S)

# Step 1: prepare to backup application source code begin here.
mkdir /backup/$FOLDER_NAME-$DATE
cp /your/source_code/path -r /backup/$FOLDER_NAME-$DATE

# Step 2: prepare to backup mysql database begin here.
echo "Start time". $(date +%k:%M:%S)
mysqldump -u $DBUSER -p$DBPASS $DBNAME > /backup/$FOLDER_NAME-$DATE/$DBNAME.sql
echo "end time". $(date +%k:%M:%S)

# Step 3: prepare archive tar.gz for FOLDER_NAME
cd /backup
tar -cvf $FOLDER_NAME-$DATE.tar $FOLDER_NAME-$DATE
gzip $FOLDER_NAME-$DATE.tar

# Step 4: remove non-zip file/folder
rm -r $FOLDER_NAME-$DATE

echo "Your source code and MySQL has been backup $FOLDER_NAME-$DATE.tar.gz time finished time"
echo "end time". $(date +%k:%M:%S)

Save this code as “backup” and chmod this script to 755 and put it under /etc/cron.daily (make sure you have the root permission).
Now your daily backup will be stored in folder that you declared in step 1 of this script (in this example, it will put on folder /backup).

[MySQL] - Host 'xxx.xxx.x.xx' is not allowed to connect to this MySQL server

This problem happen when the mysql server doesn't allow remote connection. So first, go to the mysql server that you want to access.

• Use putty (for windows) or terminal (for unix/linux) and perform the ssh
  ssh root@xxx.xxx.x.xx
Enter password: (enter the server's password) 
• Then type:
  mysql -u root -p
Enter password:(enter the mysql password) 
• Then type the following command:
  GRANT ALL PRIVILEGES ON *.* TO your_mysql_user@'%' IDENTIFIED BY 'your_mysql_password';
  

* make sure you change the value of your_mysql_user and your_mysql_password.Now you can access the mysql server through remote connection.

[Centos] - Yum with proxy

Just add the following on environment variable in .bash_profile file:

export http_proxy=http://ip:port

Now you can yum as usual.

[PHP] - Encode / Decode paramater on the URL using base64

function my_base64_encode($input) {
	return strtr(base64_encode($input), 'AEIOUj', '+-_,');
}
 
function my_base64_decode($input){
	return base64_decode(strtr($input, '+-_,', 'AEIOUj'));
}

$texttoencode = 'RAIHAN';

$b = my_base64_encode($texttoencode);
// the value of $b now is UkFJS-F,

$c = my_base64_decode($b);
// the value of $c is RAIHAN

[Linux] - Copy and exclude certain folder

Let say you have a folder structure like below:

• source
  • folder_video
    • videoA.mpg
    • videoB.mpg
    • videoC.mpg
  • folder_contents
    • file1.txt
    • file2.txt
  • folder_picture
  • fileA.txt
  • fileB.txt
  • folder_documents
   

You want to copy all contents on the source folder and at the same time exclude certain folder. How? Follow the below instruction.

Exclude single folder

rsync -avz --exclude folder_video /source /your_destination_path

* it will copy the source folder to your_destination_path and exclude the folder_video

Exclude multiple folder

rsync -avz --exclude folder_video --exclude folder_contents /source /your_destination_path

* it will copy the source folder to your_destination_path and exclude the folder_video and folder_contents

Exclude file and folder at a same time

rsync -avz --exclude folder_video --exclude folder_contents/file1.txt /source /your_destination_path

* it will copy the source folder to your_destination_path and exclude the folder_video and file1.txt

[Linux] - Find number of cores

Command:
lscpu

Output:

[SVN] - Add SVN user

Tested on Centos

Add new user account (for first time)
htpasswd -cm /etc/.svn-auth-file <username>
* It will ask for password. Provide the password and confirm again.

Add another user in the same svn-auth-file
htpasswd -m /etc/svn-auth-users <username>
or
htpasswd -m /etc/svn-auth-users <username> <password>

[Linux] - How to list linux file/folder permission on numerical value

Tested on Centos and Ubuntu.

stat -c "%a %n" *

Sample output:

777 aircrack-ng-1.1
755 abc.txt
644 root.conf

[Oracle] - Select table contains column name

Tested on Oracle11g

Return all the tables in my schema which have the column name "INST_CODE".

SELECT table_name FROM user_tab_cols WHERE column_name = 'INST_CODE' ORDER BY table_name ASC;