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

Forums | Webyog

Tools to manage and monitor MySQL databases

Scheduled backup file syntax glitch

This topic is empty.

Viewing 6 reply threads

Author

Posts
- August 1, 2005 at 1:36 pm #9138
  
  royvarley
  Member
  
  When backing up a largish database (tables with 1000's of records) using the “Scheduled Backup” tool, the resultant .sql file has a corrupt entry after several hundred records. For example:
  
  insert into `classes` (`ClassID`,`ClassDescription`,`ClassCode`,`StudioID`,`GenreID`,`Year`) values (206,'Pre-Elementary A / Pre-Elementary: Saturday, 9.00pm – 10.30am','019',3,1,2003);;
  
  insert into `classes` (`ClassID`,`ClassDescription`,`ClassCode`,`StudioID`,`GenreID`,`Year`) values (
  
  The double semi-colon occurs right before a truncated insert command. The next command is a valid insert. This happens at several places through the file – always with the double semi-colon (;;). The truncated insert is extra to the required inserts, that is, the preceeding and subsequent inserts are correct and should follow each other.
- August 1, 2005 at 3:23 pm #18779
  
  Ritesh
  Member
  
  Which version of SJA are you using?
- August 1, 2005 at 4:22 pm #18780
  
  peterlaursen
  Participant
  
  forget it …:-)
- August 1, 2005 at 10:38 pm #18781
  
  royvarley
  Member
  
  SJA 4.1
  
  SQLyog 4.07 download
  
  What should we forget? 🙄
- August 2, 2005 at 2:13 am #18782
  
  Ritesh
  Member
  
  This is very strange as we had fixed a similar bug in v4.06.
  
  Is it possible to send me a dump of the database?
- August 2, 2005 at 7:49 am #18783
  
  Ritesh
  Member
  
  Check BETA 7 at: http://www.webyog.com/forums/index.php?sho…view=getnewpost
- August 2, 2005 at 8:39 am #18784
  
  royvarley
  Member
  
  That fixed it! Thanks!
Author

Posts

Viewing 6 reply threads

You must be logged in to reply to this topic.