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'
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
