Backup Database dengan File Batch and Win Scheduler

January 24, 2012 at 6:06 am Leave a comment

Hari ini coba-cari metode backup di Windows dengan DBMS Mysql, akhirnya kesampaian juga, walau memang sangat2 asal2an..hehe..😀. Kalo ada waktu, mau di buat lebih bagus. Ini ceritaku (haha…):

Let the picture explaining it, hehe..

Append this script to the file D:\DATABASE-Jan-2012\backupscript.bat” which included at the configuration (itu file batch yang akan di execute sesuai dengan waktu yang telah ditentukan).

C:\xampp\mysql\bin\mysqldump.exe -u root --database cdcol > d:\cdcol-Tanggal-%date:~4,2%-%date:~7,2%-%date:~10,4%_JAM_%time:~1,1%h-%time:~3,2%m-%time:~6,2%s%.sql

And, Finish. Ini hasilnya :

Entry filed under: Backup, Computer SW, Database. Tags: .

Tentang Belajar Remote Desktop dengan Mode Auth yang Super Lucu :D

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed

Because I Learn CI and Jquery

Twitter Updates

Error: Twitter did not respond. Please wait a few minutes and refresh this page.

My FB page

%d bloggers like this: