PHP Classes
elePHPant
Icontem

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   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2016-12-24 (13 hours ago) RSS 2.0 feedNot yet rated by the usersTotal: 173 This week: 11All time: 8,057 This week: 78Up
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.

Recommendations

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

  Performance   Level  
Name: Bharat Parmar <contact>
Classes: 11 packages by
Country: India India
Innovation award
Innovation award
Nominee: 3x

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:173
This week:11
All time:8,057
This week:78Up