mySQL tables on the remastered CD are read only

[lueckmw]

I'm trying to use mySQL on a remastered disk and keep getting the error:

Table "table_name" is read only

when my web application tries to write to the tables. I'm new to mySQL so I don't know if this is a permissions problem on the CD or if this is a mySQL problem. It looks to me like the tables reside on the ramdisk and should be writable, only they're not. The same setup works without a problem on my harddisk install. Am I missing something here? Has anyone else tried this kind of thing before?

Thanks for your help,
Matt

[rneff]

If the sql data does reside in the ramdisk (why do you think it does) you would be able to write to it while it is in ram, but as soon as you reboot, youwould loose allthat. What woudl be the point?

[Ambrose]

Basically, the tables are symlinked to the original tables on the knoppix cd. To fix:

rm /var/lib/mysql/* -f
cp -Rp /KNOPPIX/var/lib/mysql/* /var/lib/mysql/

This will make your tables writable.

Hope this helps,

- Ambrose