Move MySQL data to different location

[Ahmad Sakhi]

Hello everyone,

I was in the process of loading a large amount of data (~300 GB). After a while, the process stopped, and after troubleshooting I figured that the drive where MySQL stores (data?) files is filled up 100%, under /

I believe this location is configured in mysql.ini for "datadir". My understanding is:

1. Stop MySQL process: <-- How do we do it in linux? does kill -9 for mysql process would work?

2. copy (or move) the data files that's specified in mysql.ini to new location.

3. update mysql.ini datadir to new location.

4. start mysql process. <-- How do we do it in linux?


Thanks.