PHP Classes

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 Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 395 All time: 6,612 This week: 50Up
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: 51631 in India India
Week rank: 44 Up5 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 (5)  
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.

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 80%
Total:395
This week:0
All time:6,612
This week:50Up