How to Backup and Restore MySQL Database using command line tool and PhpMyAdmin

Introduction This guide will show you how to backup and restore MySQL database using command line tool in VPS server on CentOS 7 and PhpMyAdmin. You need to take backup of your MySQL database on a daily basis to have minimal impact on your web site’s data loss. Similarly for some inconsistent situations you may need to restore your site’s data into MySQL database. The PhpMyAdmin tool may be found on your cpanel, webuzo or any other control panel.

Continue

MySQL Database Backup using PHP

In this tutorial I am going to show you how to take MySQL database backup using PHP programming language. In the world of web it is important to take backup of our site and database frequently. You never know when you would come across unexpected error that may cause your site stop working. Here I will show you in PHP application which will help you to take backup as per your wish whenever you want to take backup. While most web hosting company do a daily backup of a customer’s…

Continue

Backup Site and Database in Codeigniter

Introduction I will show you how to backup site or application code and database in PHP based Codeigniter framework. In the world of web it is important to take backup of our site and database frequently. You don’t know when you’d come across unexpected situation which causes your site stop working. Here I have developed an application in Codeigniter, which will help you to take backup the application code and database. While most web hosting company do a daily backup of a customer’s database and site, relying on them to…

Continue