Category: Database

Backup/Restore MySql database using PHP

In this post, we will be backing up and restoring database easily using PHP. The basic idea is to dump database table structure and data into a SQL file for backing up. While restoring, the SQL queries dumped into the file are executed one after another.

Bulk Insert Update into MySQL using PHP

Sometimes we need to insert large data set into database table. Using one INSERT statement per row is quite inefficient. Instead of this, we can assemble one INSERT statement with multiple rows. In this article, I am going to show how to perform bulk insert into MySQL table using PHP.

Introduction to Database Management System (DBMS)

DBMS is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. DBMS allow the definition, creation, querying, update, and administration of databases. Some of the popular DBMSs are MySQL, Oracle, MariaDB, Microsoft SQL Server, PostgreSQL, MongoDB.