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

Scheduled Backups Crash

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Scheduled Backups Crash

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • October 20, 2016 at 12:31 pm #13570
      slines
      Participant

      When using scheduled backups, if a table name in the database ends with a number, the backup will crash.

       

      I have a cron job that fires a scheduled backup by calling a .bat file that contains:

       

      “C:Program FilesSQLyogSJA.exe” “D:db_backupsLTIS_OH_AutoBackupltis_oh_backup.xml” -l”C:UsersAdministratorAppDataRoamingSQLyogsja.log” -s”C:UsersAdministratorAppDataRoamingSQLyogsjasession.xml”

       

      This has been working flawlessly for years.

       

      Recently I added a table to this database where the table name was:   sys_control_65

       

      This action caused the scheduled backups job to crash when it got to the point where it was backing up that table.

       

      Renaming the table to sys_control_65a resolved the issue and the backup job completed.

       

       

    • October 28, 2016 at 7:44 am #35801
      Sibin A S
      Moderator

      Hi,

       

      “When using scheduled backups, if a table name in the database ends with a number, the backup will crash.” >> Please elaborate what exactly do you mean by the term crash here. Does the backup run successfully with not backing up only the table that ends with a number or does the backup not take place at all.

       

      Regards,

      Sibin

    • November 3, 2016 at 1:57 pm #35802
      slines
      Participant

      The backup job will stop with no error.  No more tables are backed up.  No emails are sent.

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