This is a simple class to dump your MySQL/MariaDB database with foreign keys.
No exec, passthru, etc needed.
This fork fixes some bugs and is compatible with PHP 8.1.
Example usage:
<?php
include_once __DIR__.'/mysql_replacement.php';
require_once __DIR__.'/FKMySQLDump.php';
//MySQL connection parameters
$dbhost = 'localhost';
$dbuser = 'root';
$dbpsw = '';
$dbname = 'example';
//Connects to mysql server
$connessione = mysql_connect($dbhost,$dbuser,$dbpsw);
//Set encoding
mysql_query("SET CHARSET utf8");
mysql_query("SET NAMES 'utf8' COLLATE 'utf8_general_ci'");
//Creates a new instance of FKMySQLDump: it exports without compress and base-16 file
$dumper = new FKMySQLDump($dbname,'fk_dump.sql',false,false);
$params = array(
//'skip_structure' => TRUE, // if set true = only data is in result
//'skip_data' => TRUE, // if set true = only structure and FKs are in result
);
//Make dump
$dumper->doFKDump($params);