I posted a query on this a couple of days ago, but have tried an alternative
tack.
Using MyCC to add a field to a table, I get an error
[localhost] ERROR 7: Error on rename of '.\rocktest\companies.MYI' to
'.\rocktest\#sql2-15c-15.MYI' (Errcode: 13)
But If I use mysql from the command line
mysql> use rocktest
mysql> alter table companies
-> add new_field integer;
The command works. As I mentioned before, I tried this with MySQL Studio and
NavCat? MySQL Explorer with the same errors. MySQL itself is runnung fine so
I don't think it's permissions?
OS - Windows XP Pro, MySQL ver 4.0.1-alpha-nt
Thanks in advance
Jeff Dyer
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
