<?php
//include the class file
include('mysql_backup_class_inc.php');
//set up the variables we will need
//NOTE: This has only been tested on MySQL!!
//set up our site name and application name for the sql file that is generated
$appname = 'MySQL Backup Class';
$myurl = 'http://www.example.com';
$backupPath = '/var/www/phpclasses/mysql_backup/';
//SQL server variables (MySQL)
$sql_type = 'mysql';
$sql_user = 'myUser';
$sql_pass = 'password123';
$sql_server = 'localhost';
$database = 'myDB';
//Instantiate the class
$dumper = new dbdump($sql_type,$sql_user,$sql_pass,$sql_server,$database,NULL);
//Get the table structure only
$struct = $dumper->structureOnly($appname, $myurl,$backupPath);
echo $struct;
//Dump out some breaks so that it looks cool
echo "<br><br><hr>";
//Get the database structure and data
$dataandstruct = $dumper->dataAndStruct($appname, $myurl, $backupPath);
echo $dataandstruct;
?>
|
Download
