Monday, January 28, 2013

How to add ISO Installer in Proxmox

How to add ISO installer in Proxmox

On the last posted, we just learn about how to install proxmox ve in VMWare. And now we will try to add an ISO installer in proxmox, so we can install a virtual machine base on that ISO.
The steps :

1. Login to proxmox
2. Go to menu datacenter menu, and choose local
3. On content menu, click upload
4. Choose ISO Image in the content box and click select file, after that choose your ISO image.

Happy Trying..!!

Virtualization with Proxmox Ve

Proxmox Ve 

Proxmox is powerfull virtualization platform based on KVM dan OpenVZ.

This time i'd like to share about how to install Proxmox Ve on VMWare Player
Proxmox configuration :
    Hardisk : 60GB
    Memori : 2GB
    Processor : AMD Brazos Dual Core E350 1.6Ghz

Here are the steps :
  1. add virtual machine.
  2. After booting process press ENTER


   3. Click agree to continue


    4. Click next



    5. Select time zone and click next


   6. Enter the password for login, and click next


   7. Enter the network and click next



  8. Installation process



   9. Reboot server

   10. After completed the installation, you can log in to administration menu by pointing your browser to 192.168.94.129 ( example ) and please enter your root username and password


   11. Below is the administration menu of Proxmox Ve.



Happy trying..if any question, feel free to contact me... :)
Sunday, January 27, 2013

How to Build VPN server and client in ubuntu

How to Build VPN server and client in ubuntu

This ebook (English Version) is FREE for everyone who want to try to build VPN server and Client base on Ubuntu Server, you can download it here and if you need a virtual machine base on VirtualBox, you can send me an email to alirachman89@gmail.com

Drop MySql Database

DROP DATABASE MYSQL

After we know about how to backup, restore mysql database, now i try to share about how to drop the database. cek it out...

example :
         Database Name      : coba.sql
         username                : tes
         pasword                  : tes123

Sintaks  :
       mysqladmin -u [username] -p [password] drop [database]

So the command is :
      mysqladmin -u tes -p tes123 drop coba

But, don't forget to backup your database first before you do it.

Restore MySql Database

Restore MySql Database
 
I've just posted Backup MySql Database a few days ago, now i want to share about how to Restore MySql Database. Let's rock..
example :   username : tesaja
   password : 12345
   database name : coba
   database file that want to restore : coba.sql
   backup location : /home
sintaks :
mysql -u [username] -p [password] [databasename] < /backup_location/database_file

So..the command is
mysql -u tesaja -p 12345 coba < /home/coba.sql

Backup Mysql Database


This time,i willshare about how to make a mysql database backup via linux console.
Example :
  • database name : coba.sql
  • username : tesaja
  • password : 12345
  • path : /home/
and the sintaks  :
mysqldump -u [username] -p [password] database_name > [path]/file_name.sql

So the command is :
mysqldump -u tesaja -p 12345 coba > /home/coba_backup.sql