MySQL
狂飙的_蜗牛
蜗牛,为梦想而生。
展开
-
MySQL自动备份
#!/bin/sh# mysql_backup.sh: backup mysql databases and keep newest 5 days backup. db_user="root" db_passwd="imsuser" db_host="localhost" db_name="ims"转载 2016-07-26 09:21:15 · 183 阅读 · 0 评论 -
MySQL自动备份
二:赋予脚步可执行权限chmod +x mysql_backup.sh三:添加定时执行计划vi /etc/crontab添加:00 5 * * * root /backup/mysql_backup.sh 每日5点钟备份一次数据库四:补充linux 开机自动启动 cd /usr/bin ln -s -f /usr/local/jdk1.7.0转载 2016-07-26 09:21:58 · 163 阅读 · 0 评论 -
MySQL自动备份
#!/bin/bash#PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:~/bin#export PATH#export LANG=en_US.UTF-8password="/;p0.lo9"savedir=/usr/backupcd "$savedir"time="$(date +"%转载 2016-07-26 09:22:38 · 160 阅读 · 0 评论 -
MySQL开启远程登录访问
GRANT ALL ON *.* TO test@'192.168.10.169' IDENTIFIED BY ’test123' WITH GRANT OPTIONIP为:192.168.10.169用户名:test密码:test123原创 2016-07-26 09:24:38 · 211 阅读 · 0 评论 -
Mysql启动失败
启动 mysql 服务的时候报如下错误:Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist解决方法:mysql_install_db --user=mysql 初始化数据库即可转载 2016-08-04 10:03:55 · 259 阅读 · 0 评论 -
MySQL备忘录
一、插入数据乱码:Incorrectstring value: '\xE6\x9B\xB9\xE5\x86\xAC...' for column 'realname' at r1、alterdatabase team_club character set utf8;2、altertable activity convert to character set utf83、al转载 2016-08-15 10:53:55 · 211 阅读 · 0 评论