菜菜De学习

先关闭服务 再重启net start mysql服务名net stop mysql服务名命令net start mysqlnet stop mysql   本机:

windows与linux环境下mysql数据库的备份与还原备份：C:>mysqldump -uroot -ppass -h 192.168.1.62 meeting>D:/db_bak.sqlmysqldump为mysql自带的备份命令-uroot 表明用户名为root-ppass 表明密码为pass-h表明远程的host为192.168.1.62>D:/db_bak.s

Lock wait timeout exceeded; try restarting transaction错误信息：2012-06-20 10:49:10,310 WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 1205, SQLState: 41000 2012-06-20 10:49:10,310 ERR

文章来源于：http://hi.baidu.com/panhuilin/blog/item/68439c4bacc9e3f382025cba.html 一、创建用户并分配权限:SQL语句:-------------------------------------------------------------------------GRANT privileges [(co

为一个用户赋权收回权限 #给用户cacti赋予所有库的所有权限GRANT ALL PRIVILEGES ON *.* TO 'cacti'@'%' IDENTIFIED BY 'cacti' WITH GRANT OPTION;#重新载入赋权表FLUSH PRIVILEGES;#收回权限(不包含赋权权限)REVOKE ALL PRIVILEGES ON *.* FROM c

1.      编写脚本backup_date=`date '+%F-%H-%M-%S'`echo $backup_date/opt/xampp/bin/mysqldump -umeeting meeting_guizhou > /db_bak/guizhou_meeting_$backup_date.sql 2.      另存为.sh文件注意点:因为在WI

问题的原因很简单,可能有的时候一下想不起来。MARK下。报错信息如下: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.wondertek.meeting.model.spokesman.Spokesman]; uncatego

步骤： 1.下载dll文件     2.程序中直接连接