This article will share with you how to implement mysql database volume backup in PHP, select tables for backup, and implement single sql file and volume sql import. Friends in need can refer to the
volume export idea: count the length of sql statement variables, compare 1 character as 1 byte, if it is greater than the set volume size, write a sql file (I don’t know if this statistics is reliable. This is also a reference to other people).
The idea of importing into volumes: read the sql file line by line, save each line as a complete sql statement to the array, and then loop and execute it to insert into the database. However, the create table statement is divided into multiple lines. This It needs to be dealt with separately (it took me a long time to do this);
<?php //宋正河 转载请注明出处 set_time_limit(0); header('content-type:text/html;charset=utf-8'); mysql_connect('localhost','root','root'); mysql_select_db('test'); $table_array=get_tables('test'); mysql_query('set names utf8'); $filesize=1024*1024*4; $start=$_GET['start']?$_GET['start']:0; $part=$_GET['part']?$_GET['part']:'1'; $table_index=$_GET['table_index']?$_GET['table_index']:'0'; $table=$table_array[$table_index]; $num=200000000;//这个数要足够大,可以是总记录数 $backupdata=''; if($start=='0'){ $query="SHOW CREATE TABLE `{$table}`"; $result = mysql_query($query); $row = mysql_fetch_row($result); $backupdata .= "DROP TABLE IF EXISTS `{$table}`;\n" . $row[1] . ";\n\n"; } $limit=($start=='0')?'':" limit $start,$num "; $query="select * from `{$table}` $limit "; $result=mysql_query($query); $numfields = mysql_num_fields($result); //统计字段数 while($row=mysql_fetch_row($result)){ $comma = ''; //存储逗号 $backupdata_tmp = "INSERT INTO `{$table}` VALUES ("; for($i=0; $i<$numfields; $i++){ $backupdata_tmp .= $comma . "'" . mysql_escape_string($row[$i]) . "'"; $comma = ','; } $backupdata_tmp .= ");\n"; if(strlen($backupdata)+strlen($backupdata_tmp) > $filesize){ //写入文件并跳转 $file='data/'.$table.'-'.$part.'.sql'; file_put_contents($file,$backupdata); echo $file.' 备份完成,程序继续进行!'; $part++; //分段 //表名 //起点 //跳转 sleep(3); echo "<script>location.href='?start={$start}&table_index={$table_index}&part={$part}';</script>"; exit; } $backupdata.=$backupdata_tmp; $start++; } if($backupdata){ $file='data/'.$table.'-'.$part.'.sql'; file_put_contents($file,$backupdata); } echo $table.'备份完成!<br />'; sleep(2); $table_index++; if($table_array[$table_index]){ echo "<script>location.href='?table_index={$table_index}';</script>"; exit; }else{ echo '恭喜你,数据库备份完毕!'; } function get_tables($db){ $tq = mysql_list_tables($db); while($tr = mysql_fetch_row($tq)){ $arrtb[] = $tr[0]; } return $arrtb; } ?>
Summary: The above is the entire content of this article, I hope it will be helpful to everyone's study.
Related recommendations:
PHP’s four basic sorting algorithms and two search algorithms
PHP generates and downloads csv files and solves problems
How PHP accepts files and gets the suffix name
The above is the detailed content of PHP implements volume backup of mysql database. For more information, please follow other related articles on the PHP Chinese website!

Long URLs, often cluttered with keywords and tracking parameters, can deter visitors. A URL shortening script offers a solution, creating concise links ideal for social media and other platforms. These scripts are valuable for individual websites a

Following its high-profile acquisition by Facebook in 2012, Instagram adopted two sets of APIs for third-party use. These are the Instagram Graph API and the Instagram Basic Display API.As a developer building an app that requires information from a

Laravel simplifies handling temporary session data using its intuitive flash methods. This is perfect for displaying brief messages, alerts, or notifications within your application. Data persists only for the subsequent request by default: $request-

This is the second and final part of the series on building a React application with a Laravel back-end. In the first part of the series, we created a RESTful API using Laravel for a basic product-listing application. In this tutorial, we will be dev

Laravel provides concise HTTP response simulation syntax, simplifying HTTP interaction testing. This approach significantly reduces code redundancy while making your test simulation more intuitive. The basic implementation provides a variety of response type shortcuts: use Illuminate\Support\Facades\Http; Http::fake([ 'google.com' => 'Hello World', 'github.com' => ['foo' => 'bar'], 'forge.laravel.com' =>

The PHP Client URL (cURL) extension is a powerful tool for developers, enabling seamless interaction with remote servers and REST APIs. By leveraging libcurl, a well-respected multi-protocol file transfer library, PHP cURL facilitates efficient execution of various network protocols, including HTTP, HTTPS, and FTP. This extension offers granular control over HTTP requests, supports multiple concurrent operations, and provides built-in security features.

Do you want to provide real-time, instant solutions to your customers' most pressing problems? Live chat lets you have real-time conversations with customers and resolve their problems instantly. It allows you to provide faster service to your custom

The 2025 PHP Landscape Survey investigates current PHP development trends. It explores framework usage, deployment methods, and challenges, aiming to provide insights for developers and businesses. The survey anticipates growth in modern PHP versio


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

SublimeText3 English version
Recommended: Win version, supports code prompts!

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools
