Web Hosting Talk







View Full Version : moving mysql database


carpman
08-31-2002, 05:19 AM
hello, when my server was setup var partition was set to only 500mb, which is a little small espcially as has mysql databases in sub dir. i have space on another drive and would like to move a couple of databases there.

Could i just move the database dir (user_vbulletin ) to new drive and put sym link to it in /var/lib/mysql/

bitserve
08-31-2002, 04:05 PM
It should work. Let us know if it doesn't.

bobcares
08-31-2002, 11:47 PM
Yes. It would work. However remember to stop mysql when you carrying out this operation.
Have a great day :)

Regards
Amar

carpman
09-01-2002, 07:14 AM
Thanks for reply, i will try it, i may also just move the whole /var/lib/mysql/ but leave /var/lib/ in same place, could i use same method?

many thanks

bobcares
09-01-2002, 07:49 AM
Yes. That would be a good idea...
amar