How to setup a vps without a control panel for dummies

[ipowerz]

i use mouse right click to paste over putty session

[shufol]

Would you mind telling us how to taking full/sql site backup using ssh ? and also how to restore them again ?

it would be great learning i hope

[snowmanrene]

Hello,

one purchase's a VPS and receives an IP, root and password. So is this a tutorial on how to setup a website on a VPS without a control panel?


I'm a little confused with the title.


Sorry


cowboyup910

Yes this tutorial will install the necessary packages for you to run a website(s) without the use of a control panel such as cPanel or DirectAdmin.

[mRAza]

Would you mind telling us how to taking full/sql site backup using ssh ? and also how to restore them again ?

it would be great learning i hope

to make backup in ssh type this and enter:

mysqldump DATABASE_NAME > BACKUP_FILE_NAME.sql

change " DATABASE_NAME" with database name u wants to backup and "BACKUP_FILE_NAME" whatever u like.

it will save a file named "BACKUP_FILE_NAME.sql" in ur current directory.

to restore backup ( make sure u are in same directory where DATABSE_BACKUP_FILE_NAME.sql exists or give full path) :

mysql -uUSERNAME -pPASSWORD DATABSE_NAME < DATABSE_BACKUP_FILE_NAME.sql;

example:
mysql -uroot -p123456 mydatabase < BACKUP_FILE_NAME.sql;

[glcon]

I have a doubt, where can we control Mysql data, like creating databases, passwords and other stuff.. i mean we should have phpmyadmin or something like that. And does this work as Cpanel?

[mRAza]

I have a doubt, where can we control Mysql data, like creating databases, passwords and other stuff.. i mean we should have phpmyadmin or something like that. And does this work as Cpanel?

the whole point of this tutorial is to mange all via command line, so you can create databases , change passwords, add users etc all via SSH, cPanel is a conrtol panel, which works via browser.

You can also install phpmyadmin if you like to manage databases via browser, just download phpmyadmin and upload to /var/www/html/phpmyadmin then visit in ur browser htt:///YOURIP/phpmyadmin and follow instructions . .
Make sure to secure it.

[glcon]

thanx! Very good and needed tutorial for every webmaster!

[buck_rider]

I have a doubt, where can we control Mysql data, like creating databases, passwords and other stuff.. i mean we should have phpmyadmin or something like that. And does this work as Cpanel?

You can control Mysql via commandline without any problems, you just need to know how and it really isn't that difficult. Google is full of infos about that. This one for example: http://library.linode.com/databases/mysql/centos-5

If you can't live without an interface for Mysql, try adminer, it is only one small php file and will only be used when needed, unlike phpmyadmin, which is always stealing ressources.

[Hot_Shot]

Sorry for asking a silly questions.

once we setup VPS... how do we move our site into the new VPS server.

is it really simple like just using the CuteFTP for Uploading files. and how to use backup MYSQL DB

[raisajid]

yes its that simple, and about RAM i used to host a site using IPB Forum with 10k u/v a day on 256MB Ram.

awesome.... can you tell about that host?