Instead of struggling with desktop software or complex command-line tools like The Solution: Stream Processing<\/strong><\/p>\n\n\n\n The trick to handling massive files in PHP is to avoid loading the entire file into memory at once (which functions like The script below looks for the standard Here is the complete script:<\/p>\n\n\n\n PHP<\/p>\n\n\n\n This method keeps memory usage practically flat\u2014well under a few megabytes\u2014and processes gigabytes of SQL data in just a few seconds.<\/p>\n","protected":false},"excerpt":{"rendered":" Have you ever needed to restore just one database or a specific set of tables from a multi-gigabyte (e.g., 5GB) MySQL dump? Opening a file of that size in standard text editors like VS Code or Notepad++ usually leads to extreme lag or a complete system crash. Instead of struggling with desktop software or complex […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-122","post","type-post","status-publish","format-standard","hentry","category-it-networks"],"yoast_head":"\nawk<\/code> or sed<\/code>, we can use a simple, memory-efficient PHP script to extract exactly what we need.<\/p>\n\n\n\nfile_get_contents()<\/code> do). By using PHP’s fgets()<\/code> function, we can stream and process the file line by line.<\/p>\n\n\n\nmysqldump<\/code> comments that indicate the start of our target database or table (e.g., -- Current Database: <\/code>db). When it finds our target, it toggles a flag to start writing those lines to a new file. As soon as it encounters the start of a different database or table, it turns the flag off.<\/p>\n\n\n\n<?php\nini_set('memory_limit', '2G');\n\n$inputFile = 'dump_5GB.sql';\n$outputFile = 'db_fragment.sql';\n$targetName = 'db';\n\n$in = fopen($inputFile, 'r');\n$out = fopen($outputFile, 'w');\n\n$isExtracting = false;\n\nwhile (($line = fgets($in)) !== false) {\n if (strpos($line, '-- Current Database: `' . $targetName . '`') === 0 || \n strpos($line, 'USE `' . $targetName . '`;') === 0) {\n $isExtracting = true;\n } elseif (strpos($line, '-- Current Database: `') === 0 || \n strpos($line, 'USE `') === 0) {\n $isExtracting = false;\n }\n\n if (!$isExtracting) {\n if (strpos($line, '-- Table structure for table `' . $targetName . '`') === 0 ||\n strpos($line, '-- Table structure for table `' . $targetName . '_') === 0) {\n $isExtracting = true;\n } elseif (strpos($line, '-- Table structure for table `') === 0) {\n $isExtracting = false;\n }\n }\n\n if ($isExtracting) {\n fwrite($out, $line);\n }\n}\n\nfclose($in);\nfclose($out);\n<\/code><\/pre>\n\n\n\n