- 博客(5)
- 资源 (3)
- 收藏
- 关注
原创 mysql 安装MySQL5.5.10成功!
当需要安装MySQL5.5.10时,请参阅本文档。 1. 安装环境1.1. 目的安装Mysql5.5.10服务,提供公司XXXX测试环境。正式环境也采用该版本的mysql 1.2.硬件环境PC机:Intel E5300 内存4G 硬盘500G 1.3.软件环境Mysql5.5.10cmake2.8.3 2. 安装2.1.安装cmakeshell>tar zxvf cmake-2.8.3.tar.gzshell>cd cmake-2.8.3shell>./configureshell>ma
2011-03-31 13:44:00 7287 1
原创 MySQL 数据库导出导入命令!
<br />所有库导出语句<br />[root@ldap-mysql-svn-trac tmp]# mysqldump -uroot -pmysql --all-databases > /tmp/all_db1.sql<br /> <br />单库导入语句<br />[root@mysql ~]# mysql -uroot -pmysql -oDBTEST < /tmp/all_db.sql<br /> <br />
2011-03-10 17:32:00 803
原创 MySQL Workbench 导出 csv乱码
<br />-- ===============================================================<br />-- MySQL Workbench 导出 csv乱码<br />-- ===============================================================<br />先点击保存按钮,下载lost_cmp.csv,这个时候文件时utf-8编码的,用excel打开,乱码。<br />先吧lost_cmp以文本方式打
2011-03-07 10:29:00 8302 1
原创 Error Code: 1418的解决方案
<br />Error Code: 1418<br />This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)<br /><br /> <br />1,set global
2011-03-02 15:51:00 3432
原创 Error Code: 1418的解决方案
<br />Error Code: 1418<br />This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)<br /><br /> <br />1,set global
2011-03-02 15:50:00 629
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人