Re: Foreign key and uppercase / lowercase values
http://bugs.mysql.com/bug.php?id=65648 On Fri, Jun 15, 2012 at 7:00 PM, Rick James rja...@yahoo-inc.com wrote: You are very close to a standalone test case. Please create such. Then post it on bugs.mysql.com . -Original Message- From: GF [mailto:gan...@gmail.com] Sent: Friday, June 15, 2012 12:45 AM To: Rick James Cc: Shawn Green; mysql@lists.mysql.com Subject: Re: Foreign key and uppercase / lowercase values I think the following might give complete information (I removed some columns not involved in the problem) Server version: 5.1.49-3 (Debian) SET collation_connection = utf8_unicode_ci; Query OK, 0 rows affected (0.00 sec) show variables like '%colla%'; +--+-+ | Variable_name | Value | +--+-+ | collation_connection | utf8_unicode_ci | | collation_database | utf8_unicode_ci | | collation_server | utf8_unicode_ci | +--+-+ 3 rows in set (0.00 sec) show variables like '%char%'; +--++ | Variable_name | Value | +--++ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--++ 8 rows in set (0.00 sec) select USER_ID from TBL_USER where USER_ID = 'GIUSEPPE'; +--+ | USER_ID | +--+ | GIUSEPPE | +--+ 1 row in set (0.00 sec) select USER_ID from TBL_USER where USER_ID = 'giuseppe'; +--+ | USER_ID | +--+ | GIUSEPPE | +--+ 1 row in set (0.00 sec) update TBL_USER set USER_ID = LOWER(USER_ID) where USER_ID = 'GIUSEPPE'; ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`myschema`.`TBL_COMMENT`, CONSTRAINT `FK4F6E52581590B46E` FOREIGN KEY (`USER_ID`) REFERENCES `TBL_USER` (`USER_ID`)) | TBL_USER | CREATE TABLE `TBL_USER` ( `USER_ID` varchar(50) COLLATE utf8_unicode_ci NOT NULL, cut PRIMARY KEY (`USER_ID`), cut ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci | | TBL_COMMENT | CREATE TABLE `TBL_COMMENT` ( cut `ID` bigint(20) NOT NULL AUTO_INCREMENT, cut `USER_ID` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, cut PRIMARY KEY (`ID`), cut KEY `FK4F6E52581590B46E` (`USER_ID`), cut CONSTRAINT `FK4F6E52581590B46E` FOREIGN KEY (`USER_ID`) REFERENCES `TBL_USER` (`USER_ID`), cut ) ENGINE=InnoDB AUTO_INCREMENT=7876 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Restoring database files
I have a mysql database , which tables are archived and i remove some files (montly data, .frm .MYD, .MYI) from the servers disk to an external storage. And i also drop or flush these tables from phpmyadmin. If i need to look and query these offline mysql files what i need to do after copying the files back to the mysql path of the server? Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Restoring database files
Am 18.06.2012 13:25, schrieb a bv: I have a mysql database , which tables are archived and i remove some files (montly data, .frm .MYD, .MYI) from the servers disk to an external storage. And i also drop or flush these tables from phpmyadmin. If i need to look and query these offline mysql files what i need to do after copying the files back to the mysql path of the server? which query? * stop mysqld * copy back the files * start mysqld MyISAM tables and databases are simply plain files and folders including the database mysql which can be copied since mysql# exists without needing any magical command signature.asc Description: OpenPGP digital signature
License question on libmysql.dll and C/C++ API Version 4.0 question about Victoria Reznichenko response
Hello, Y read this message: http://lists.mysql.com/mysql/109590 and I would like to ask for authorization but I don´t see the email address in that thread (it says: sales@stripped). Can someone tell me that email address?. Thanks in advance. Claudia.
Re: License question on libmysql.dll and C/C++ API Version 4.0 question about Victoria Reznichenko response
Hello Claudia, On 6/18/2012 2:13 PM, Claudia Murialdo wrote: Hello, Y read this message: http://lists.mysql.com/mysql/109590 and I would like to ask for authorization but I don´t see the email address in that thread (it says: sales@stripped). Can someone tell me that email address?. Thanks in advance. Claudia. That link is 10 years old and that address is no longer valid. MySQL has been bought twice since then once directly by Sun Microsystems then again when Oracle purchased Sun. Your current questions need to be asked to Oracle. These numbers will route you to the appropriate resources http://www.oracle.com/us/support/contact-068555.html -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql