biswarupadhikari

INSERT INTO mydb.test2 SELECT * FROM mydb.test

The above query will copy all data from test table to test2 table.

biswarupadhikari

create table mydb.test2 like mydb.test;

biswarupadhikari

sudo apt-get install php5-curl

biswarupadhikari

find /var/www/joomla -type f -exec chmod 0644 {} \;
find /var/www/joomla -type d -exec chmod 0755 {} \;

biswarupadhikari

<?php JHTML::_('behavior.modal'); ?>
<a href="index.php?option=com_users&view=registration&tmpl=component" class="modal" rel="{handler: 'ajax',size: {x: 600, y: 450}}">Register Now For Deal</a>

biswarupadhikari

#!/bin/sh
#sudo apt-get install linux-headers-3.5.0-21-generic
sudo apt-get install linux-headers-$(uname -r)
sudo apt-get remove virtualbox-dkms
sudo apt-get install virtualbox-dkms 

biswarupadhikari

function createTableFromJSON(jsonObj){
	var table='';
	var tableHeader=jsonObj[0];
	table+='<table>';
	table+='<thead><tr>';
	for(index in tableHeader){
		table+='<th>'+index+'</th>';
	}
	table+='</tr></thead>';
	table+='<tbody>';

biswarupadhikari

mysqldump -h DBHOST -u DBUSER -p --single-transaction DBNAME > data.sql

biswarupadhikari

mysql -h DBHOST -u DBUSER -pDBPASS DBNAME < backup/data.sql

biswarupadhikari

Backup

mysqldump -p -u username database_name > dbname.sql 


Restore

mysql -p -u username database_name < file.sql