Windows 10 Clipboard 功能

Oreilly 程式設計師提升生產力秘笈一書有有提到CLICLI 剪貼簿可以看到歷史紀錄。Windows 10 也支援這個功能了.

 

可以按快捷鍵 Windows+V 開啟剪貼簿

MySQL relay-bin log error

MySQL Replication Server , 因空間滿了, 導致MySQL 無法登入.

這應該持續一段時間了, 檢查之後發現是 relay-bin log 滿了。

應該是年中時, 有大量的刪除及UPDATE 資料關係。

所以Replication 要重建。因為空間滿了無法啟動MYSQL, 所以只能刪掉一些檔案, 重啟slave 時發現下列錯誤.

ERROR 29 (HY000): File './#####-relay-bin.001416' not found (Errcode: 2 - No such file or directory)

 

處理方法

1. stop slave

2. reset slave

3. rm *.relay-bin*

4. restart mysql

5. CHANGE MASTER TO MASTER_HOST….略

6. start slave

 

完成收工.

Export SQL Server Agent Jobs

You can do all your Agent jobs in one go fairly easy:

1. Click on the "Jobs" section in the SQL Agent in SSMS

2. Hit the F7 key on your keyboard (opens the Object Explorer Details)

3. Highlight the jobs you want to export in the Object Explorer Details

4. Right-click the highlighted jobs and "Script Job As..." like you would for a single job