forums › forums › SQLyog › Using SQLyog › Error 1227
- This topic is empty.
-
AuthorPosts
-
-
October 15, 2003 at 5:02 pm #8201GluedToTheScreenMember
I just tried backing up a remote db to my local system again. It worked fine the first time… but now I get error 1227: Access denied. You need the file privelege for this operation.
Remote is Linux, local is WinNT WS. To my knowledge, nothing has changed on either computer.
What do I need to do to be able to back up the db?
-
October 15, 2003 at 5:42 pm #15086RiteshMember
Can you attach a screenshot of the BACKUP dialog with the error message?
I guess you are selecting some options for which you dont have privileges….
-
October 16, 2003 at 4:52 am #15087GluedToTheScreenMember
OK, I tried again… here is screenshot. Thanks for your help.
-
October 16, 2003 at 8:12 am #15088RiteshMember
BTW, did you use the same option to BACKUP DATABASE…. for the first time also?
-
October 16, 2003 at 2:00 pm #15089GluedToTheScreenMember
Yes… it created a bunch of .frm and .MYD files and not .sql scripts.
-
October 16, 2003 at 5:22 pm #15090RiteshMember
I think there is PERMISSION problem.
Check out with your MySQL Admin…
-
October 18, 2003 at 4:00 pm #15091GluedToTheScreenMember
The sysadmin says I have the proper permissions.
As I originally stated, I was able to do a backup… and now I can't.
-
October 22, 2003 at 7:47 pm #15092GluedToTheScreenMember
I'm still having some problems and the sysadmin says I have all the proper permissions. I've also identified a couple more things:
1. Original problem: can't backup remote database… error 1227
2. If I try to use the UPDATE command in the query window, I get Error 1142: update command denied to user.
3. I **CAN** use the SQLyog graphic insert/update window (F11) and change fields one at a time.
4. With the same username and password, I can run UPDATE and BACKUP sql commands through PHPmyAdmin.
Any idea why I can't do Backup or Update?
Thanks…
-
October 22, 2003 at 8:19 pm #15093CalEvansMember
Ask your sysadmin to list your permissions for you. This IS a permissions problem. (BTW, being a SYSADMIN myself, I hate it when users ask questions like this so be polite but persistent.)
As a test (and to kill time waiting for his reply) try this:
On your Windows server, try backing up one of your databases to another one locally on that same server. If it works, try it again.
I know it's a permissions issue but I'm unclear as to which server is giving you the error. It looks like the remote but if the above test fails then the problem could be with your local server. (but I don't think it is)
When you get the answer form your SYSADMIN then post it here.
BTW, I think the UPDATE thing is a separate issue. If you can use the SQLyog dialog to do the update then you can also use the command window. (They are connected as the same user and issuing the same command.) As a test, check the history tab after doing an update via the dialog. It should list the commands issued. copy and paste them into the command windows and press the almighty F5 and see if it works.
HTH,
=C=
-
-
AuthorPosts
- You must be logged in to reply to this topic.