List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:July 2 2001 1:45pm
Subject:Re: URGENT! Hard Disk Space limition and Symbolic link
View as plain text  
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" <david.patton@stripped>
> To: "tpchan" <tpchan@stripped>
> 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:tpchan@stripped]
>> Sent: Friday, June 29, 2001 5:58 AM
>> To: mysql@stripped
>> 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 <mysql-thread78027@stripped>
>> To unsubscribe, e-mail
>> <mysql-unsubscribe-david.patton=kmobjects.com@stripped>
>> 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 <mysql-thread78149@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
URGENT! Hard Disk Space limition and Symbolic linktpchan2 Jul
RE: URGENT! Hard Disk Space limition and Symbolic linkJHDrexler2 Jul
Re: URGENT! Hard Disk Space limition and Symbolic linkGerald Clark2 Jul