chown -R mysql /home/ecom tpchan wrote: > Hi all, > > I try the solution from David but seem it didn't work. > > Here is my steps: > > 1) Stop the mysql services. > 2) Move the ecom database directory from '/var/lib/mysql/ecom' to > '/home/ecom' > 3) Make symbolic link in '/var/lib/mysql' using 'ln -sf /home/ecom ecom' > 4) Start the mysql services. > 5) mysql > use ecom > > Here the error that I get: > > Didn't find any fields in table 'admin' > Didn't find any fields in table 'user' > .... > > Please point out my error or any solution to solve it. I NEED IT URGENTLY > SINCE I RUNNING OUT OF DATABASE SPACE. > > Thank you in advance. > > Emanduel Chan Tain Por > System Engineer > DotCom Consulting Sdn Bhd > DID : 603-62763230 ext. 112 > > ----- Original Message ----- > From: "David Patton" <[EMAIL PROTECTED]> > To: "tpchan" <[EMAIL PROTECTED]> > Sent: Friday, June 29, 2001 9:47 PM > Subject: RE: HELP! Hard Disk Space limition and Symbolic link > > > >> Yes. >> >> Just shut down the database. >> Move the database directory and make a link back to /var/lib/mysql/ >> >> -----Original Message----- >> From: tpchan [mailto:[EMAIL PROTECTED]] >> Sent: Friday, June 29, 2001 5:58 AM >> To: [EMAIL PROTECTED] >> Subject: HELP! Hard Disk Space limition and Symbolic link >> >> >> Dear all, >> >> I installed mysql version 3.22.32 on Red Hat 6.2 using the rpm package. >> Since mysql data directory is stay in /var/lib/, plus my database is > > growing > >> bigger day by day, my problem now is that the '/var' partition running > > short > >> of free hard disk space. >> >> What I'm trying to do is to transfer the data directory to a new partition >> '/home' which had bigger space. Is there any way to solve this without >> reinstall back mysql server? Will the symbolic link solve this problem? If >> so, how? >> >> Thank you in advance. >> >> Emanduel Chan Tain Por >> System Engineer >> DotCom Consulting Sdn Bhd >> DID : 603-62763230 ext. 112 >> >> >> --------------------------------------------------------------------- >> Before posting, please check: >> http://www.mysql.com/manual.php (the manual) >> http://lists.mysql.com/ (the list archive) >> >> To request this thread, e-mail <[EMAIL PROTECTED]> >> To unsubscribe, e-mail >> <[EMAIL PROTECTED]> >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> >> > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
