Home

PHP Libraries

Other libraries

MySQL database backup and restore PHP class

Other libraries

Get it now

MySQL database backup and restore PHP class

<?php
class DBManage
{
  var $db; // 数据库连接
  var $database; // 所用数据库
  var $sqldir; // 数据库备份文件夹
  var $record;
  // 换行符
  private $ds = "n";
  // 存储SQL的变量
  public $sqlContent = "";
  // 每条sql语句的结尾符
  public $sqlEnd = ";";
  /**
   * 初始化
   *
   * @param string $host
   * @param string $username
   * @param string $password
   * @param string $thisatabase
   * @param string $charset
   */

Description: The volume file ends with _v1.sql

Function: Implement mysql database volume backup, select tables for backup, and implement single sql file and volume sql import

Usage:

1. Database backup (export)-------------------------------- ----------------------------

//They are the host, user name, password, and database name respectively. , database encoding

$db = new DBManage ('localhost', 'root', 'root', 'test', 'utf8' );

//Parameter: which table to back up ( Optional), backup directory (optional, default is backup), volume size (optional, default is 2000, which is 2M)

$db->backup ();

* ------2. Database recovery (import)--------------------------------------------- -----------------------

//They are the host, user name, password, database name, and database encoding

$db = new DBManage ('localhost', 'root', 'root', 'test', 'utf8' );

//Parameter: sql file

Disclaimer

All resources on this site are contributed by netizens or reprinted by major download sites. Please check the integrity of the software yourself! All resources on this site are for learning reference only. Please do not use them for commercial purposes. Otherwise, you will be responsible for all consequences! If there is any infringement, please contact us to delete it. Contact information: admin@php.cn

php database backup and restore

11 Jul 2016

php database backup and restore,

PHP simple method to backup and restore MySql, PHP restore mysql_PHP tutorial

12 Jul 2016

Simple method to backup and restore MySql in php, restore mysql in php. How to simply back up and restore MySql in php, restore mysql in php This article describes the simple backup and restore method of MySql in php. Share it with everyone for your reference, the details are as follows: 1. Backup: