View source for Move MySQL to Home Partition

To move MySQL from '''/var/lib/mysql''' to '''/home/mysql''' please do the following:

Use the following command to stop MySQL:

<pre>
service mysqld stop
</pre>

Use the following command to edit the MySQL Config File:

<pre>
vi /etc/my.cnf
</pre>

Then change the following:

<pre>
datadir=/var/lib/mysql
</pre>

To the following:

<pre>
datadir=/home/mysql
</pre>

Then use the following command to make the '''/home/mysql''' directory:

<pre>
mkdir /home/mysql
</pre>

Then set the ownership of this directory using the following command:

<pre>
chown mysql:mysql /home/mysql
</pre>

Then move the MySQL files using the following command:

<pre>
mv /var/lib/mysql/* /home/mysql/
</pre>

Use the following command to restart MySQL:

<pre>
service mysqld restart
</pre>

Then perform a '''mysqlcheck''' using the following command:

<pre>
mysqlcheck –Ar
</pre>

Wait for this to finish and it should be fine.

If this is done on a backup server perform the following commands:

<pre>
service bacula-sd restart
service bacula-fd restart
service bacula-dir restart
</pre>

[[Category:MySQL]]
[[Category:Bacula]]
[[Category:Backups]]
[[Category:Linux]]
[[Category:Contents]]