How To Move a MySQL Data Directory to a New Location

Databases grow over time, sometimes outgrowing the space on the file system, or leading to I/O contention. Whether you’re adding more space, evaluating ways to optimize performance, or looking to take advantage of other storage features, this tutorial will guide you through relocating MySQL’s data directory. Choose your operating system below to get started.

Ubuntu

20.04

How To Move a MySQL Data Directory to a New Location on Ubuntu 20.04

Learn How To Move a MySQL Data Directory to a New Location on Ubuntu 20.04
18.04

How To Move a MySQL Data Directory to a New Location on Ubuntu 18.04

Learn How To Move a MySQL Data Directory to a New Location on Ubuntu 18.04
16.04

How To Move a MySQL Data Directory to a New Location on Ubuntu 16.04

Learn How To Move a MySQL Data Directory to a New Location on Ubuntu 16.04

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.