0

I have a centos server, which I've broke its mysql, so I'm going to do a mysql secure installation to fix it.

I wanted to know, where are mysql data (including my databases and tables) are stored so that I could make a manual backup from them? in which directory?

Or Is there anywhere else that I need to get backup from before a new secure installation?

Or in general is there any other way to reinstall mysql without loosing data?

My current mysql is broken because it seems I broked it's configuration in Iptables, so I'm getting this error while trying to use mysql in ssh: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

also I cannot use dumpsql, again because my mysql configuration is broken.

JaamySK
  • 99
  • 1
  • 10
  • Does this answer your question? [Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)](https://stackoverflow.com/questions/4448467/cant-connect-to-local-mysql-server-through-socket-var-lib-mysql-mysql-sock) – Tangentially Perpendicular May 15 '22 at 07:38

0 Answers0