MySQL Forums
Forum List  »  Backup

MySQL Backup system schemas
Posted by: udara Ratnayake
Date: February 17, 2020 09:56PM

Hi When we configure backup for MySQL , do we need following schema to backup as a best practise .

information_schema, mysql, performance_schema, sys-
Q1. In case we need to restore information_schema, then will oversight existing meta data . Do you thing its normal.
q2.Backing up following schema would be best practise ?
Q3. While backing up information_schema im getting following error. But backup was done.

mysqldump: Dumping 'information_schema' DB content is not supported

What is the alternative way of doing it.

thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Backup system schemas
3017
February 17, 2020 09:56PM
1285
February 17, 2020 11:47PM


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.