Unable to connect to foreign data source

2014-03-31 Thread asd asdf
I had a problem why trying Federated Engine. Creating tables generate no problems but trying inserting raise an error as Error 1429 (HY000): Unable to connect to a foreign data source: Can't connect to MySQL server on '192.168.0.11' (111). My OS is newly install with no firewall restriction on

MySQL Workbench 6.1.4 GA has been released

2014-03-31 Thread karen langford
Dear MySQL users, The MySQL developer tools team announces 6.1.4 as our GA release for MySQL Workbench 6.1. MySQL Workbench 6.1 is an upcoming major update for the official MySQL graphical development tool. Introducing over 30 new features, this version has many significant enhancements

MySQL Connector/Python 1.2.1 RC has been released

2014-03-31 Thread karen langford
Dear MySQL users, MySQL Connector/Python v1.2.1 is the new version of the 1.2 release series of the pure Python database driver for MySQL. It is intended to introduce users to the new features. MySQL Connector/Python version 1.2.1 is compatible with MySQL Server versions 5.5 and greater, but

MySQL Connector/J 5.1.30 has been released

2014-03-31 Thread karen langford
Hello all, MySQL Connector/J 5.1.30, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.30 is suitable for use with many MySQL server versions, including 4.1, 5.0, 5.1, 5.4, 5.5 and 5.6. MySQL Connector

MySQL Utilities 1.4.2 (including MySQL Fabric) RC has been released

2014-03-31 Thread karen langford
Dear MySQL users, MySQL Utilities version 1.4.2 is compatible with MySQL Server versions 5.1 and greater, but should work with earlier versions (greater than v4.1). Python v2.6 and v2.7 are supported. In addition to server utilities, MySQL Utilities also contains MySQL Fabric: a framework for

Re: Help with cleaning up data

2014-03-31 Thread Bob Eby
delete b from icd9x10 a join icd9x10 b on a.icd9 = b.icd9 and a.id b.id ... CREATE TABLE `ICD9X10` ( ... id icd9 icd10 25 29182 F10182 26 29182 F10282 ... Good luck, Bob

RE: Unable to connect to foreign data source

2014-03-31 Thread Bob Eby
CONNECTION = 'mysql://root:root@*stripped*:3306/Prelude_copy/test001'; Should be more like: CONNECTION = 'mysql://root:stripped_password@localhost/penrepository/test001'; Just seems word if you're showing us your password is root but not host... I ran your example just fine against localhost

MySQL Community Server 5.7.4-m14 has been released (part 1)

2014-03-31 Thread Bjorn Munch
Dear MySQL users, MySQL Server 5.7.4 (Milestone Release) is a new version of the world's most popular open source database. This is the fourth public milestone release of MySQL 5.7. [Due to length restrictions, this announcement is split into two parts. This is part 1.]

MySQL Community Server 5.7.4-m14 has been released (part 2)

2014-03-31 Thread Bjorn Munch
[ This is part 2 of the announcement ] Bugs Fixed, continued * InnoDB: A type name (srv_shutdown_state) was the same as a variable name. The srv_shutdown_state type name has been changed to srv_shutdown_t. (Bug #16735398) * InnoDB: On Windows, the full-text search