Category: MySQL

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.

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.