MySQL : mysqldump with -w option on Windows XP

Case : You have a big size of mysql database table on windows xp machine and you want to dump database table with "where" condition
Solution : using -w option

set_time_limit(0);

$username = "root";
$password = "toor";
$hostname = "localhost";
$sConnString = mysql_connect($hostname, $username, $password)
 or die("Unable to connect to MySQL");

$connection = mysql_select_db("Country",$sConnString)
 or die("Could not select DB");

$sql = "select * from tblkelurahan where left(KelurahanID,4)='3277'";
$query = mysql_query($sql);

while ($fetch = mysql_fetch_object($query)) {
 $namafile = $fetch->KelurahanID;
 $command = "C:xampp\\mysql\\bin\\mysqldump.exe --add-drop-table -uroot -ptoor -w\"KelurahanID='$namafile'\" Indonesia tblpenduduk > $namafile.sql";
 system($command);
}

Install Office 2003 dan Office 2007

http://uksbsguy.com/blogs/doverton/archive/2007/07/21/how-to-get-rid-of-the-installer-configuration-dialog-when-running-office-2007-and-office-2003-on-the-same-system-for-vista-and-other-versions-of-windows.aspx

reg add HKCU\Software\Microsoft\Office\11.0\Word\Options /v NoReReg /t REG_DWORD /d 1
reg add HKCU\Software\Microsoft\Office\12.0\Word\Options /v NoReReg /t REG_DWORD /d 1

reg add HKCU\Software\Microsoft\Office\11.0\Excel\Options /v NoReReg /t REG_DWORD /d 1
reg add HKCU\Software\Microsoft\Office\12.0\Excel\Options /v NoReReg /t REG_DWORD /d 1

Excel - Delete row where specific cell is blank or meets condition

Sub delete_rows_zero()

Dim nMaxRow As Long, nrow As Long
nMaxRow = ActiveSheet.UsedRange.Rows.Count

For nrow = nMaxRow To 1 Step -1
If Range("A" & nrow).Value = 0 Then
Range("A" & nrow).EntireRow.Delete
End If
Next nrow

End Sub

http://www.mrexcel.com/forum/showthread.php?t=52132

Tutorial Create SVN Server on Windows XP

http://svn.spears.at/

MySQL : Merge two tables

using phpMyAdmin :

1. select database
2. create new table (note that the new table should have the same structure as the table that we want to merge)
3. go to the SQL menu and type in the sql box :
   
   

   INSERT IGNORE
   INTO table_1
   SELECT *
   FROM table_2
   ;

   
   

doh !

source : http://stackoverflow.com/questions/725556/how-can-i-merge-two-mysql-tables

Import mysql database from windows command prompt

1. open cmd
2. enter mysql directory
3. type :

mysql -uUSERNAME -pPASSWORD DATABASENAME < FILENAME.sql

doh !

source : http://www.ehow.com/how_2036644_import-sql-database.html

Blok Situs Iklan dengan Squid di WindowsXP

Ringkasan ini tidak tersedia. Harap klik di sini untuk melihat postingan.

xampp + coldfusion 7

download :

xampp-win32-1.7.2.exe

coldfusion7

hotfix wsconfig.jar

1. Backup cf_root/runtime/lib/wsconfig.jar to wsconfig.jar.bu.
2. Download hot fix (2.3MB).
3. Stop all ColdFusion servers and Apache 2.2
4. Extract the new wsconfig.jar file and place it in cf_root/runtime/lib.
5. Start - Program - Macromedia - ColdFusion MX 7 - Web Server Configuration Tool
6. 

Start apache and coldfusion server

Disable AutoPlay CD or USB

dapet dari howtogeek, disimpen biar nggak lupa :)

Nasib komputermu tanpa firewall

dulu sekali, teman yang ahli komputer bilang, install firewall di komputer mu kalo konek ke internet. Abis itu pasang sih, cuma nggak lama di uninstall lagi, soalnya berat !

trus beberapa hari ini kok perasaan banyak gangguan internet nya ya, mulai dari putus2, sampe ke nge-hang.
akhir nya pasang lagi dah.



belum ada seminggu sudah panen
jadi terbayang berarti selama ini ...

kesimpulannya teman-teman, pasang lah firewall mu !

ini beberapa yang bisa di download dan diinstall (gratis ?)
1. Comodo
2. PeerGuardian
3. Sunbelt
4. Sygate
5. Zone Alarm

aku pake yang terakhir, rada berat sih, tapi daripada daripada
ntar lah nunggu liburan panjang buat install ulang.
pake OS windows mah serasa cepet tua, belum setahun minta install ulang
nasiiib ...

Windows Skin : Black Desktop

Hehehe bosen sama pemandangan yang itu-itu aja, desktop nya sekarang saya ganti jadi seperti ini


Lebih enak kalo background nya gelap, jadi nggak pusing kalo duduk lama di depan lapie.
Trus Windows Media Player nya juga ada skinnya, media player classic nggak ada skin nya sih
bosan !

Ada yang berminat ? bisa klik disini :
1. Skin windows media player http://rs53.rapidshare.com/files/35608187/WM-SKINS.rar
2. Skin windows black http://www.istartedsomething.com/uploads/royale_noir.rar