Restore Database Mysql from /var/lib/mysql Folder

To restore database mysql (specially INNODB database) from folder is quietly easy. Follow this steps from SSH with root privilege: Setup mysql with small vserver from Digital Ocean (or vultr, linode, etc) with Ubuntu 16.04: apt-get update apt-get upgrade apt-get install mysql-server Create database with the same name, same…

Install Nextcloud on Plesk Onyx

Nextcloud is like dropbox, open source, and competitor of owncloud. Based on fact, Nextcloud founded by co-founder Owncloud. Installing Nextcloud in Plesk Onyx is very easy, just like we install Wordpress or others. Create domain or subdomain in Plesk. For easy installation choose Apache instead of Nginx. From PHP Manager…

Easy to Install Ghost or Nodejs in Plesk

(Update: JXcore extension in Plesk has been deprecated and no longer available. Plesk provides new extension for Nodejs and Docker. I wrote update: "How to Install Ghost with Node.js Extension in Plesk Onyx"). Installing Ghost in Plesk 12 panel is easy, just install JXcore Plesk for Node…

Export and Import Mysql Database without PhpMyAdmin

Export and import Mysql database with large datas needs alots of time with phpmyadmin. Sometimes failed to import because some errors. Fortunately, there is a simple way to do that, directly from command line with mysqldump. Export Mysql Database Example: I want to export my database: exampledb.sql with username:…

Joomla Runs Faster with HHVM + Nginx

HHVM (HipHop Virtual Machine) is an open-source virtual machine designed for executing programs written in Hack and PHP. HHVM is developed and supported by Facebook. Faster and more secure than PHP 7 (see comparisons between PHP 7 and HHVM). My site is using Joomla 3.4.5 and runs normal…