[Bug 690131] Re: mysqlimport fails on table names which are keywords if unescaped
This should be fixed in natty and probably a good candidate for an SRU. chuck ** Changed in: mysql-5.1 (Ubuntu) Status: Incomplete => Fix Released -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in ubuntu. https://bugs.launchpad.net/bugs/690131 Title: mysqlimport fails on table names which are keywords if unescaped -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 690131] Re: mysqlimport fails on table names which are keywords if unescaped
I got the problem when using mysqldump -T --default-character-set=utf8 with some binary(16) fields that had some binary data inside. I can now see that the Range.txt files created by mysqldump just don't have the binary fields! It does work without the default-character-set option, but this seems dangerous if used over different systems. $ sudo mysqldump -T . test --default-character-set=UTF8 Range > Range.sql $ sudo mysqlimport --default-character-set=utf8 test /tmp/Range.txt -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in ubuntu. https://bugs.launchpad.net/bugs/690131 Title: mysqlimport fails on table names which are keywords if unescaped -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 690131] Re: mysqlimport fails on table names which are keywords if unescaped
cputoaster, I was unable to confirm this on maverick or natty: (natty-amd64)r...@clint-macbookpro:~# mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 Server version: 5.1.49-1ubuntu8.1 (Ubuntu) Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create database test; Query OK, 1 row affected (0.00 sec) mysql> use test; Database changed mysql> CREATE TABLE `load` ( `Timestamp` datetime NOT NULL, `Value` double unsigned NOT NULL, `QUALIF` varchar(45) NOT NULL, `DS` varchar(45) NOT NULL, `Platform` varchar(45) NOT NULL, `Object` varchar(45) NOT NULL, `Computer` varchar(45) NOT NULL, PRIMARY KEY (`Timestamp`,`QUALIF`,`DS`,`Object`,`Computer`) ); Query OK, 0 rows affected (0.08 sec) mysql> Bye (natty-amd64)r...@clint-macbookpro:~# mysqlimport --ignore --fields-terminated-by=\; test /tmp/load.txt test.load: Records: 0 Deleted: 0 Skipped: 0 Warnings: 0 Can you explain further why you believe this bug to still be a problem? ** Changed in: mysql-5.1 (Ubuntu) Status: New => Incomplete -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in ubuntu. https://bugs.launchpad.net/bugs/690131 Title: mysqlimport fails on table names which are keywords if unescaped -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 690131] Re: mysqlimport fails on table names which are keywords if unescaped
-- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in ubuntu. https://bugs.launchpad.net/bugs/690131 Title: mysqlimport fails on table names which are keywords if unescaped -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs