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.
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.