where are the physical files with all the information of the mysql databases, in ubuntu? It is to recover the information in case the computer crashes and it is not possible to access mysql.
where are the physical files with all the information of the mysql databases, in ubuntu? It is to recover the information in case the computer crashes and it is not possible to access mysql.
The place is usually: /var/lib/mysql but to make sure, we need to look at the my.cnf file. This file is located at:
Ubuntu, Debian and derivatives: /etc/mysql/my.cnf Red Hat, Fedora and derivatives: /etc/my.cnf There we can see the value of datadir. The exact way the data is stored will depend on the storage engine you use: MyISAM, InnoDB, etc.