Ed, Thanks for the info. I was just thinking another option also. I dont know if its any realistic one. Can we mount 2nd machines disk on to server in question and copy all the data files to that volume and create symbolic links and see if that database comes up and works. Any suggestions will be of great help.., Thanks, Srinivas' -----Original Message----- From: Ed Wilts [mailto:ewilts@xxxxxxxxxx] Sent: Friday, February 20, 2004 2:31 PM To: redhat-list@xxxxxxxxxx Subject: Re: Disk Full Problem.... On Fri, Feb 20, 2004 at 01:41:09PM -0500, Srinivas Koppisetti wrote: > Can we move mysql data files to a different volume and ask the endine to > pick the data files from there. If so I need some more help on how to do > that. I'm doing this off the top of my head so double-check my work before you shoot yourself in the foot. I have not verified that mysql follows symbolic links. An alternative to using the symbolic link is to edit /etc/rc.d/init.d/mysqld and change the datadir symbol, but you'll have to be careful with every mysql update that your edited version of the mysqld script doesn't get overwritten. Assume your new disk is /u01 and you want to move the databases to /u01/mysql. # /sbin/service mysqld shutdown # du -sh /var/lib/mysql See how much space is used now. # ls -ltR /var/lib/mysql Check file owners and permissions too # mv /var/lib/mysql /u01/mysql # du -sh /u01/mysql # ls -ltR /u01/mysql # ln -s /var/lib/mysql /u01/mysql # ls -ltR /var/lib/mysql You should see the same files but in the new locations # /sbin/service/mysqld start -- Ed Wilts, Mounds View, MN, USA mailto:ewilts@xxxxxxxxxx Member #1, Red Hat Community Ambassador Program -- redhat-list mailing list unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list =========================================================================== This electronic transmission contains confidential information intended only for the person(s) named. Any use, distribution, copying, or disclosure by any other person is strictly prohibited. If you received this transmission in error, please notify the sender by return e-mail and delete all copies of this message. =========================================================================== -- redhat-list mailing list unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list
