Bug #17434 | restore fail when backup sql contain \' | ||
---|---|---|---|
Submitted: | 15 Feb 2006 20:36 | Modified: | 19 Apr 2006 11:28 |
Reporter: | Pornchai Rungsirijaratthong | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Administrator | Severity: | S1 (Critical) |
Version: | 1.1.8, 1.1.4 | OS: | Windows (Windows XP, 2000) |
Assigned to: | CPU Architecture: | Any |
[15 Feb 2006 20:36]
Pornchai Rungsirijaratthong
[16 Feb 2006 9:35]
Valeriy Kravchuk
Thank you for a problem report. What do you mean by "restore failure". I see no error messages during restore of simple backup of your table, with only one row of data containing \', on XP.
[16 Feb 2006 13:52]
Christoph Kopetzky
Try version 1.1.7
[17 Feb 2006 15:47]
Pornchai Rungsirijaratthong
Show status success
Attachment: error in MySQL admin.jpg (image/jpeg, text), 114.03 KiB.
[17 Feb 2006 15:48]
Pornchai Rungsirijaratthong
No row in table!
Attachment: error in MySQL admin 1.jpg (image/jpeg, text), 66.16 KiB.
[17 Feb 2006 15:48]
Pornchai Rungsirijaratthong
sql to reproduce bug
Attachment: backup.sql (application/octet-stream, text), 2.42 KiB.
[17 Feb 2006 15:52]
Pornchai Rungsirijaratthong
Yes. Admin say it is successful. But no record in table. Hint is Use 2 insert sql statement with the first one contain ' in data. Do you try my SQLs yet? If not, I've attached it for you. Regards, Pornchai
[20 Feb 2006 13:54]
Valeriy Kravchuk
Yes, MySQL Administrator 1.1.8 is not able to restore the following simple backup script created by the same version: -- MySQL Administrator dump 1.4 -- -- ------------------------------------------------------ -- Server version 5.0.15-nt /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -- -- Create schema test6 -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ test6; USE test6; -- -- Table structure for table `test6`.`pmtask` -- DROP TABLE IF EXISTS `pmtask`; CREATE TABLE `pmtask` ( `ID` bigint(20) NOT NULL, `tasksCode` varchar(255) default NULL, `description` varchar(255) default NULL, `note` varchar(255) default NULL, `spec` varchar(255) default NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `test6`.`pmtask` -- /*!40000 ALTER TABLE `pmtask` DISABLE KEYS */; INSERT INTO `pmtask` (`ID`,`tasksCode`,`description`,`note`,`spec`) VALUES (6914049,'VT-9300','Check all screw at conveyor and tighten if it\'s necessary','','-'); /*!40000 ALTER TABLE `pmtask` ENABLE KEYS */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
[19 Apr 2006 11:28]
Valeriy Kravchuk
I was not able to repeat anymore (with the same small dump from my last comment) with MySQL Administrator 1.1.9 on XP and MySQL server 5.0.21-BK running on Linux. Please, try to use the latest versions. Reopen this report in case of any similar problem with 5.0.20 and 1.1.9 or newer versions.