Sadat PHP Database Dumper: Dump a DB using mysqldump or output SQL statements

Recommend this page to a friend!
  Info   View files Example   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2020-12-25 (2 months ago) RSS 2.0 feedNot yet rated by the usersTotal: 58 This week: 1All time: 9,880 This week: 342Up
Version License PHP version Categories
sadatdbdumper 1.0.0The PHP License5PHP 5, Databases, Systems administration
Description Author

This class can be used to dump a MySQL database using mysqldump or output SQL statements.

It can take the name of a database and other MySQL server connection values as parameter and creates SQL file that works as dump of a MySQL database.

The class can use either the mysqldump command or just output the SQL statements by performing database queries to discover the database tables, table fields, table properties and table records.

Picture of Hillary Kollan
Name: Hillary Kollan <contact>
Classes: 3 packages by
Country: Ghana Ghana
Age: ???
All time rank: 43586 in Ghana Ghana
Week rank: 327 Up2 in Ghana Ghana Up

Details

Usage

include class

    include('dump.class.php');

set host

    $sql->setDBHost('127.0.0.1');

set port

    $sql->setDBPort('3306');

set username

    $sql->setDBUsername('root');

set password

    $sql->setDBPassword('temasek209!');

set sql file name

    $sql->setSQLFileName('peregrin');

set sql dump path, make sure the path has read and write privileges

    $sql->setDumpPath('/var/www/');

Incase there is no mysqldump in your path or its not installed

$sql->setMySQLDump(false);

set download, if you wanna run it through a browser and download the sql file

$sql->setDownloadSQLFile(true);

set download, if you wanna run it through a browser and download

    $sql->setDownloadSQLFile(true);

dump MySQL File

$sql->dumpDB(true);

  Files folder image Files  
File Role Description
Accessible without login Plain text file dbdump.php Example Example script
Plain text file dump.class.php Class Class source
Accessible without login Plain text file readme.md Doc. Documentation

 Version Control Unique User Downloads Download Rankings  
 100%
Total:58
This week:1
All time:9,880
This week:342Up

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