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?
Printable View
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?
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.
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.Quote:
Originally Posted by globaldelegation