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

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

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: 29
All time rank: 58335 in India India
Week rank: 40 8 in India India
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 : 
$obj = new DBExport();
//parameter value : 1 for stucture only. 0 for data with structure.

You must need to set the Database Details in the DBExport.class.php file.
File Role Description
DBExport.class.php Class Class file for the Database Export and Download Methods
download.php Aux. Download the Exported Database File Script
example.php Example Example Script file to Export and Download the MySQL Database Example Example script
ReadMe.txt Doc. Read Me file for the Class.

 Version Control Unique User Downloads Download Rankings  
This week:1
All time:6,834
This week:242

For more information send a message to info at phpclasses dot org.