[Maria-discuss] sys schema backup
Hi, The 'sys' schema is documented to be "A collection of views, functions and procedures to help MySQL administrators get insight in to MySQL Database usage." Is there anything in this schema that should be backed up, or can I skip it when creating backups? -- With kind regards, William Edwards
It can be skipped. An installation or a mysql_upgrade will recreate it. On Sat, Dec 4, 2021 at 12:27 AM William Edwards <wedwards@cyberfusion.nl> wrote:
Hi,
The 'sys' schema is documented to be "A collection of views, functions and procedures to help MySQL administrators get insight in to MySQL Database usage." Is there anything in this schema that should be backed up, or can I skip it when creating backups?
-- With kind regards,
William Edwards
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Hi, William! On Dec 03, William Edwards wrote:
Hi,
The 'sys' schema is documented to be "A collection of views, functions and procedures to help MySQL administrators get insight in to MySQL Database usage." Is there anything in this schema that should be backed up, or can I skip it when creating backups?
you might want to back up the sys.sys_config table. the rest can be recreated. Regards, Sergei VP of MariaDB Server Engineering and security@mariadb.org
participants (3)
-
Daniel Black -
Sergei Golubchik -
William Edwards