Bug #6910 MySQL Administrator Backup script error
Submitted: 1 Dec 2004 7:24 Modified: 1 Dec 2004 13:44
Reporter: Juliau Gong Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.0.14 OS:Windows (WinXP Pro SP2)
Assigned to: CPU Architecture:Any

[1 Dec 2004 7:24] Juliau Gong 
Description:
the backup generated "CREATE TABLE" is error, such as:

CREATE TABLE "user" (
  "userid" int(10) unsigned NOT NULL auto_increment,
  "username" varchar(45) NOT NULL default '',
  PRIMARY KEY  ("userid")
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

the correct script is:
CREATE TABLE `user` (
  `userid` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

must use the ` to replace the "

How to repeat:
when backup a database.
[1 Dec 2004 13:44] MySQL Verification Team 
Duplicate for #6532