Simple Samba Server

1. remote server pake ssh
#ssh 192.168.1.123
(klo muncul error warning : Remote Host Identification Has changed )
Fix : #sshkeygen -R 192.168.1.123
2. Lakukan instalasi #apt-get install samba
3. Edit configuration di /etc/samba/smb.conf masukan folder yg mo disharing
[Photograf]
path = /photograf
command =photograf
writable = yes
guest ok = yes
4. Buat user #smbpasswd -a sayah
5.Restart aplikasi #/etc/init.d/samba restart

Read Full Post »

rename table di mysql ????

>alter table tabel_lama rename table_baru;

Read Full Post »

Backup dan Restore database MYSQL ?????

Melalui Query
>> Backup
>mysqldump.exe -u dhani -p blogtastic > blogtastic.sql
 
>> Restore
>mysqldump.exe -u dhani -p blogtastic < blogtastic.sql
Melalui PHPMYAdmin
>>Backup/Export

>Restore/Import

referensi : http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/

Read Full Post »

Buwat Foreign Key di PHPmyadmin???

 1. Konversi Tipe database dari MyISAM ke InnoDB
2. Buat index dari field yang akan dijadikan foreign key
3. Kemudian pilih relation view arahkan field yg jadi index ke field tabel yg dijadikan Primary key.
Screenshoot gambar ntar nyusul.

Read Full Post »

resycled/bootmatrix.com is not a valid win32 application error

Masuk safemode
cari file tersebut dan hapus
check file autorun.inf klo ada
berezzzzzzzzzz

Read Full Post »

Update syntax di SQL

Rubah data datetime dalam table database ??????????
update TT_TIKET
set TGL_BERANGKAT = dateadd (day,+11,TGL_BERANGKAT)
where NO_TKI=10987
update TT_TIKET
set TGL_BERANGKAT = dateadd (month,+12,TGL_BERANGKAT)
where NO_TKI=10987
 
update TT_TIKET
set TGL_BERANGKAT = dateadd (year,+11,TGL_BERANGKAT)
where NO_TKI=10987
update TT_FLAG_PROSES
set FLAG_BERANGKAT=’1′
where NO_TKI=10987

Read Full Post »

error install Xp di Komputer jadul Pentium 3

error yg muncul sbb:
The BIOS in this system not fully ACPI compliant – hardware-profile …..bla..bla.bla. bala bala gehu combro misro ^______^ hehe
Kemungkinanan error:
Komputer P3 udah lemot responnya, Motherboad/BIOS error, dkk
Solusi :
Pas instalasi teken F7 , syukur dapat diinstall

Read Full Post »

Reinstalll My Computer

Today I’m reinstall my computer cause It’s Slowly process and So boring.
I have install as follow :
1. Microsoft Windows XP SP2 Integrated
2. Microsoft Office 2003
3. Winrar
4. Real VNC Enterprise Edition
5. Adobe Acrobat 6.0 Professional
6. Install Nero 6
7. DVD Audio Extractor

Read Full Post »

Nge-repair registry sehabis diuyek sama virus HOPELESS

Setelah melakukan Cleaning virus baik itu memakai Antivirus ataupun secara manual. Berikut file buat mengoreksi registry yg udah di rubah sama virus HOPELESS.  Diambil dari forum VaksinCOm. Save dengan extension *.inf kemudian install.
[Version]
Signature=”$Chicago$”
Provider=Vaksincom Oyee
 
[DefaultInstall]
AddReg=UnhookRegKey
DelReg=del
 
[UnhookRegKey]
HKLM, Software\CLASSES\batfile\shell\open\command,,,”””%1″” %*”
HKLM, Software\CLASSES\comfile\shell\open\command,,,”””%1″” %*”
HKLM, Software\CLASSES\exefile\shell\open\command,,,”””%1″” %*”
HKLM, Software\CLASSES\piffile\shell\open\command,,,”””%1″” %*”
HKLM, Software\CLASSES\regfile\shell\open\command,,,”regedit.exe “”%1″””
HKLM, Software\CLASSES\scrfile\shell\open\command,,,”””%1″” %*”
HKLM, SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon, Shell,0, “Explorer.exe”
HKLM, SOFTWARE\Microsoft\Windows NT\CurrentVersion\Windows, AppInit_DLLs, 0
HKLM, SYSTEM\ControlSet001\Control\SafeBoot, [...]

Read Full Post »

Handle error Blue Screen di XP

Klo tetep ga bisa masuk ke safe mode.
Coba pake program bantuan untuk masuk ke command prompt XP kemudian jalankan CHKDSK.
program bantuan kayak Hiren Boot, NTFS4DOS, atau lebih simplenya pake CD installer XP lalu masuk ke menu repair.

Read Full Post »