Once you moved the files, did you check the ownership and permissions? I have had the same error after restoring databases from a backup, only to find the files were owned by root and the permissions were munched. Something that I have been known to do is to add another, larger disk drive, or raid array, or whatever, copy the files to it, and mount it using a mount point of /var/lib/mysql. It has worked very well in a pinch. It also sidesteps issue that can arise from trying to backup symbolic links with certain backup utilities. If I need to detail the steps on that then let me know. [EMAIL PROTECTED] -----Original Message----- From: mysql-digest-help [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 01, 2001 10:37 PM To: david.patton Cc: tpchan; mysql Subject: URGENT! Hard Disk Space limition and Symbolic link 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