Techie Than

These files are logs from MySQL queries. To clear them, do the following Go to your mysql bin folder  (ex C:\wamp\bin\mysql\mysqlx.x..xx\bin) Run  mysql.exe -u root -p enter the password Run this command:  SHOW BINARY LOGS; look for the last entry Run this command:  PURGE BINARY LOGS TO 'mysql-bin.xxxxx'  Where mysql-bin.xxxxx is the filename of the last entry. Done!

I have not backed up my phone in a while so I thought of doing it now. When I connected it to my computer, I found that iTunes doesn't recognize my device anymore. There small iPhone icon doesn't appear anymore and my phone is not prompting me to "trust" the computer. I am sure that there is data connection because I can use Windows Explorer to access the phone's image/photos. I tried connecting the phone to another computer and the "trust" prompt came out so I was sure that it was iTunes or my computer playing up. After some research, here's the solution I found. Open Device Manager Expand Portable Devices and look for Apple iPhone.  Right click to Properties, go to Drivers tab, and click Update Driver... on the prompt, choose Browse my computer for driver software browse to the path "C:\Program Files\Common Files\Apple\Mobile Device Support\Drivers" then click Next Disconnect the iPhone and Connect again.  After that, my phon...

Imagine this. Your database transaction log has grown tremendously. You don't have enough space to do a backup of it and proper truncation. You do, however, have a backup of your database and are sure that you can restore it without any issue. What can you do? Here is a script that I use to force shrink transaction logs. Note that this can potentially be harmful, so make sure that you have a working backup of your database. Having said that, I've done this on a number of log files, some growing up to 200GB big, and I've not had any problems whatsoever. Replace the database_name variable in the first line with the actual name of your database (enclose in single quotes) DECLARE @DBName nvarchar(100) = ' database_name '; -- Declare the variable to be used DECLARE @sql nvarchar(1000), @exec nvarchar(300), @logfile nvarchar(100); -- Initialize Exec StoredProc SET @exec = QUOTENAME(@DBName) + '.sys.sp_executesql' -- Get Logfile name SET @sql = 'Se...

After reinstalling Ms Office 2010 on my computer to upgrade to the 64-bit version, my hotmail account stopped working. Outlook would not connect to my email accounts anymore and I was getting these error messages: Task 'xxxxx@hotmail.com' reported error (0x8004102A) : 'Error with Send/Receive. There was an error synchronizing your folder hierarchy. Error : 80041004.' Task 'xxxxx@hotmail.com' reported error (0x8DE00005) : 'There is an error synchronizing your mail account. Please verify your account is configured correctly by first accessing your mail on the web. Error: 3219. Server. An error occurred in looking up the user's information in mserv. '  After much digging, I finally found that the issue was due to the version of Outlook that I have installed. Apparently, Microsoft have done some changes to Hotmail and Outlook accounts, migrating them to Exchange 365. After the migration, the accounts were no longer compatible with older bui...

In Exchange 2010, giving a user Full Access to another mailbox auto-links that mailbox to the user's outlook profile. It appears as an additional PST in Outlook. Even after removing the Full Access permission, the linked PST remains in Outlook. Here are the steps to remove them. Open Active Directory Users and Computers   On the menu, click View then Advanced Features (make sure it's enabled) Go to the user whose mailbox is being access (ie, the linked mailbox) Open the Properties and go to the Attribute Editor tab Look for the attribute msExchDelegateListLink Delete the user whom you do not want to give Full access to anymore Click OK to Save  Restart the user's Outlook.