In this post, I am sharing required steps to move MySQL Data Directory from old location to new location. Check the current data directory of MySQL: [crayon-6a246d7c17a91086083215/] Stop the MySQL Service: [crayon-6a246d7c17a95428330996/] Confirm the inactive status of MySQL Service: [crayon-6a246d7c17a96973860235/] Output: [crayon-6a246d7c17a97990312357/] Use rsync with -av flag to copy the existing database directory to the […]

I'm Anvesh Patel, a Database Engineer certified by Oracle and IBM. I'm working as a Database Architect, Database Optimizer, Database Administrator, Database Developer. Providing the best articles and solutions for different problems in the best manner through my blogs is my passion. I have more than six years of experience with various RDBMS products like MSSQL Server, PostgreSQL, MySQL, Greenplum and currently learning and doing research on BIGData and NoSQL technology. -- Hyderabad, India.