How to Change MySQL Database Location

[sayan751]

i am using mysql5.3. All databases created are stored in a default system defined directory.

Now my query is that is it possible to change that default database location?

If yes then how?

[masijade]

For the entire server data.
MySQL :: MySQL 5.1 Reference Manual :: 2.1.5 Installation Layouts
For the "datadir" option
MySQL :: MySQL 5.1 Reference Manual :: 5.6 Running Multiple MySQL Servers on the Same Machine
for the "datadir" option
MySQL :: MySQL 5.1 Reference Manual :: 5.1.2 Server Command Options
for the "datadir" option without having to enter it at the command line
MySQL :: MySQL 5.1 Reference Manual :: 4.2.3.2 Using Option Files

It is always beneficial to read the manual.

[globaldelegation]

Yes you can change it. Usually, the DB will only be indirectly referenced from your application. you can keep your application, change your reference (the jndi/persistence xml file) and then you can just copy and past your database to the desired location.

[masijade]

Yes you can change it. Usually, the DB will only be indirectly referenced from your application. you can keep your application, change your reference (the jndi/persistence xml file) and then you can just copy and past your database to the desired location.

This is not what he talking about though. As a matter of fact, what he is talking about has absolutely nothing to do with Java. It has to do with the physical installation and configuration of the DB itself.