SQLyog creates batch scripts with double-quotes

This topic is empty.

Viewing 3 reply threads

Author

Posts
- November 10, 2004 at 2:42 pm #16529
  
  Ritesh
  Member
  
  Which version of MySQL are you using?
  
  Can you cut-n-paste the result returned by “show create table `db`.`table`”?
- November 11, 2004 at 7:47 am #16530
  
  Shadow
  Member
  
  Apparently MySql interprets “time” as a keyword, thus the CREATE TABLE fails.
- November 12, 2004 at 2:02 pm #16531
  
  patrickq
  Member
  
  Actually, now that I am re-checking it seems that:
  
  1. SQLyog doesn't use double quotes (“), it uses ` (correctly)
  
  2. In my attempts at finding the problem, I mistakenly used ' instead of `
  
  In fact, I got confused and this is actually a MySQL Administrator bug! The bug is valid, MySQL Administrator does use ” and the script doesn't work, but that's not a SQLyog bug, sorry …
  
  I was trying to combine using MySQL Administrator for scheduled backups (until SQLyog implements scheduled backups), while using SQLyog for everything else (such as one-time backups or restores). Looks like for now I will have to edit the MySQLAdministrator scripts, or else use one-time backups done via SQLyog.
- November 12, 2004 at 6:09 pm #16532
  
  peterlaursen
  Participant
  
  Maybe the MySQLadministrator script will work in ANSI-mode ?
  
  With MySQL up to 4.0 the ansi-mode is specified in the server section of the my.ini/my.cnf (and will thus apply to all connections)
  
  With MySQL 4.1 and above each connection could specify individually that ansi-mode should be used for that connection.
Author

Posts