9

I know it's not necessary to backup the information_schema database, but what about the following databases (besides the user-defined databases)?

  • performance_schema
  • mysql
  • phpmyadmin

(So, in case of problems, and we've to start from scratch (fresh MySQL-install), which databases do I've to place back)?)

1 Answer 1

10
  • performance_schema: Not necessary. It may contain performance metrics that are only good for the time you were using the instrumentation. It would serve no purpose to load collected metrics from the past into another MySQL instance or into the same MySQL instance at a much later time.

  • mysql : BE VERY CAREFUL HERE !!! If you backup mysql, you can only reload it into the same version of MySQL it came from. In particular, the mysql.user is neither forward nor backward compatible. See my old posts:

  • phpmyadmin : If you wish to reload a backup of phpmyadmin into the same MySQL instance it came from, that would be fine.
2
  • Thanks a lot for your reply! My question was about making backups for starting from scratch after loosing all data in case of an calamity, I will edit the question a bit.
    – waanders
    May 13, 2015 at 14:05
  • Instead of editing the question, please submit a separate question if there are more details involving doing the backups themselves. May 13, 2015 at 14:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.