Hii

I installed CentOS on an IBM server. Now, i need to install Mysql 5.5 64-bit via RPM. By default, mysql installation path is /var/lib/mysql. But i want to change the path of database storage. I tried --prefix option too but still not done.

Please suggest how can i change the database path because through rpm installation my.cnf file is not created.

Thanks

If my.cnf is not created, you should be able to create it yourself. I guess you are interested in setting the variable "datadir".

HTH,

Evo2.

1 members found this post helpful.

The default for RPM installation is /var/lib/mysql. If you want to have it stored on a different directory, try installing from source.

0 members found this post helpful.

Sorry, but you're very wrong. Moving a database location is as easy as modifying the datadir variable (as evo2 said), in the my.cnf file. From there you either copy/move your current database files to the new location, or start the database for the first time and things come up.

OP, a my.cnf file will be installed if you install the mysql-server, and it's usually in /etc. Note that the file will be installed if mysql SERVER is installed...it's quite possible to install lots of mysql packages (for perl, development headers, clients, etc), and NOT install mysql-server. If you really don't have one, you can find sample my.cnf files through Google, and copy one over, changing the datadir variable as needed.

1 members found this post helpful.