Pages

Tuesday, September 11, 2012

How To Save Gmail Attachments Directly to Google Drive Source

Google is adapting quite well with latest technologies and Google Drive is another product in their already well equipped arsenal of Products.If you aren’t aware about Google Drive, its a cloud computing service launched by Google few days back to compete with Dropbox and SkyDrive.I already wrote a detailed review of Google drive and if you are not sure whether which service you should opt for then you must read detailed comparison of Dropbox, SkyDrive and Google Drive.

Since it is a product from Google we can expect it to be integrated with other services from the search engine giant.As of now you can directly open and save Google Docs files in you Google Drive account but what about email attachments? They shouldn’t be ignored Right? There is no official update regarding the time-frame in which Gmail and Google Drive will be integrated but a chrome developer has made an extension that will fulfill this purpose.

Gmail Attachments To Drive is a Google chrome extension developed by Josh Sullivan and is available for download in Chrome app store.
Here are Steps Save Gmail Attachments Directly ti Google Drive

Download and install Gmail Attachments To Drive addon for chrome.
Now open Login into your Gmail account and open any mail with document (pdf,docx etc) attachment.Now you will notice Save to Drive just below your attachment.Click on it and your file will automatically get stored in Google Drive.
However the extension only supports documents like pdf, docx, rtf etc and it cannot save videos and compressed files like .rar or .zip files directly to Google drive.For these type of documents you have to perform the task manually.

Monday, September 10, 2012

How To Change WordPress Admin Password From SQL Database Source

Rarely you will face such a situation when you will need to change your wordpress password from SQL database because if you ever forget your password you can use the Forgot Password feature using which your new password will be emailed into your inbox. However if your website gets hacked or due to any reason you lose access to both your email and wordpress than such a sitution can be handled by changing the password from SQL.

If you are a non-programmer even then you can’t go wrong with this process as it is too simple but make sure that you don’t change anything other than mentioned in the steps below.

Open Hosting Account.
Select PhpMyAdmin from your hosting. In Screenshot Below I have Shown PhpMyAdmin in Cpanel Hosting

How to reset WordPress Admin Password from SQL

Now Select your WordPress database from the dropdown menu in Left Sidebar. After you select the appropriate database the page will automatically reload and your tables will be visible.
Now look at the top navigation bar and click on the SQL tab.
In the Text area type the following code

UPDATE `wp_users` SET `user_pass` = MD5( "new_password_here" ) WHERE `wp_users`.`user_login` = "admin_username";

Here you will replace new_password_here with your new password you want to set and admin_username with new administrator username.

Code for How to reset WordPress Admin Password from SQL

Now click on the Go Button and your Username and password will get changed.

Login into your wordpress account with new username and password.This method works on self hosted wordpress.


How to create A Quick LAN Connection Between Two Computers In Windows

First go and buy the straight patch Ethernet LAN cable(make sure that ‘patch’ or ‘crossover’ is written on the cord) and connect them to both computers.

In Windows XP: Go to Network Connections Control Panel, right-click Local Area Network connection and select Properties. Now select Internet Protocol(TCP/IP) and click Properties.

In Windows Vista: Go to Network and Sharing Center, select Manage Network Connections, right-click Local Area Network connection and select Properties. Now select Internet Protocol Version 4(TCP/IPv4) and click Properties.

Now once you are inside the TCP/IP properties of your computer, click Use the following IP and enter 192.168.0.1 as IP address and 255.255.255.0 as subnet mask. Leave the other details blank and click OK.

Internet Protocol IP Properties

Now go to TCP/IP properties of the second computer and enter the same details except the IP address, which should be 192.168.0.2 and click OK.

Internet Protocol IP Properties 2

Now the networks are ready, you might need to restart both computers in some cases. If you are looking to share the Internet Connection between two computers, go to Local Area Network properties again and click on Sharing tab. Here you can select the enable internet connection sharing.

local area connection internet sharing

To share files and folders between the two computers, go to the properties of that file/folder and select Sharing tab. Click Share to being sharing it on the network.

sharing properties

Let me know if this works for you. Enjoy!

Recovery of External HDD after worm attack

Recovery of External HDD after worm attack
I have a Seagate 500 GB External Hard disk which I share between office & home. Recently, I noticed for the HDD, there are shortcut links for all the folders . I could open the folders in a new explorer window. Next day, my office computer antivirus detected attack in the HDD with Worm:Win32/Dorkbot!lnk. It deleted all the shortcuts. Now I can not find/open the folders though the files are there. I can understand the files are there during virus scanning or though disk usage.
Please help how to recover the data?

see if they are made hidden ?
Use Recuva and recover lost files.
Recovery of External HDD after worm attack.

Sunday, September 9, 2012

How to install Google Maps on Nokia phone

Has Nokia barred Google maps on Nokia phone ? My phone Nokia 5800 Xpress Music. When I take send to the no. it says Invalid phone no. Please help. Google maps is not available on Ovi store too.

Its available on our S60 phones :D but not on Nokia Store.

Use your phone's Wi-Fi or 3G/EDGE connection to go to m.google.com and choose Maps from there. Then you can download maps from there on the phone itself.