"Permission Denied" in database data file directory

[JoeNonneman]

First let me apoligize, I expect this question is more about Linux than MySQL. I am using Cobalt MySQL Release 3.23.37-1 with RedHat 7.1 on a Cobalt RAQ4i (this is Intel architecture). When I use MySQL on Windows NT I can get into the database directories, copy out the files(.ftm .myd, .myi), move them to another directory, etc. This I find to be a very convenient feature of MySQL. What I want to do is now copy my database files from my local NT machine to the RAQ in order to restore the database on the RAW to my local configuration. When I try to cd into the database directory (called mysql, /home/mysql/mysql) I get the following error:

[admin mysql]$ cd /home/mysql/mysql
[admin mysql]$ ls
ls: .: Permission denied

I know my database files are in there because of a locate command:

[admin /]$ locate movie

/home/mysql/mysql/movie.frm
/home/mysql/mysql/movie.MYI
/home/mysql/mysql/movie.MYD

The permissions on the directory are:

[admin mysql]$ ls -l
drwx--x--x 2 mysql root 1024 Sep 25 2001 mysql

Do I need to shut down MySQL to move the new files here, are my permissions screwed up, or am I just doing this the wrong way? I have about 10 tables (30 files) in the database and just want to back up my NT version and restore remotely on the RAQ. Sorry I don't know Linux very well which is probably the root of the problem here. Thanks for any suggestions.

 

[KarveR]

Your permissions show that the directory is owned by root, and you only have execute permission not read or write.

I would suggest getting a large chunk of phpmyadmin on both servers and dumping table and data structure from IIS and uploading it through phpmyadmin to your raq ... UNLESS you can log in as root and chmod 755 the mydsql directory ***************************************
Party on, dudes!