Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Full Database Backup?

BoBBers's profile image BoBBers posted 5 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
ansgar's profile image ansgar posted 5 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
BoBBers's profile image BoBBers posted 5 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.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.