Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Error No. 1227?

forums › forums › SQLyog › Using SQLyog › Error No. 1227?

  • This topic is empty.
Viewing 7 reply threads
  • Author
    Posts
    • May 24, 2004 at 12:34 pm #8449
      Linda
      Member

      Hi,

      When I attempt to backup my whole database, I get the following error:

      Error No. 1227

      Access denied. You need FILE privilege for this operation.

      Is this an issue with how my server is configurated, or am I doing something wrong? Or is it that I am trying to save the backup to a separate computer than the one the database is on?

      I noticed that there's an option for exporting the database as a script as well — which method is preferable for doing backups? I haven't tried the script option yet to see if it works, as I wasn't certain which options to check. I am pretty mySQL clueless, and I didn't want to risk messing anything up.

    • May 24, 2004 at 12:37 pm #15880
      Ritesh
      Member

      Are your source and target MySQL server located on different machines?

    • May 24, 2004 at 12:44 pm #15881
      Linda
      Member

      Yes. Is it only possible to use this option to backup from one database to another?

      What do I use if I want to do an offsite backup on a machine that doesn't have mySQL? The export as a script option? If so, can I find an explanation of the different options in the export as script dialogue?

    • May 24, 2004 at 6:43 pm #15882
      Ritesh
      Member

      SQLyog uses MySQL's standard BACKUP TABLE… option to take backups. This option does not work if SQLyog and the MySQL server are running on different machines.

      If you want to take backup of a remote database, you have to use DB -> Export Database As Batch Script. SQLyog comes with context sensitive help for all its dialogs. Just press F1 and you will be shown help for the dialog i.e. Export Database As Batch Script.

      HTH

    • May 24, 2004 at 7:42 pm #15883
      Shadow
      Member

      mysqlhotcopy script can also be used for backups. It works from a remote machine as well.

    • May 24, 2004 at 10:39 pm #15884
      Linda
      Member

      I have looked at the help dialogue for Export Database As Batch Script, and what I am uncertain about even after reading that information is which options I should check, since I don't understand what each of those options will do. Even with the description of each option in the helpfile, I am not sure which I should or shouldn't check. Or can I just leave it at the default settings?

    • May 25, 2004 at 3:05 am #15885
      Ritesh
      Member

      Yes. You can export data with the default settings.

    • May 27, 2004 at 8:26 pm #15886
      Shadow
      Member

      Linda, I would suggest trying out the options yourself. As you are exporting data, no harm can be done to your db!

  • Author
    Posts
Viewing 7 reply threads
  • You must be logged in to reply to this topic.