Dump / Inject Mysql

zcat /path/to/file.sql.gz | mysql -u 'root' -p your_database

Webuzo Install

Open a Shell Terminal (e.g. PuTTY) and SSH to your server. Run the following commands:

wget -N http://files.webuzo.com/install.sh
chmod 0755 install.sh
./install.sh     // This will install the LAMP Stack, DNS Server and FTP server along with Webuzo

OR

./install.sh --install=lamp,bind // This will install the LAMP Stack(softname -> lamp) and DNS Server 
                                    (softname -> bind) along with Webuzo.
                                    Note : softname for Apps should be comma separated.
                                    Get list of softnames for the Apps here : http://api.webuzo.com/apps.php

OR

./install.sh --install=none // This will install only Webuzo without any LAMP Stack.
                               You can later install apps from the Apps Category in the Enduser Panel.

src http://www.webuzo.com/wiki/Install
mysql root pasword are saved in /var/webuzo/my.conf 

if WEBUZO STOP AFTER RESTART you can try this step

service webuzo restart

or in centos, execute this command

setenforce 0 >> /dev/null 2>&1
iptables -F >> /dev/null 2>&1
iptables -P INPUT ACCEPT >> /dev/null 2>&1

Tambahan Catatan Untuk mysql

Disable ONLY_FULL_GROUP_BY

Solution 1: Remove ONLY_FULL_GROUP_BY from mysql console

mysql -u pastuoke -p
mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))

you can read more here

Solution 2: Remove ONLY_FULL_GROUP_BY from phpmyadmin

• Open phpmyadmin & select localhost
• Click on menu Variables & scroll down for sql mode
• Click on edit button to change the values & remove ONLY_FULL_GROUP_BY & click on save.

 

PHP

setting phpini

log_errors = On
error_log = /home/pastiok1/error.log