If install MySQL from a source distribution(*.tar.gz), its default data location is “/usr/local/mysql/var”.
If install MySQL from a binary distribution, its default data location is “/usr/local/mysql/data”.
If install MySQL from a RPM file(*.rpm), its default data location is “/var/lib/mysql”.
But if we take over MySQL management after the system and database is installed by someone, how to know the location of default or custom database?
In system console, log on SQL console and type sql command as show databases; to show which databases need to be realized.
To do the find command again but change search path from / to found path as /var/lib/mysql/emdp, we can realize whether the file type belong to MySQL data format(*.frm).
沒有留言:
張貼留言