How to import and export a database in phpmyadmin

1.Log into the cpanel 2.click on phpmyadmin windows opens 3.By clicking on the export tab,you can export all the database tables available in different formats like SV, SQL, PDF, Microsoft Excel, Microsoft Word, XML.You can export all the tables at a time or you can export one by one 4.To import your database click on […]

How to install PhpMyAdmin in VPS

1.Download the phpmyadmin software wget http://sourceforge.net/projects/phpmyadmin/files%2FphpMyAdmin%2F3.3.1%2FphpMyAdmin-3.3.1-all-languages.7z/download#!md5!8deab1b30f415dd2f33c46e8f28501ef 2.Extract the package 3.Then upload the extracted files and folders through filezilla 4.Place the software at the place where you would like to access the software 5.If you want to open phpmyadmin as http://domainname/phpmyadmin means,place the contents under public_html/phpmyadmin 6.NOw create the database ,database user and add that user […]

How to upgrade/downgrade a package in Whm panel

Steps to upgrade/downgrade a package in Whm panel: 1.  Login to whm panel 2.  Click LIST ACCOUNTS 3.  Select the domain name in which you need to upgrade/downgrade the package and click the package name 4.  Choose the package and click UPGRADE/DOWNGRADE By this way you can change the plan for the domain name in […]

REMOTE MY SQL CONNECTION

STEPS TO BE FOLLOWED TO CONNECT MY SQL REMOTELY: 1.  First step visit http://whatismyip.com in your browser and you will get an ip address 2.  Login to cpanel using http://domainname/cpanel 3.   Here click Remote my sql and add the ip which you received from your whatismyip.com and click ADD HOSTS Then try to connect my […]

How to backup/restore your files

In order to backup your files,  download all the files from your public_html folder to your computer by using Filezilla After that you can easily upload back the files to your hosting account and your website will be restored.