In the last post we installed Nginx in CentOS 7. In this article we will extend our previous how-to and add how to install PHP-fpm and MariaDB. The installation process will be quite easy. Login to your server and type.
In the last article we discussed how to backup data in csv format via PHP and command line. In this part we will backup MySQL databases via mysqldump command. I assume you are logged in to your Amazon instance.
In my last article i showed you how to Setup web server on Amazon AMI or CentOS, to continue on that article further i will discuss here how to backup MySQL data into CSV format.
MySQL have this load data function, where we can insert data to a table from external files like csv, txt etc.
Update: There is a small update to this article, as if lets say some one does not have any root password yet, then how to create it 1st and then use the following commands. So that’s simple, open terminal and type the following.