Full Database Backup?

20 posts
BoBBers's profile image BoBBers posted 7 years ago in General Permalink

Hello, I would like to ask if my subsequent settings are correct.

I would like a full backup in order to restore everything in doubt. Is that right?

1 attachment(s):
  • 2017-03-29-07_36_21-2017-03-29-07_28_11-rsync-Wiki-ubuntuusers.de.png
10137 posts
ansgar's profile image ansgar posted 7 years ago Permalink

Looks good, apart from the selection of databases. You have not only selected user created databases, but also these:

  • "information_schema": system views with dynamic content, don't ever make a backup of that
  • "mysql": user privileges and some other system stuff. Probably not a good idea to restore that after upgrading to a new server version, as structure may change when upgrading
  • "performance_schem": system views, don't ever make a backup of that stuff
20 posts
BoBBers's profile image BoBBers posted 7 years ago Permalink

Thank you for response!

I now i take only own created databeses into my backup! Thank you :)

Please login to leave a reply, or register at first.