Download the PHP package y0lk/sqldumper without Composer
On this page you can find all versions of the php package y0lk/sqldumper. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download y0lk/sqldumper
More information about y0lk/sqldumper
Files in y0lk/sqldumper
Informations about the package sqldumper
SQLDumper
SQLDumper is a small library designed to easily create customized SQL dumps.
Installation
Via Composer
Usage
The concept is that you can select tables and set certain "dump parameters" for each table, made so you can chain a bunch of calls to quickly create a customized dump.
Dumper options
groupDrops(bool $group)
When set to TRUE, this will group DROP statements and put them at the beginning of the dump
groupInserts(bool $group)
When set to TRUE, this will group INSERT statements and put them at the end of the dump
Table selection
There are 3 basic methods to select tables. When a table or a list of tables are selected, they are returned as TableDumper objects on which you can set options for the dump.
allTables()
Selects all the tables in the DB
table(string|Table $table)
Select by table's name (string) or a Table object
listTables(array $listTables)
Select by a list of table names (string) or Table object
Table options
This is the list of methods available on each each TableDumper
withStructure(bool $withStructure)
Whether to dump the table CREATE structure
withData(bool $withData)
Whether to dump table data (INSERT statement)
withDrop(bool $withDrop)
Wheter to include the DROP statement (before CREATE)
where(string $where_string)
WHERE query string as regular SQL
Output
dump(resource $stream)
This the main dump function, outputs the dump to a stream.
save(string $filename)
Saves the dump to a file
License
The MIT License (MIT). Please see License File for more information.
All versions of sqldumper with dependencies
ext-pdo_mysql Version *
php Version >=7.2.0