Archive

Archive for April, 2012

Now Install WordPress Blog On Self Hosted Domain

April 30th, 2012 Comments off

Installing wordpress is not a rocket science now a days, any new webmaster can also do it without much difficulties. It is recommended to install wordpress from your cPanel as this would make it easy to create your database also. Though many of the web hosting services providers provide you some automated scripts for wordpress installation but installing it manually may help you to retain total control, installing wordpress on your localhost does not differ than general installation.

Following are the simple steps for installing wordpress on a self hosted domain.

Create A Database

You should create your database in the initial stage of wordpress installation, you can do this by entering in to your cPanel, there you can find Databases >> MySql databases >> Create a New Database. Once the database is created you can create multiple users and assign the required privileges to these database users as per your requirement.

Download and Upload WordPress

In this second step you need to download the wordpress zip file which is widely available in the internet but downloading it from the official website (wordpress.org) is always recommended. Once you have downloaded the file you can upload it directly on the server and extract it. This action will create a folder with name ‘Wordpress’ which will be the root folder and you need to move all the files to this folder.

Press ‘Refresh’ button and follow the given steps.

This is end part of your wordpress installation, you will be guided through the steps by which you need to fist add the database name, username and password, then you will have to add the username and password of email, after finishing all the processes successfully you can login and start posting.

So apart from creating database there is nothing different in installing wordpress on a local host than installing it on your cPanel hosting account.

Frequently Used Mysql Commands for Plesk Control Panel

April 30th, 2012 Comments off

Though there are more number of users of cPanel due to higher number of webmasters demanding for cPanel shared hosting but still, Plesk is one of the best things for managing your windows web hosting accounts. In case you don’t have a password and want to backup or restore the database then you can go for the following commands

mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` dbname > backupfile.sql

This command is used for taking MySQLdump backup of the database as a ‘admin’ user

mysql -uadmin -p`cat /etc/psa/.psa.shadow` dbname < backupfile.sql

This command is used for restoring MySQLdump backup to an empty database as a ‘admin’ user

cat /etc/psa/.psa.shadow

But still having the password with you is important so after running this command one can get the password for admin user in return. But one needs to run it in specific manner as given below.

mysqldump -uusername -ppassword dbname > backupfile.sql

mysql -uusername -ppassword  dbname < backupfile.sql

When you are aware of password you can run the above commands for backup and restoration of you database.

(Note:- replace ‘username’ with your username, ‘password’ with your password and ‘dbname’ with your database name)

mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow` -r databasename

By running the above command you can perform MySQL check for any possible repairs.

mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow` -o databasename

The above command is for performing MySQL check for any possible optimization over it.