[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...【阅读全文】
[i=s] 本帖最后由 mchdba 于 2011-10-21 10:50 编辑 cdp.listed_cpny_fin_rpt_prd表总记录数:1467246test.qa_cpny表总记录数:103explain SELECT dat.* FROM test.qa_cpny es force index(PRIMARY) inner join cdp.listed_cpny_fin_rpt_prd dat on (es.excel_id = dat.excel_id)&n...【阅读全文】