36

Our system crashed and we're trying to recover our data. The disc is fine, but the OS is gone, so I'm trying to get at the actual MySQL database files.

Does anybody know where to look for them in a Debian Linux server?

44

MySQL stores DB files in /var/lib/mysql by default, but you can override this in the configuration file, typically called /etc/my.cnf, although Debian calls it /etc/mysql/my.cnf.

  • In Debian default setup, you need to be root to view the contents of /var/lib/mysql, just to make it clear. As user, you'll see an almost empty directory if you do: ls /var/lib/mysql – Lizardx Feb 7 '16 at 23:05

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.