Move mysql to other disk

[Smugg]

Hello,

in default DA store mysql data in /home/mysql. My sda is getting too slow so i bought ssd disk and mount it as /mysql/. How can i move mysql to new drive ?

 

[zEitEr]

Hello,

Why don't you mount it as /home/mysql ?

1. Mount ssd disk as /home/mysql-tmp
2. Stop MySQL server
3. Move /home/mysql/* to /home/mysql-tmp
4. Unmount /home/mysql-tmp
5. Mount ssd disk as /home/mysql
6. Start MySQL server.

 

[nobaloney]

in default DA store mysql data in /home/mysql.

Not on my machines. Which OS do you run?

Jeff

 

[zEitEr]

@Jeff,

It's FreeBSD I guess, mysql data on FreeBSD boxes is stored in /home/mysql

 

[nobaloney]

Then for the sake of completeness, let's add that if you want to save mysql databases to a different disk/partition on CentOS or Red Hat Enterprise Linux, you should instead mount the new disk/partition to an empty /var/lib/mysql mountpoint.

I can't advise for Debian, because I'm not running it; perhaps somone else will add the correct location under Debian to the thread.

Jeff

 

[zEitEr]

OK, Debian keeps MySQL data the same way as FreeBSD in /home/mysql

 

[Smugg]

Thanks for help

i simply mount ssd as /home/mysql