How to Restore SQL Backup (5 Steps)

Log in to your web hosting CPanel or equivalent. This will vary depending on your host. A common example is http://www.yoursite.com/cpanel. If you do not have these details, you will need to contact your web hosting provider.
On your hosting CPanel, find the section labeled 'Databases.' Click the icon marked 'phpMyAdmin.'
Select the name of the database you wish to restore from the list of databases on the left side of the phpMyAdmin screen. In this example, the database is named '_test.'
Select the option marked 'Import' that is above the details of your database.
On the import page, press the 'Browse' button, and locate the SQL backup file from which you will be restoring. Compression will be automatically detected. Once the backup file is selected, press 'Go.' The backup may take some time to import successfully.
VPS Hosting

How to Do a Complete Uninstall of Wordpress From Hostgator

Log into your 'cPanel' on your 'Hostgator' account through the website that you are going to uninstall 'Wordpress' from. This can be done by typing in your domain name with a '/cpanel' a the end and substituting your website address for the domain. Type in your login, password and press 'OK.' This will bring you into the 'cPanel' which is used to manage the contents of the website.
Scroll down on the page until you see a symbol labeled 'Fantastico' and click on it with the left mouse button. You will now launch the script manager which is used by 'Hostgator' to install and uninstall various programs and plug-ins such as 'Wordpress.' To the left of the screen, 'Fantastico' will display the list of programs which has been installed on the hosting account. There is a 'remove' link located next to each of the programs.
Click the 'remove' link next to 'Wordpress' in order to completely uninstall it from 'Hostgator.' This process will take a few minutes, wait until it is completed before doing anything else on the computer. Once it is done, exit out of the cPanel and log into your website to check whether the website or blog is still visible. On certain occasions, the uninstaller will miss several files that will need to be uninstalled manually. This can only be done by the staff of 'Hostgator' which can be contacted via phone, email or instant messenger.
VPS Hosting

How to Put GIFs on Your Tumblr Sidebar

Upload your GIF to an image host. You can upload it to a Tumblr post, your own Web hosting server or an image-hosting service such as Imgur, TinyPic or Photobucket (links in Resources).
Copy your GIF's URL to your computer's clipboard. Most image-hosting services offer several URL options when you upload a photo; typically, you should copy the link labeled 'For Email' or 'For Layouts.'
Log in to your Tumblr account, click the gear icon at the top of the page and then click the name of the blog whose layout you want to customize.
Click the 'Customize' button in the middle of the page.
Enter the following code into your Tumblr's 'Description' box:Replace 'yourgifurl' with the URL you copied to your computer's clipboard.
Click the 'Save' button at the top of the left column and then click 'Close' to close the customization settings. Check your blog to ensure that the GIF looks the way you want it to in your Tumblr's sidebar.
VPS Hosting

How to Use Putty and SSH

Start the PuTTY program on your computer and wait for the main dialog box to appear on your screen.
Enter the host name of the server on which you host your website or shell account, placing it in the 'Host Name' box of the PuTTY dialog box on your screen. This information should have been given to you by the system administrator of the server on which your account is hosted. An example would be if your website address is http://www.myawesomesite.com. The actual host name of this address is 'myawesomesite.com' without the rest of the address components. This is what would be entered into the 'Host Name' block of the PuTTY dialog box.
Tell PuTTY what kind of data connection you desire for it to initiate when logging into the server. To do so, look at the section of the dialog box labeled 'Connection Types' and note that a multitude of buttons exist in this section including: telnet, rlogin, SSH, and raw. Click on the SSH button to prepare PuTTY for an SSH login to your server.
Look at the 'Port' block on the PuTTY dialog box and verify that the port number is set to 22. This is the default SSH port that all SSH servers listen on for incoming connections. This port number should never be changed unless the system administrator of your host server has informed you that the server listens on a different port. If a different port is used on your server, enter that port number into this port block now.
Begin the SSH connection process. Locate the button at the bottom of the PuTTY dialog box labeled 'Open' and click on it. Connection progress information will now be displayed in the main text area of PuTTY.
Verify the host SSH key and add it to your PuTTY terminal cache for future log-ins. A caution message will appear in the main terminal screen of Putty if it is the first time you have logged into an SSH session with the server. The message is a cautionary measure telling you the server fingerprint identification number. It will ask you if you want to trust the server and to have its key added to your PuTTY terminal program's cache. If you are uncertain, call your system administrator by phone and ask him to read you the server fingerprint number to verify it. Whether you made a call, or simply choose to accept it, enter 'Yes' at the prompt on the text screen to accept the key and to have it added to PuTTY. The verification step will now be complete.
Wait for the log-in prompt to appear. The first line of SSH servers when logging in will require your hosting account user name. Enter your user name on the first prompt line when asked for it, then press the 'Enter' or 'Return' key on your keyboard to send it. After sending your user name, the prompt will ask for your password. Enter the password for your hosting account and press the 'Enter' or 'Return' key to send it. If you entered both correctly, you will get a command prompt through which you may perform your system commands.
Log out of your SSH session when finished by typing either 'logout' or 'exit' (without the quotes) at the command prompt on the screen, then press 'Enter' or 'Return' on the keyboard to log out completely. Whether 'logout' or 'exit' is used depends on how the hosting server is set up. Try both if you are unsure. If the first one you try doesn't work, then the other will. If neither works for some reason, contact the administrator of your hosting account and ask what the logout command is for that server.
VPS Hosting