Exporting data in mysql 5.5 innoDB

I used to export my data using option MySQL Admin -> data export/restore -> export to self-contained file, for MyIsam.

But when I switched over to InnoDB and option checked for ‘innodb_file_per_table’ and did my data export using self contained file, and imported it back to other mysql 5.5 machine. It created only one innodb data file  for all my database table.

Solution for keeping separate .ibd files for all DB is to check ‘Export to dump project folder’ and then import that folder. Doing this will keep one innodb file per table.

Importing all emails from one gmail account to another

Its very easy to do:

Step1: Email account from which you have to fetch of all emails
a) Go to top right of page. Click on ‘Settings‘.
b) Under ‘Settings‘, click on tab names ‘Forwarding and POP/IMAP‘.
c) Inside ‘POP Download‘ click on the ‘Enable POP for all mail (even mail that’s already been downloaded)‘
d) Click on ‘Save changes‘ button at bottom.

Step2: New Emails account in which you have to import all emails from old account:
a) Go to top right of page. Click on ‘Settings’.
b) Under ‘Settings‘, click on tab names ‘Accounts and Import‘.
c) Now click on very first button named ‘Import mail and contacts‘. It will open a pop-up window asking your username first then your password. Its very simple just keep on filling information and clicking continue.(NOTE: Allow pop-up here if your browser is blocking it)
d) You are done. All emails backup will be done in back-end. Time for backup depend upon the number of emails you import. In my case there were around 5550 emails and it took 2 days to import all emails.

Forwarding and POP/IMAP

Unwanted cfscript tag in xmlhttlrequest for cfchart in IE

I wanted to refresh whole div containing cfchart with updated chart using simple xmlHttpReq. I simply write another .cfm page having new charts with which i replace chart in my calling .cfm page. It worked fine in Firefox n safari, but in can’t see any updated chart in IE, whole

was blank. There was not even any java script error shown. Problem was that IE inserts tag at the top of html code. So all the html beneath that is not displayed in IE. Below code will solve that purpose. All it does is replace any found in the xmlHttp.responseText

xmlhttp.onreadystatechange=function()

{

if(xmlhttp.readyState == 4 && xmlhttp.status==200)

{

var res = xmlhttp.responseText;

res = res.replace(new RegExp(“[<||\>]”,”gi”),””);

document.getElementById(“charts”).innerHTML = res;

}

}

Happy Birthday Ankur

Ankur Saxena, I met him in Jan 2008. We use to play for same team ‘Trojan Tiger’. Its his birthday today, I wish him all the luck and hope his year turn out to be greatest of all.

He is a very good at heart. He likes ‘billiya’ (cat) a lot. Bcoz his nick name is ‘Billi ka Bacha’ lolz.. He is 25 now. And will be married to Dheera in Jan 2011.

When it comes to cricket he is a very good batsman. Good keeper – almost always takes best keeper award at cromwell (USC internal cricket series) and a good bowler too.

Happy Birthday bro,,,

Coldfusion useful tag – cfsavecontent

I found cfsavecontent tag very helpful. There are two cool things about this tag:

1) you don’t have to use ‘&’ (ampersand) to concatenate string anymore. Just put them inside cfsavecontent.

2) you can loop thorough query or any collection object in coldfusion and save the result in one variable. And that variable can be used in many ways especially when you are running an ajax application and want result jason format.

Usage:

<cfsavecontent  variable=”detailTable” > 

<tr style=”font-weight:bold; background-color:#FFFF9B” >

<td width=”11%”><strong>Column1</strong></td>

<td width=”10%”><strong>Column2</strong></td>

<td width=”10%”><strong>Column3</strong></td

<td width=”10%”><strong>Column4</strong></td>

<td width=”10%”><strong>Other</strong></td>

</tr>

<Cfset r1= 0>

<Cfset r2= 0>

<Cfset r3= 0>

<Cfset r4= 0>

<Cfset Other = 0>

<cfloop query=”name_of_query”>

<tr onMouseOver=”this.style.backgroundColor=’##FFFFDD'” onMouseOut=”this.style.backgroundColor=’##FEFEFE'” >

<td><strong>#result1#</strong><Cfset r1= r1+ result1></td>

<td>#result2#<Cfset r2= r2+ result2></td>

<td>#result3#<Cfset r3= r3+ result3></td>

<td>#result4#<Cfset r4=  r4+ result4></td>

<td>#other#<Cfset ot=  ot+ other></td>

</tr>

</cfloop>

</cfsavecontent>

And best part is that you can you variable that you used to add like r1,r2,r3… etc.. in the rest of the coldfusion script.