Scenario:
You are working as MySQL/ MariaDB DBA, you have a MySQL or MariaDB service on which you have many databases, you need to take backup of all the databases in single file. Later this file can be used on same of different Server for restore purpose.Solution:
mysqldump program can be used to take backup of all the databases in single file. Below statement should do the trick.
mysqldump -u root -p --all-databases >/destinationdirectory/AllDatabases.sql
Video Demo : How to backup all databases to single file in MySQL or MariaDB by using mysqldump
Do you have any suggestion on how to automate the backup to file server or cloud?
ReplyDeleteMua vé tại Aivivu, tham khảo
ReplyDeletekinh nghiệm mua vé máy bay đi Mỹ giá rẻ
mua vé máy bay về việt nam từ mỹ
chuyen bay nhat viet
chuyến bay từ frankfurt đến hà nội
thông tin chuyến bay từ canada về việt nam
vé máy bay từ hàn quốc về việt nam bao nhiêu tiền