Move mysql tables to another disk/partition

Question

I have mysql data mounted to

/var/lib/mysql

And what I want is to move it to

/fast/mysql

My plan is following:

Are there any problems with my plan?

you could move the data and do a symbolic link from the original location. — Wolfgang Fahl, Mar 27, 2013 at 19:09
@WolfgangFahl, yup, symbolic link seems fast solution. As I understood you suggest to make link from /var/lib/mysql folder to /fast/mysql folder. I mean particularly folder links, not file links? — Jevgeni Smirnov, Mar 28, 2013 at 7:38
mv /var/lib/mysql /fast/mysql;ln -s /fast/mysql /var/lib/mysql - see answer below — Wolfgang Fahl, Mar 28, 2013 at 8:03

Johnny · Accepted Answer · 2013-03-27 18:42:43Z

0

If you're running apparmor, you'll need to tell it that MySQL is allowed to access the files at the new location.

Your distribution may be configured differently, but on Ubuntu 12.10, you'll need to edit this file:

/etc/apparmor.d/usr.sbin.mysqld

answered Mar 27, 2013 at 18:42

Johnny

8037 silver badges9 bronze badges

Add a comment |

Wolfgang Fahl · Accepted Answer · 2013-03-28 08:04:51Z

0

you might want to use a symbolic link

mv /var/lib/mysql /fast/mysql
ln -s /fast/mysql /var/lib/mysql

answered Mar 28, 2013 at 8:04

Wolfgang Fahl

2181 gold badge2 silver badges14 bronze badges

The only question, why I just can't use point 3 from my plan? I mean why changing value in my.cnf is not good solution and I need to use link?
– Jevgeni Smirnov
Mar 28, 2013 at 8:43
My answer is about the move part more than the cnf part. You proposal was copying, I don't know whether you where intending to copy.
– Wolfgang Fahl
Mar 28, 2013 at 9:33

Add a comment |

2 Answers 2