Change MYSQL Database Directory Path in Linux


Step 1: Stop MYSQL

sudo service mysqld stop
Step 2: Copy MYSQL data to new path

sudo cp -R [old path] [new path]
Note: By default we have /var/lib/mysql as [old path]

Step 3 : Change user to mysql for new data directory

sudo chown -R mysql:mysql [new path]
Step 4 : Apply proper security context

sudo chcon -R -t mysqld_db_t [new path]
Step 5 : Edit /etc/my.cnf

[mysqld]

datadir=[new path]

socket=[new path]/mysql.sock


[mysql]

socket=[new path]/mysql.sock

Comments

Post a Comment

Popular posts from this blog

Index MySQL datadase table in Solr

Prerequisites Download the following jars. 1. MySQL jar 2. Solr Data Import Handler jar Data Configuration File Create a data-config.xml file in conf folder & add following content to it. <dataConfig>     <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://<host>:<port>/<database name>" user="<user>" password="<password>" batchSize="1" />     <document name="userdoc">         <entity name="userentity" query="select ID, FIRST_NAME, LAST_NAME from users">             <field column="id" name="ID"/>             <field column="first_name" name="FIRST_NAME" />             <field column="last_name" name="L...
Read more

Hibernate Sharding Example

It is a simple implementation of Hibernate Sharding in java. In this we are using two databases i.e. shard1 and shard2. All data related to "India" goes to shard1 where as others go to shard2. Project Contents: File Name Use DatabaseCreator.java Used to create tables in databases named shard1 and shard2. User.java POJO class. User.hbm.xml Mapping file. Used to map POJO to database tables. hibernate0.cfg.xml Hibernate configuration file for database named shard1 hibernate1.cfg.xml Hibernate configuration file for database named shard2 IdGenerator.java Class for Id generation HibernateShardUtil.java Class for loading hiberante session factory. UserShardResolutionStrategy.java Class for implementing shard resolution strategy. UserShardSelectionStrategy.java Class for implementing shard selection strategy. Main.java Clie...
Read more

Shallow Copy

In Shallow copy all the fields are just copied from source object to destination object. If the source object is containing any field that holds a reference to another object then only the reference will be copied i.e. source and destination objects field(that particular field) will point to same memory location. Java code for Shallow Copy package shallow; class JobDescription {     private String designation;     public JobDescription(String designation) {         this.designation = designation;     }     public String getDesignation() {         return designation;     }     public void setDesignation(String designation) {         this.designation = designation;     }     @Override     public String toString() {...
Read more