MySQL database dump from terminal command
Basic dump command :
mysqldump -u root -p prod_helpdesk > db_backup.sql
Dump command with rename file by date time :
mysqldump -u root -p prod_helpdesk > prefix_$(date +%Y-%m-%d-%H.%M.%S).sql
Basic dump command :
mysqldump -u root -p prod_helpdesk > db_backup.sql
Dump command with rename file by date time :
mysqldump -u root -p prod_helpdesk > prefix_$(date +%Y-%m-%d-%H.%M.%S).sql
Comments
Post a Comment