Where MySQL Data Dir And Innodb Data Home Dir Location

I’m going to move my current MySQL server to another server so I have to backup all my current databases. One important step I need to do is check to see how data files for both MyISAM and InnoDB Storage Engines are stored by taking a look at the datadir and innodb data home dir

Below are methods to find where are data folder:

1. PhpMyAdmin – Variables tab

It’s easiest way and you may find some useful information there. Simply login to the PhpMyAdmin with root account. At the landing page, click on the Variables tab.

Then search for keyword “datadir” and “innodb data home dir”.

2. MySQL configuration file (my.ini or my.cnf)

Or you can find and open the my.ini file (on Windows) or my.cnf file (on Linux) then search for keyword “datadir” and “innodb_data_home_dir”

[text] #Path to the database root
datadir="D:/MySQLData/"
[/text] [text] #*** INNODB Specific options ***
innodb_data_home_dir="C:/MySQL Datafiles/"
[/text]