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.

MySQL / MariaDB
Backupmariadb
Soutenir
LinkedInReddit

📚 Articles similaires

Romain Drouche
System Architect | MCSE: Core Infrastructure
IT infrastructure expert with over 15 years of field experience. Currently a Systems and Networks Project Manager and Information Systems Security (ISS) expert, I use my expertise to ensure the reliability and security of technological environments.

Leave a Comment