Back up your databases with mysqldump

mysqldump is a command line utility that allows you to perform backups of MySQL and MariaDB databases.

It is automatically installed during the installation of the MySQL or MariaDB server and it is available for Linux and Windows.

Examples :

mysqldump -uUser -pPassword database > file_bk_name.sql
mysqldump --user=User --password=Password --databases=DB_Name > file_bk_name.sql
mysqldump --host="127.0.0.1" --port="3306" --user="User" --password="Password" --result-file="file_bk_name.sql" DB_Name

Under Windows, you must go to the folder where the exe is located or indicate its full path.




Leave a Comment