mysql insert not working

[thedosmann]

Trying to work with a mysql insert that isn't working. It bombs on the first insert statement.
The problem is the tables are read-only,
I've checked the tables with myisamchk and there is no corruption.
They are not compressesd.



Any suggestions/ or help would be appreciated.


This turned out to be ownership of the files on linux. I had to ownership of the data dir to mysql.

[Marin]

There is probably SOMETHING wrong with your table. If you have data in it the process should be:
- Backup database
- Script all objects
- Drop database
- Recreate database
- Restore all data

Try to load, if it failes again then try the following:
- Export all data (if it is not empty)
- Script all objects
- Drop database
- Recreate database using saved script
- Insert data from saved set

Good luck!