difference between localstatedir and datadir
 

Hello everybody,

Before installing mysql, i thought i do some research..
came across few key words that i couldn't understand....
and i was hoping someone could help me with this

my plans is to install mysql in /wwwroot/mysql
and i like to maintain the databases in the folder var/mysqldata


./configure --prefix=/wwwroot/mysql --localstatedir=/var/mysqldata

./configure --prefix=/wwwroot/mysql --datadir=/var/mysqldata

between the localstatedir and datadir... which configuration saves or keeps the database that you create...

looked this up but it just got more confusing.
can someone explain the difference between the 2 for me, please..

Robin

datadir is where your tables are stored. since you are installing it onto linux, you only need datadir. the flags vary depending on your OS. http://www.mysql.com/doc/en/MySQL_binaries.html