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.
JHDrexler@stripped
-----Original Message-----
From: mysql-digest-help [mailto:mysql-digest-help@stripped]
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" <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
>
>