chmod this !

Anon

Hello folks,

Running on RH7.1, Apache.

I have a website which works fine on Win98 then switched to Linux by copying the .MYD, .MYI, *.frm files over.

SELECTs work fine, but not INSERTs.

It failed from a php page, so then using Webmnin as root issued the same INSERT that PHP failed on, and the error message is

TABLE READ ONLY

I checked the file-level permissions, they seem ok set as 664.

With changing the chmod to 777 on one database i actually got the INSERT\'s working.

If it is neccesary to chmod the database files can this be done in a recursive way

Any thoughts ot insight would be greatly appreciated

Paul

toma42

win vs unix are not bit compataible, I believe. On windows use mysql dump then in unix just run the sql the dump gave you. Of course, delete the files you already copied over first.

psr540

just an idea, code not tested.

write a small program in php like this:

// run shell command to find all files in your path.
$shell_return = find your_path;

//break raw result into an array
$file_list = explode("\n", $shell_return);

// chmod
foreach($file_list as $file)
{
$shell_command = 'chmod '. $file .' 777';
// run it!
$shell_command;
}

also when you run shell commands in php, unix account APACHE(? run shell command id in a php page to check) is used, so be sure you have proper permission.

brandonschnell

chown the file to whatever user mysql is running as. chmod -R 700 the mysql databases & logs. assuming your mysql.sock is outside the /var/lib/mysql path and mysql.mysql is the group.user mysql is running as:

chown -R mysql.mysql /var/lib/mysql
chmod -R 700 /var/lib/mysql