Take a Database Backup on Terminal Leave a comment

It’ simple to use mysqldump to taking a database backup on terminal:

mysqldump -uDATABASEUSERNAME -pPASSWORD database_name > database_name.sql

If you don’t want to use the password with command line:

mysqldump -uDATABASEUSERNAME -p database_name > database_name.sql

It is possible to use

mysqldump --user=DATABASEUSERNAME --password=PASSWORD database_name > database_name.sql

Leave a Reply

Your email address will not be published. Required fields are marked *