发布时间：2014-06-07 14:06:44

1. 应用程序报错485333 2011-09-19 04:05:41,597 ERROR [main]  com.csf.cdp.dealComparison.dao.DBDao     - SaveTraceData Error:Incorrect string value: '\xAD\xBF The...' for column 'data_trace' at row 1485333 2011-09-19 04:05:41,597 ERROR [main]  com.csf.cdp.dealComparison.d.........【阅读全文】

发布时间：2014-06-07 14:06:44

[root@ba ~]# mysqldump --default-character-set=utf8 --databases susite ucme >/home/2db-uch-ss-20120312.sqlmysqldump: Got error: 1449: The user specified as a definer ([url=mailto:]'mbuch'@'10.6.21.%'[/url]) does not exist when using LOCK TABLES【】建用户mysql> grant select,insert,update,delete on mc.........【阅读全文】

发布时间：2014-06-07 14:06:44

innobackupex做备份，在快要结束备份的时候，mysql的error日志报错如下，各位有碰到的吗？120428  0:20:29 [Note] Error reading relay log event: slave SQL thread was killed120428  0:20:40 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000479' at position 594.........【阅读全文】

发布时间：2014-06-07 14:06:44

mysql版本： Percona 5.1.56，linux系统： CentOS release 5.5 (Final)，内存： 16G，CPU：8个mysql运行好好都半年多了，突然今天服务down了，然后重新启动报错如下：/etc/rc.d/init.d/mysqld start120623 13:03:09 mysqld_safe Starting mysqld daemon with databases from /data/xxdata/open120623 13:03:09 [Note] Flash.........【阅读全文】

发布时间：2014-06-07 14:06:44

mysql> CREATE TABLE channel_inventory_copy_tmp LIKE channel_inventory_copy;ERROR 1004 (HY000): Can not create file './bgkctmpdb/channel_inventory_copy_tmp.frm' (errno: 9)mysql> 【】临时解决方案：SHOW CREATE TABLE channel_xxxx_tmp;CREATE TABLE `channel_xxxx_tmp` (  xxxxxxx) ENGINE=INNODB DE.........【阅读全文】