How to dump all databases for backup. Backup file is sqlcommands to recreate all db’s

by

# [mysql dir]/bin/mysqldump -u root -ppassword –opt >/tmp/alldatabases.sql

To dump all databases in MySQL for backup, you can use the mysqldump command-line utility. Here’s the command:

bash
mysqldump -u username -p --all-databases > backup.sql

Replace username with your MySQL username. When you run this command, it will prompt you to enter your MySQL password. After entering the password, it will dump all databases into a file named backup.sql.

This backup.sql file contains SQL commands to recreate all databases, including their tables, data, and other objects.