alter table error

rekha's Avatar
Contributor
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:
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

Last edited by shabbir; 17Jan2008 at 17:45.. Reason: Confine links to signature
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
It might so happen you do not have the permission to alter table
0
rekha's Avatar
Contributor
Hi,

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


Regards
Rekha

Last edited by shabbir; 18Jan2008 at 17:52.. Reason: Confine links to signature
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
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.
0
rekha's Avatar
Contributor
Hi,

Then how can i solve this error.



Regards
Rekha
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
You need the permission and ask them from your database admin.
0
trinitybrown's Avatar, Join Date: Oct 2008
Go4Expert Member
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
0
pradeep's Avatar, Join Date: Apr 2005
Team Leader
Please check file permissions!