PHP Classes

File: example-backup.php

Recommend this page to a friend!
  Classes of Richard Munroe   SQL Backup   example-backup.php   Download  
File: example-backup.php
Role: Example script
Content type: text/plain
Description: Example of backup
Class: SQL Backup
RDBMS independent backup and restore SQL databases
Author: By
Last change:
Date: 17 years ago
Size: 1,406 bytes


Class file image Download

//---- Including the class.
include 'class.SQLBackup.php';

//---- Database host, name user and pass.
//---- Change these to match your mysql database.
$db_host = "localhost" ;//---- Database host(usually localhost).
$db_name = "test" ;//---- Your database name.
$db_user = "root" ;//---- Your database username.
$db_pass = "" ;//---- Your database password.

//---- The name of the file which you want to save backup file in it.
//---- If this file does not exist it will be created.(over writed).
//---- You need to use physical path to this file. e.g. ../data/backup.txt
$output = "backup.txt";

//---- If this is true, only tables' structure will be stored.
//---- If this is false, tables' structure and all their data(everything) will be stored.
$structure_only = false;

//---- instantiating object.
$backup = new SQLBackup($db_user,

//---- calling the backup method finally creats a file with the name specified in $output
// and stors everythig so you can copy the file anywhere you want. This file will be
// restored with another method of this class named "restore" that is described in
// example-backup.php