Home / server / Questions / 351082
Accepted
Spirit
Asked: 2012-01-19 07:37:17 +0800 CST

Mysql | Change the location of the databases folder

  • 772

I have a HP-UX server with two instances of Mysql.

  1. The first one was the original and was located in /mysql, and keeps its database files in /mysql/data/

  2. The second one I have installed by mistake and is located in /usr/local/mysql, and it keeps its database files in /usr/local/mysql/data/

Now the problem is (i guess because of the new installation), when i issue the command to start the mysql daemon (the original one located in /mysql) i receive the following message:

enter image description here

... so as you can see I start the daemon from the old instance of mysql but when it starts it is now using the new installation database files.

How can i change the path (what file i should edit) in order to make the daemon to point to the old database files that are located in /mysql/data/?

mysql hp-ux

2 Answers

  1. Best Answer

    this should answer your question. it describes how mysql reads configuration files. It looks like you will need two users for mysql to run two instances from two different locations.

    • 2

  2. You can pass an option to mysqld here is the link http://docs.oracle.com/cd/E17952_01/refman-5.5-en/mysqld-safe.html

    so, just start mysqd-safe script with --datadir=your_path option :

        #/mysql/bin/mysqld-safe --datadir=/mysql/data
    • 2