In this how-to I will show you how to install and configure Ubuntu Server 12.04 LTS, Apache web server, PHP and MySQL database server and backup to Google Drive (grive). Ubuntu is one of the most common version of the linux server OS on the web today, with almost 35% market share. It is light and easy to manage, even for the novice. After all, you need to know about 10-15 commands to get you started with Linux OS. The rest of the knowledge will be picked up on the way. The best way of learning is learning by doing.
It is good idea to take backup of your data, especially databases. In order to take a backup of MySQL database you can either use your root user (bad idea!) or create another user that will have just enough privileges to do the job. Once we make dump of MySQL database, we will use gzip utility to pack the database. Once you have file, you can either move it, copy it or just send it as an e-mail attachment. First, we will create a backup user. Fire up your console, log in to MySQL server and type the following command:
Continue reading “How to take backup of MySQL database from linux console”