Timeline for Data directory of mysql moving from one drive to different drive?
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 9, 2017 at 15:13 | comment | added | Rick James |
Everything (except my.cnf) that MySQL needs is in that single directory tree. So, moving the tree works and changing the pointer to it works. For all engines. Log files are a possible exception -- but there are other VARIABLES pointing to them so that they can be controlled separately.
|
|
| Jul 5, 2017 at 12:58 | comment | added | akumar | @SAM AB it should not throw error if you follow steps properly. You can check the appropriate permissions on new data directory if you are getting such error. | |
| Jul 5, 2017 at 12:48 | comment | added | SAM AB | if i did these steps ,after that i will query like this "select * from employee" ,will it show results or it will throws an error like 'employee table doesn't exist' | |
| Jul 5, 2017 at 9:39 | vote | accept | SAM AB | ||
| Jul 5, 2017 at 9:33 | comment | added | akumar | @SAMAB Yes, I works for both engine types. If you have any doubt I would suggest to perform steps on any local machine with mixture of engines or any single type according to your requirement. | |
| Jul 5, 2017 at 9:29 | vote | accept | SAM AB | ||
| Jul 5, 2017 at 9:39 | |||||
| Jul 5, 2017 at 9:29 | vote | accept | SAM AB | ||
| Jul 5, 2017 at 9:29 | |||||
| Jul 5, 2017 at 9:29 | comment | added | SAM AB | Are you sure it will work same with Innodb files ,as this process worked for only myisam tables i heard. Please make sure it is correct? | |
| Jul 5, 2017 at 9:08 | history | answered | akumar | CC BY-SA 3.0 |