Moving db,data, data1


If you want to move these files for what ever reason, genrally space and performance then

in this example I am moving them to an area in /u10/mysql-infinidb

 

cp /usr/local/Calpont/mysql/db /u10/mysql-infinidb/

chown -R mysql:mysql  /u10/mysql-infinidb/db

cp /usr/local/Calpont/data /u10/mysql-infinidb

chown -R mysql:mysql  /u10/mysql-infinidb/data

cp /usr/local/Calpont/data1 /u10/mysql-infinidb/

chown -R mysql:mysql  /u10/mysql-infinidb/data1

 

Then link the folders back

 ln -s /u10/mysql-infinidb/db /usr/local/Calpont/mysql/db

 ln -s /u10/mysql-infinidb/data /usr/local/Calpont/data

 ln -s /u10/mysql-infinidb/data1 /usr/local/Calpont/data1

 

 

Advertisements

One Comment on “Moving db,data, data1”


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s