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

Related Article

php database backup and restore

11Jul2016

php database backup and restore,

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

12Jul2016

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:

How to Backup and Restore a Single MySQL Table?

01Dec2024

How to Backup a Single Table in MySQLIn MySQL, the default behavior of the mysqldump utility is to back up an entire database. However, it is...

How Can I Selectively Backup and Restore MySQL Tables?

03Dec2024

Selective MySQL Table Backup and RestorationManaging vast databases often necessitates selective backups of individual tables. MySQL offers a...

How to Efficiently Backup and Restore Multiple MySQL Databases?

19Nov2024

Efficient Management of MySQL Database Backups: Export and Import Multiple Databases SimultaneouslyMaintaining regular data backups is crucial for...

How Do I Backup and Restore a Single MySQL Table?

01Dec2024

Backup and Restore of a Single MySQL TableBy default, the mysqldump utility backs up the entire database. However, it may be necessary to...

See all articles