[rekha]

Hi,

I have a database which i switched from one system to the other and i when i tried the alter table command for adding a column an error is displayed as

Code:
Cannot rename something.MYI to somethingother.MYI Error no 13

I tried all other queries like update and insert and it's all working without flaw..

But alter is not working..

I couldn't find the exact error...Please help.


Regards
Rekha

[shabbir]

It might so happen you do not have the permission to alter table

[rekha]

Hi,

Thanks for your reply.Can you tell me in detail why it is so.


Regards
Rekha

[shabbir]

Your admin has created a low privileges user that you are using to login to the database server.

Also Remember to use the signatures for links to your site and not in posts as its against the forum guidelines.

[rekha]

Hi,

Then how can i solve this error.



Regards
Rekha

[shabbir]

You need the permission and ask them from your database admin.

[trinitybrown]

check that you import database schema in the same where it was located on previous sytem and also check that the previleges you have about database is good enough to make changes

[pradeep]

Please check file permissions!