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: 1) 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 2) Create database with the same…

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:…