Solved!
Go to SolutionMove embedded mysql db to different drive
Hello,
My embedded mysql db is close to running out of space and I would like to migrate it to a different drive on the same host. Is there any documentation or can someone post the commands on how to do this? I've read the Appendix in the vFoglight 6.5 installation and Setup Guide: Installing on Windows with an Embedded MySQL Database. But that only applies if you are migrating the db to an external host.
Thanks,
earlpdx
My embedded mysql db is close to running out of space and I would like to migrate it to a different drive on the same host. Is there any documentation or can someone post the commands on how to do this? I've read the Appendix in the vFoglight 6.5 installation and Setup Guide: Installing on Windows with an Embedded MySQL Database. But that only applies if you are migrating the db to an external host.
Thanks,
earlpdx
- Larry's suggestion of moving to an external DB instance is definitely the preferred solution however if for any reason that is not an option for you then you can move your entire vFoglight installation folder to another drive since the MySQL directory has to stay to its default location as Larry mentioned.
There are bunch of steps that need to be executed in sequence that we can provide details.
Regards
lmurphy1
57 Posts
179
0
Posted December 28th, 2010 20:00
With that said, you can install MySQL on the machine with the data files on the drive you choose and move the migrate the embedded db to an "external" instance (running locally on the same machine).
-LArry