/etc/mysql/my.conf, you can easily set
datadir=/mnt/your_block/mysql, but there are some deeper issues with
apparmor. How do I reconfigure
apparmor to acknowledge my new
I’ve followed directions at [this] (http://askubuntu.com/questions/137424/moving-mysql-datadir) StackOverflow post, but upon completion I get
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/mnt/volume-nyc1-01/mysql/mysqld.sock'
I can’t find
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Click below to sign up and get $200 of credit to try our products over 60 days!
How To Move a MySQL Data Directory to a New Location on Ubuntu 16.04 is available now.
Here are the commands I used (see reply above):
I’m having no luck on Ubuntu 14.04. I followed the StackOverflow commands above and when I attempt to restart mysql I get:
2016-08-25 15:54:08 1909 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.user’ doesn’t exist
in the error log.
Is there an official DigitalOcean tutorial for 14.04?