Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MySQL (http://www.go4expert.com/forums/mysql-forum/)
-   -   alter table error (http://www.go4expert.com/forums/alter-table-error-t8296/)

rekha 17Jan2008 14:31

alter table error
 
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

shabbir 17Jan2008 17:45

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

rekha 18Jan2008 10:25

Re: alter table error
 
Hi,

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


Regards
Rekha

shabbir 18Jan2008 17:53

Re: alter table error
 
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 22Jan2008 12:52

Re: alter table error
 
Hi,

Then how can i solve this error.



Regards
Rekha

shabbir 22Jan2008 17:33

Re: alter table error
 
You need the permission and ask them from your database admin.

trinitybrown 25Oct2008 11:57

Re: alter table error
 
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 25Oct2008 14:31

Re: alter table error
 
Please check file permissions!


All times are GMT +5.5. The time now is 07:43.