MySQL Forums
Forum List  »  Backup

Backup MYSQL database on windows
Posted by: Raja MSSQL
Date: October 27, 2022 10:05PM

Hi All,

I would like to get your suggestion to automate backup of MYSQL database.

Overview: I have 40 databases migrated from MSSQL to MYSQL. Total size of all databases is about 60 GB. (single database maximum size is 9 GB). Per year the growth rate is very low overall 20 GB for all databases.


Dev team require refresh database monthly from live to Development as well.
Which backup method is best for my application. Percona xtrabackup (OR) mysqldump? (OR) configure slave and do backup?

Options: ReplyQuote


Subject
Views
Written By
Posted
Backup MYSQL database on windows
61
October 27, 2022 10:05PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.