badlogic

Database Dump BASH Script

Oct 6th, 2016
334
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.41 KB | None | 0 0
  1. #!/bin/bash
  2. echo "Enter database backup name:"
  3.  
  4. read database_backup_name
  5.  
  6. echo "Enter database mysql password:"
  7.  
  8. read database_password
  9.  
  10. mysqldump -uroot -p$database_password --add-drop-database -B dps_accounting_db dps_cashier_db dps_fixedasset_db dps_gatekeeper_db dps_grade_db dps_hris_db dps_library_db dps_main_db dps_payroll_db dps_portal_db dps_purchasing_db dps_registrar_db > $database_backup_name.sql
Add Comment
Please, Sign In to add comment