Batch Programming

Batch Programming

Intinya saya butuh backup database Mysql setiap hari tanpa harus ketik manual mysqldump bla bla bla, dengan sedikit kata kunci yang standart dan bantuan search engine google maka ditemukan beberapa contoh script yang membahas Backup Mysql Database dengan Batch Programming. Comot sana sini maka dapat yg menurut saya paling sederhana sesuai kebutuhan seperti dibawah

Dalam Kasus ini menggunakan aplikasi appserv under microsoft windows

@echo off
echo Starting Backup of Database: …

FOR /F “TOKENS=1-4 DELIMS=/ ” %%F IN (‘DATE /T’) DO (SET TODAY=%%H%%G%%F)

C:\AppServ\mysql\bin\mysqldump -u root -pPasswordDB –result-file=”D:\Folder-backup\NamaDbBebas.%TODAY%.sql” NamaDBYangAkanDiBackup

echo Backup Complete!

- Simpan script diatas dan simpan dalam bentuk file dengan ekstensi .bat

Penamaan file hasil backup tersebut akan seperti ini “NamaDbBebas.04_08_2010_220005,15.sql”  yang dimana 04_08_2010 adalah tanggal sedangkan 220005,15 adalah waktu

Selesai sudah Backup Mysql Database dengan menggunakan Batch Programming :)

Tugas Selanjutnya adalah :

- Membuat Backup Mysql Database terjadwal (akan dibahas selanjutnya :)

- Hasil backup file .sql di compress dalam bentuk zip supaya lebih hemat space

{ Comments on this entry are closed }

10 Langkah Setting Router sederhana menggunakan MikroTik

by Herman Tarigan on January 20, 2009

10 Langkah Setting Router sederhana menggunakan MikroTik

Contoh Kasus :
PC CLient — > Switch –> Router —> Internet

IP PUBLIC : x.y.z.pub/29
DNS : x.y.z.dns1 dan x.y.z.dns2
Gateway : x.y.z.gw
IP address LOCAL ROUTER : 192.168.100.1/24
IP address Client : 192.168.100.2/24

Catatan : Sesuaikan Hardware, IP Address, DNS, Gateway dengan yang anda miliki

Hardware :
Router :  RouterBoard 1000 (Mikrotik v3,19 Stable)

Mikrotik RB1000

Mikrotik RB1000


Switch : D-Link DES-3026 Ethernet Switch

D-Link DES-3026 Ethernet Switch

D-Link DES-3026 Ethernet Switch

PC Client : PowerBook G4

Powerbook G4

Powerbook G4

[click to continue…]

{ 0 comments }

Konfigurasi Virtual Private Network (VPN) Connection menggunakan Windows XP

December 30, 2008

Apa itu VPN ? Berikut kutipan dari wikipedia mengenai definisi dari VPN VPN adalah singkatan dari virtual private network, yaitu jaringan pribadi (bukan untuk akses umum) yang menggunakan medium nonpribadi (misalnya internet) untuk menghubungkan antar remote-site secara aman. Perlu penerapan teknologi tertentu agar walaupun menggunakan medium yang umum, tetapi traffic (lalu lintas) antar remote-site tidak […]

Read the full article →

Huawei E220 Installation for Mac OS X Tiger 10.4 (Indosat 3G)

December 19, 2008

1. Download Driver from: http://www.huawei.com/mobileweb/en/file/download.do?f=19957&ctype=1 2. Rename file : add file extention .dmg (E220.dmg) 3. Extract file E220.dmg and run file Mobile_Connect_Drv_App.pkg

Read the full article →

Configuring LiteSpeed Webserver with a hosting cPanel

December 18, 2008

Configuring LiteSpeed Webserver with a hosting cPanel [root@nagan ~]# pwd /root [root@nagan ~]# mkdir litespeed [root@nagan ~]# cd litespeed/ Download LiteSpeed Web Server [root@nagan litespeed]# wget http://www.litespeedtech.com/packages/3.0/lsws-3.3.22-ent-i386-linux.tar.gz –20:21:37–  http://www.litespeedtech.com/packages/3.0/lsws-3.3.22-ent-i386-linux.tar.gz => `lsws-3.3.22-ent-i386-linux.tar.gz’ Resolving www.litespeedtech.com… 209.151.227.121 Connecting to www.litespeedtech.com|209.151.227.121|:80… connected. HTTP request sent, awaiting response… 200 OK Length: 5,204,674 (5.0M) [application/gzip] 100%[====================================>] 5,204,674      7.39K/s    ETA 00:00 20:31:07 […]

Read the full article →

Login nComputing L-Series The local policy of this system does not permit you to log on interactively

December 15, 2008

Error message Login ncomputing L-Series : The local policy of this system does not permit you to log on interactively Operating system : Windows XP Service Pack 3 Solutions: On the remote system, click Start, then Run, type “secpol.msc”, and press enter.

Read the full article →

Nagios : check_ping CRITICAL – popen timeout received, but no child process

December 15, 2008

[root@ibm /usr/local/nagios/libexec]# ./check_ping -H titik.org -w 3000.0,80% -c 5000.0,100% -p 5 CRITICAL – popen timeout received, but no child process try the CVS snapshot at http://nagiosplug.sf.net/snapshot [root@ibm ~]# wget http://nagiosplug.sourceforge.net/snapshot/nagios-plugins-HEAD.tar.gz –2008-12-15 14:10:52–  http://nagiosplug.sourceforge.net/snapshot/nagios-plugins-HEAD.tar.gz Resolving nagiosplug.sourceforge.net… 216.34.181.96 Connecting to nagiosplug.sourceforge.net|216.34.181.96|:80… connected. HTTP request sent, awaiting response… 200 OK Length: 1845366 (1.8M) [application/x-gzip] Saving to: `nagios-plugins-HEAD.tar.gz’ 100%[===========================>] […]

Read the full article →

(98)Address already in use: make_sock: could not bind to address 0.0.0.0:80

December 13, 2008

root@jakal [~]# /etc/init.d/httpd restart httpd not running, trying to start (98)Address already in use: make_sock: could not bind to address 0.0.0.0:80 no listening sockets available, shutting down Unable to open logs root@jakal [~]# lsof -i tcp:80 COMMAND   PID   USER   FD   TYPE   DEVICE SIZE NODE NAME mysql   12887 nobody    3u  IPv4 14388423       TCP *:http (LISTEN) root@jakal […]

Read the full article →

Install PureFTPd on FreeBSD

December 11, 2008

Install PureFTPd on FreeBSD [dupre@ibm ~]$ su – Password: [root@ibm ~]# cd /usr/ports/ [root@ibm /usr/ports]# make search name=pure-ftp Port:   pure-ftpd-1.0.21_2 Path:   /usr/ports/ftp/pure-ftpd Info:   A small, easy to set up, fast and very secure FTP server Maint:  garga@FreeBSD.org B-deps: R-deps: perl-5.8.8_1 WWW:    http://www.pureftpd.org/

Read the full article →

Akismet Caught Spam : What Do You Count?

December 9, 2008

Akismet Has Caught 19,147 Spam on titik.org What Do You Count?

Read the full article →