MySQL Forums
Forum List  »  Newbie

Backup all existing databases except
Posted by: Miguel Rodriguez
Date: March 23, 2023 11:00AM

Hello everyone and thanks in advance for the help.

I have a sequential script that stores one archive per database with mysqldump...
........
mysqldump -R --triggers -l -B "DDBB" | gzip > /Path/$(date +%Y%m%d)/DDBB.sql.gz
......
It works great but when a new database is added to the instance you have to modify the scripts manually...

Can you help me with the selection of ALL THE EXISTING DATABASES except the system ones but that the copy continues to be in independent files, one per bd????

Options: ReplyQuote


Subject
Written By
Posted
Backup all existing databases except
March 23, 2023 11:00AM


Sorry, you can't reply to this topic. It has been closed.

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.