PHP Classes

File: readme.txt

Recommend this page to a friend!
  Classes of Vagharshak Tozalakyan   MySQL Restore   readme.txt   Download  
File: readme.txt
Role: Documentation
Content type: text/plain
Description: Readme
Class: MySQL Restore
Execute batches of MySQL queries read from files
Author: By
Last change:
Date: 18 years ago
Size: 1,614 bytes
 

Contents

Class file image Download
MySQL database restore class, version 1.0.0 HOW TO USE 1. Create the instance of MySQL_Restore class. 2. Define necessary properties. 3. Call Execute() method to create backup. require_once 'mysql_restore.class.php'; $restore_obj = new MySQL_Restore(); $restore_obj->server = 'localhost'; $restore_obj->username = 'username'; $restore_obj->password = 'password'; $restore_obj->database = 'dbname'; if (!$restore_obj->Execute(MSR_FILE, 'backups/10_02_05__12_24_22.sql.gz', true, false)) { die($restore_obj->error); } PUBLIC PROPERTIES var $server = 'localhost'; The name of MySQL server. var $port = 3306; The port of MySQl server. var $username = 'root'; Database username. var $password = ''; Database password. var $database = ''; Name of the database. var $link_id = -1; MySQL link identifier of the current connection. You can set this if you want to connect the MySQL server by your own. var $connected = false; Set true if the connection is already established before calling Execute(). var $queries = array(); Array of separate queries from SQL file or SQL commands string. var $error = ''; Error message. PUBLIC METHODS function Execute($param, $mode = MSR_STRING, $is_compressed = false, $split_only = false) $param - filename or SQL commands string; $mode - Type of SQL data: MSR_STRING - param is the string of SQL commands; MSR_FILE - param is the filename of SQL file. $is_compressed - decompress GZip compressed SQL data (file or string)? $split_only - only split SQL content to separate queries without executing them.