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: 394 This week: 1All time: 6,621 This week: 560Up
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.

Picture of Bharat Parmar
  Performance   Level  
Name: Bharat Parmar <contact>
Classes: 11 packages by
Country: India India
Age: 33
All time rank: 52131 in India India
Week rank: 411 Up26 in India India Up
Innovation award
Innovation award
Nominee: 3x

Recommendations

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

Example

<?php
$obj
= new DBExport();

//parameter value : 1 for stucture only. 0 for data with structure.
$obj->Export(0);
?>


Details

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 README.md 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  
 80%
Total:394
This week:1
All time:6,621
This week:560Up