c 에 용량이 얼마 없으니 아래와 같이 링크를 만든다
use bacula 해서 그냥 쓰면 된다.
restore 할 때
source 명령어를 쓰는데 이건 workbench 에서는 동작하지 않는지 다른 모드가 있는 모양이다.
mysql -u root -p 로 들어가서
mysql> source D:\어쩌고\저쩌고\mysqldump.dump
예전같이 그냥 mysql -u root -p < mysqldump.dump 이렇게 하려면 첫 줄에 use 대상데이터베이스 이렇게 넣어주어야 하는데 위와 같은 방법으로 하면 큰 파일 고치지 않고 가능하네~
Change password for user nixcraft, enter:
mysql> update user set password=PASSWORD("NEWPASSWORD") where User='nixcraft';
Finally, reload the privileges:
mysql> flush privileges; mysql> quit
select *, CAST(logtext AS CHAR(10000) CHARACTER SET utf8) from log order by logid desc limit 1000
Welcome back and I hope you had a great summer holiday!
Today I would like to share with you some improvements we have made to SQLTest and sp_whopro; many of them were the result of user feedback:
sp_whopro SQL Server Activity Monitoring and Logging Stored Procedure
The "Advanced SQL Server 2014, 2012 and 2008 Performance Monitoring & Tuning Hands-on Workshop"uses SQLTest tool to simulate real-world performance issues on every participant's computer and these problems are resolved together with the students using various techniques. This makes sure the participants receive first-hand practical performance tuning skills, with real-world problem solving and not just the common "best practice guidelines" discussion. Agenda Feedback
If there are three or more DBAs / developers / architects in your company who would like to attend, it might be more convenient to organize the training at your company's premises.
Let us know if you have any SQL Server performance tuning questions!
Carmen and Ramesh