Skip to content

Instantly share code, notes, and snippets.

@ihsanberahim

ihsanberahim/auto_db_backup.bat

Last active August 29, 2015 14:07
Show Gist options
  • Save ihsanberahim/42e090f447b54a0c8bd1 to your computer and use it in GitHub Desktop.
Save ihsanberahim/42e090f447b54a0c8bd1 to your computer and use it in GitHub Desktop.
Download ZIP
Automate Database Backup using Mysql Workbench on Windows
Raw
auto_db_backup.bat
set DATET=%date:~-4%_%date:~7,2%
"mysqldump.exe" --host="localhost" --user="{username}" --password="{password}" {database name} > "{folder path}"backup_%DATET%_{database name}.sql
pause
@ihsanberahim
Copy link
Author

GUIDES:

1# Install Mysql Workbench - http://dev.mysql.com/downloads/workbench/
2# make sure "mysqldump.exe" work in your command prompt
3# attach the script in Windows Task Scheduler and set it Run whether the user is logged in or not

SOURCE:
http://goo.gl/iD8vNN

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment