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)?)

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.
  • 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 '15 at 14:05
  • Instead of editing the question, please submit a separate question if there are more details involving doing the backups themselves. – RolandoMySQLDBA May 13 '15 at 14:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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