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.

Romain Drouche

Romain Drouche

System Architect | MCSE: Core Infrastructure

An IT infrastructure expert with over 15 years of hands-on experience. Currently serving as a Systems and Network Project Manager and Information Systems Security (ISS) Lead, I leverage my expertise to ensure the reliability and security of technological environments.

GHinM▶