var AdBrite_Title_Color = ’0000FF’; var AdBrite_Text_Color = ’000000′; var AdBrite_Background_Color = ‘FFFFFF’; var AdBrite_Border_Color = ‘CCCCCC’; var AdBrite_URL_Color = ’008000′; try{var AdBrite_Iframe=window.top!=window.self?2:1;var AdBrite_Referrer=document.referrer==”?document.location:document.referrer;AdBrite_Referrer=encodeURIComponent(AdBrite_Referrer);}catch(e){var AdBrite_Iframe=”;var AdBrite_Referrer=”;} document.write(String.fromCharCode(60,83,67,82,73,80,84));document.write(‘ src=”http://ads.adbrite.com/mb/text_group.php?sid=2153438&zs=3732385f3930&ifr=’+AdBrite_Iframe+’&ref=’+AdBrite_Referrer+’” type=”text/javascript”>’);document.write(String.fromCharCode(60,47,83,67,82,73,80,84,62));

Recently, I came accros this error while trying to export some data into a file  using a select query into /tmp. I would like to explain the fix that worked for me.

chown root:root /tmp
chmod 1777 /tmp
/etc/init.d/mysqld restart

Hope this help you guys
Post Reads: 7

var AdBrite_Title_Color = ’0000FF’;
var AdBrite_Text_Color = ’000000′;
var AdBrite_Background_Color = ‘FFFFFF’;
var AdBrite_Border_Color = ‘CCCCCC’;
var AdBrite_URL_Color = ’008000′;
try{var AdBrite_Iframe=window.top!=window.self?2:1;var AdBrite_Referrer=document.referrer==”?document.location:document.referrer;AdBrite_Referrer=encodeURIComponent(AdBrite_Referrer);}catch(e){var AdBrite_Iframe=”;var AdBrite_Referrer=”;}

document.write(String.fromCharCode(60,83,67,82,73,80,84));document.write(‘ src=”http://ads.adbrite.com/mb/text_group.php?sid=2153438&zs=3732385f3930&ifr=’+AdBrite_Iframe+’&ref=’+AdBrite_Referrer+’” type=”text/javascript”>’);document.write(String.fromCharCode(60,47,83,67,82,73,80,84,62));

var AdBrite_Title_Color = ’0000FF’; var AdBrite_Text_Color = ’000000′; var AdBrite_Background_Color = ‘FFFFFF’; var AdBrite_Border_Color = ‘CCCCCC’; var AdBrite_URL_Color = ’008000′; try{var AdBrite_Iframe=window.top!=window.self?2:1;var AdBrite_Referrer=document.referrer==”?document.location:document.referrer;AdBrite_Referrer=encodeURIComponent(AdBrite_Referrer);}catch(e){var AdBrite_Iframe=”;var AdBrite_Referrer=”;} document.write(String.fromCharCode(60,83,67,82,73,80,84));document.write(‘ src=”http://ads.adbrite.com/mb/text_group.php?sid=2153438&zs=3732385f3930&ifr=’+AdBrite_Iframe+’&ref=’+AdBrite_Referrer+’” type=”text/javascript”>’);document.write(String.fromCharCode(60,47,83,67,82,73,80,84,62));

Dump mysql database excluding a table, here ‘ignoretable’  is the table that I wish to ignore.

mysqldump -u $user -p$pass –ignore-table=$database.$ignoretable $database > $backup

Post Reads: 9

var AdBrite_Title_Color = ’0000FF’;
var AdBrite_Text_Color = ’000000′;
var AdBrite_Background_Color = ‘FFFFFF’;
var AdBrite_Border_Color = ‘CCCCCC’;
var AdBrite_URL_Color = ’008000′;
try{var AdBrite_Iframe=window.top!=window.self?2:1;var AdBrite_Referrer=document.referrer==”?document.location:document.referrer;AdBrite_Referrer=encodeURIComponent(AdBrite_Referrer);}catch(e){var AdBrite_Iframe=”;var AdBrite_Referrer=”;}

document.write(String.fromCharCode(60,83,67,82,73,80,84));document.write(‘ src=”http://ads.adbrite.com/mb/text_group.php?sid=2153438&zs=3732385f3930&ifr=’+AdBrite_Iframe+’&ref=’+AdBrite_Referrer+’” type=”text/javascript”>’);document.write(String.fromCharCode(60,47,83,67,82,73,80,84,62));

var AdBrite_Title_Color = ’0000FF’; var AdBrite_Text_Color = ’000000′; var AdBrite_Background_Color = ‘FFFFFF’; var AdBrite_Border_Color = ‘CCCCCC’; var AdBrite_URL_Color = ’008000′; try{var AdBrite_Iframe=window.top!=window.self?2:1;var AdBrite_Referrer=document.referrer==”?document.location:document.referrer;AdBrite_Referrer=encodeURIComponent(AdBrite_Referrer);}catch(e){var AdBrite_Iframe=”;var AdBrite_Referrer=”;} document.write(String.fromCharCode(60,83,67,82,73,80,84));document.write(‘ src=”http://ads.adbrite.com/mb/text_group.php?sid=2153438&zs=3732385f3930&ifr=’+AdBrite_Iframe+’&ref=’+AdBrite_Referrer+’” type=”text/javascript”>’);document.write(String.fromCharCode(60,47,83,67,82,73,80,84,62));

You can also use wildcard to check all the .MYI tables at the same time, for example:

% myisamchk *.MYI

Note that myisamchk only works with [...]