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
