MySQL Physical Directory Path – Linux

If you are using MySQL, and want to know the actual physical path of MySQL, where MySQL stores the db, and its information files and the amount of data for MySQL data and MySQL index files i.e. table_name.MYD and table_name.MYI respectively, below is the easy solution.

MySQL Physical Directory Path

In Linux, all you need to do is to access the following folder:
/var/lib/mysql/

You can open it in Terminal or Nautilus (using sudo or root access). Once you get into the folder, you can easily find the folders which are actually your database names, and in the database name folders, you can find the table names, having MYD and MYI extensions, which are actually your data and index files.

Hope it helps.

Uncategorised

Leave a Reply

Your email address will not be published. Required fields are marked *