Today’s tutorial is about How to Backup Mysql Database Using PHP. Hello friends recently i was working over a website and after finishing the website i gave it to my client and he was working over it. One day suddenly there was some issue in the server and my client lost his all the data. He is not having any backup also. So the server disaster becomes dooms day for my client.

Same can happen to you in many ways like hacking, server destroy or you run some wrong query and Booooommmm you lost your data. What you will do now?

Today’s tutorial is for saving your life from these issues. This tutorial How to Backup Mysql Database Using PHP can save your data and never let you down and allow you to focus on your other work. In this tutorial we will show you how you can save your data daily and download it your local PC or any safe place. In this tutorial we will use two files and one database dump so you can check it over your PC.

Files we use.

  • Index.php
  • backupClass.php
  • Database dump

For database dump just download the attached zip file you will find the .sql database dump file.

Backup Class

In this class we are using only one function which will take 6 parameters including the database credentials, table names and backup file name. Here is the magic code

Above is the only single function which will help you to download all the tables with the data. How you will use this function and class. For this we have added the code to the index.php file which will help you to backup mysql database using php.

Index File

only a very small code to use

You will see that we have used the $table variable 2 times. If you uncomment the first line than whole database will be downloaded. If you uncomment the 2nd line than only given table names will be downloaded. 2nd Line accept only array.

Hope you like our tutorial about How to Backup Mysql Database Using PHP. Please comment below if you found any issue.

Database Backup
Database Backup
Version: 1.0
2.4 KiB