PHP Classes

PHP MySQL Database Export to SQL: Dump a MySQL database records to a SQL file

Recommend this page to a friend!
  Info   View files Example   View files View files (5)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 390 All time: 6,632 This week: 200Up
Version License PHP version Categories
mysql-db-export 1.0Freeware4Databases, Systems administration


This class can dump a MySQL database records to a SQL file.

It can get the list of tables of a given MySQL database and retrieve the data of the records of those tables.

The class can generate a file with SQL statements to insert the data back into the database tables.


CRUD MySQL and MySQL dump to SQL file
I need a class for connect to MySQL and dump SQL file

Picture of Bharat Parmar
  Performance   Level  
Name: Bharat Parmar <contact>
Classes: 11 packages by
Country: India India
Age: 32
All time rank: 52330 in India India
Week rank: 118 Up14 in India India Up
Innovation award
Innovation award
Nominee: 3x

Project : MySQL Database Export Developed By : Bharat Parmar Version : 1.0 ==================== File Structure : ================== 1) example.php : Example Script file to export the Database 2) download.php : Download Database File Script 3) DBExport.class.php : Class file which includes all the methods to Export the MySQL Database and Download the File. Require to set the database details here. Requirements : ================== 1) PHP Version : 3.0 and above Script Details : ================== 1) Export(0) : Parameter : 0 => Data with Structure All Tables. 1 => Structure only All Tables. Use : <?php $obj = new DBExport(); //parameter value : 1 for stucture only. 0 for data with structure. $obj->Export(0); ?> You must need to set the Database Details in the DBExport.class.php file.
  Files folder image Files  
File Role Description
Plain text file DBExport.class.php Class Class file for the Database Export and Download Methods
Accessible without login Plain text file download.php Aux. Download the Exported Database File Script
Accessible without login Plain text file example.php Example Example Script file to Export and Download the MySQL Database
Accessible without login Plain text file Example Example script
Accessible without login Plain text file ReadMe.txt Doc. Read Me file for the Class.

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:6,632
This week:200Up