Re: Foreign-key reference

2014-01-06 Thread Reindl Harald
Am 06.01.2014 18:21, schrieb h...@tbbs.net: > Are INNODB foreign-key references ignored in 5.6? why should they? http://www.catb.org/~esr/faqs/smart-questions.html#beprecise signature.asc Description: OpenPGP digital signature

Re: Foreign-key reference

2014-01-06 Thread Morgan Tocker
On 1/6/2014, 12:21 PM, h...@tbbs.net wrote: Are INNODB foreign-key references ignored in 5.6? You might be hitting: "Important The inline REFERENCES specifications where the references are defined as part of the column specification are silently ignored. MySQL only accepts REFERENCES clauses

Foreign-key reference

2014-01-06 Thread hsv
Are INNODB foreign-key references ignored in 5.6? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2014-01-06 Thread Reindl Harald
Am 06.01.2014 15:36, schrieb h...@tbbs.net: > Now that I installed 5.6.14 on our Vista machine, when using "mysql" I often > see that error-message, which under 5.5.8 I never saw. What is going on? what about look in the servers logfiles most likely "max_allowed_packet" laughable low signatu

Re: loading 0x00A0 into mysql

2014-01-06 Thread Dave Howorth
Thanks for the reply, and I apologize because I expect I've broken threading. The list isn't mailing the posts to me, so I've nothing to reply to. I've had to cut and paste from the web archive... 2014/01/06 12:18 +, Dave Howorth >> Everything appears to work except that text fields

ERROR 2013 (HY000): Lost connection to MySQL server during query

2014-01-06 Thread hsv
Now that I installed 5.6.14 on our Vista machine, when using "mysql" I often see that error-message, which under 5.5.8 I never saw. What is going on? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: loading 0x00A0 into mysql

2014-01-06 Thread hsv
2014/01/06 12:18 +, Dave Howorth Everything appears to work except that text fields containing a Unicode non-breaking space (0x00A0) are truncated just before that character. I can see the field in the dump file and it looks OK, but it doesn't all make it into the new database. <

loading 0x00A0 into mysql

2014-01-06 Thread Dave Howorth
Hello, I'm trying to make a copy of a mysql database and having an issue loading fields containing a particular character. I've taken a dump using mysqldump and then try to load it into a new database using mysql --user=me test_database < dump_file Everything appears to work except that text f