• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

How can I move the mysql datadir?

A

axar

Guest
I run Suse Linux 9.3 with Plesk 8.0.1 on a 1&1 root-server. The mysql datadir is in /var/lib/mysql. Unfortunately, they've made that partition too small for my databases. What would you suggest to do? Should I change the mysql datadir?
I've tried a lot to do that, but it didn't work :(

First I've copied the mysql folder to another place with cp -R -p /var/lib/mysql /srv/mysql

Then I've changed the datadir in /etc/my.cnf and in /etc/init.d/mysql and rebooted, but then Plesk didn't work anymore :(

Please let me know what I have to do to move the datadir to another place.

Thanks,
Andreas
 
verify /etc/psa/psa.conf

Code:
# MYSQL
MYSQL_VAR_D             /var/lib/mysql
MYSQL_BIN_D             /usr/bin
 
Back
Top