mysql-dump-console-windows

REM AUTHOR  : Suhendra
REM COMPANY : CITSTUDIO
REM URL     : http://www.citstudio.com/
REM EMAIL   : suhendra@citstudio.com

@ECHO OFF
@BREAK OFF
@TITLE CITSTUDIO - MYSQL DUMP
@COLOR 07
@CLS

SET myYEARS=%date:~10,4%
SET myMONTH=%date:~4,2%
SET myDATE=%date:~7,2%
SET myDRIVE=D:
SET rootPATH=<PATH>\mysql-backup
SET createPATH=%rootPATH%\%myYEARS%\%myMONTH%\%myDATE%\
SET fileNAME=%myYEARS%_%myMONTH%_%myDATE%

REM Menandai lokasi file batch dipanggil
pushd %CD%

GOTO FN_COLLECTING_DB

:FN_COLLECTING_DB
ECHO Mengumpulkan database . . .
ECHO.
"c:\xampp\mysql\bin\mysql.exe"  -u root -s -N -e "SHOW DATABASES" | FOR /F "usebackq" %%D IN (`findstr /V "information_schema  performance_schema"`) DO @ECHO - %%D
ECHO.
GOTO FN_CHOOSE_DB

:FN_CHOOSE_DB
SET /P selectDB=Pilih database yang akan di backup [nama_database/all] ?:
IF %selectDB% == all GOTO :FN_DUMP_ALL
IF /I NOT %selectDB% == all (
    IF NOT EXIST %createPATH% MKDIR %createPATH%
    CD /d %createPATH%
    ECHO Proses backup database %selectDB% dimulai . . .
    "c:\xampp\mysql\bin\mysqldump" -u root %selectDB% > backup_%selectDB%.sql
    ECHO Proses backup database %selectDB% selesai . . .
    GOTO FN_CHOOSE_ANOTHER_DB
)

:FN_CHOOSE_ANOTHER_DB
SET /P chooseAnotherDB=Pilih database lain untuk dibackup [y/n] ?:
IF %chooseAnotherDB% == y GOTO FN_COLLECTING_DB
IF %chooseAnotherDB% == n GOTO FN_FINISH

:FN_DUMP_ALL
ECHO Proses backup dimulai
IF NOT EXIST %createPATH% MKDIR %createPATH%
CD /d %createPATH%
"c:\xampp\mysql\bin\mysql.exe"  -u root -s -N -e "SHOW DATABASES" | FOR /F "usebackq" %%D IN (`findstr /V "information_schema  performance_schema"`) DO "c:\xampp\mysql\bin\mysqldump" -u root %%D > backup_%%D_NEW.sql
ECHO Proses backup selesai

:FN_FINISH
popd
@TITLE %CD%
PAUSE

REM REFERENCES :
REM http://ss64.com/nt/for.html
REM http://ss64.com/nt/if.html
REM http://dev-notes.com/code.php?q=49
REM http://dev.mysql.com/doc/refman/5.0/en/mysqldump-sql-format.html
REM http://webcheatsheet.com/sql/mysql_backup_restore.php
REM http://technet.microsoft.com/en-us/library/cc771180%28v=ws.10%29.aspx
REM http://technet.microsoft.com/en-us/library/cc771942%28v=ws.10%29.aspx
REM http://www.computerhope.com/