Re: Run MySQL on database located on another computer/resource

[Gabriela Martinez Sanchez]

Hi Rasinc

This is possible once you configure the data directories on the my.config file, or by passing this option when starting the server ( --datadir=<<location>>\data )

You can set this up by doing the following:

1 Stop your mysql server before starting this operation.
2 Create the directories that will be new datadir.
3 Assign the proper credentials and ownership to this folder.
4 copy the files from the old datadir to the new location. However, make sure that the files named ib_arch_log_0000000000, ib_logfile0 etc. are not copied to the newer location.
5 Make sure that the files and directories are owned by mysql user
6 Make changes in the my.cnf to point the new datadir.
7 Restart the MySQL database


As always is recommended to make a backup of your existing set up.


Hope this helps.