test.php
1.51 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
<?php
/*
for($i=0;$i<128;$i++) {
echo "$i>" . bin2hex(chr($i)) . "<" . PHP_EOL;
}
*/
error_reporting(E_ALL);
include_once(dirname(__FILE__) . "/../src/Ifsnop/Mysqldump/Mysqldump.php");
use Ifsnop\Mysqldump as IMysqldump;
$dumpSettings = array(
'compress' => IMysqldump\Mysqldump::NONE,
'no-data' => false,
'add-drop-table' => true,
'single-transaction' => true,
'lock-tables' => true,
'add-locks' => true,
'extended-insert' => false,
'disable-keys' => true,
'skip-triggers' => false,
'add-drop-trigger' => true,
'routines' => true,
'databases' => false,
'add-drop-database' => false,
'hex-blob' => true,
'no-create-info' => false,
'where' => ''
);
$dump = new IMysqldump\Mysqldump(
"mysql:host=localhost;dbname=test001",
"travis",
"",
$dumpSettings);
$dump->start("mysqldump-php_test001.sql");
$dumpSettings['default-character-set'] = IMysqldump\Mysqldump::UTF8MB4;
$dump = new IMysqldump\Mysqldump(
"mysql:host=localhost;dbname=test002",
"travis",
"",
$dumpSettings);
$dump->start("mysqldump-php_test002.sql");
$dump = new IMysqldump\Mysqldump(
"mysql:unix_socket=/var/run/mysqld/mysqld.sock;dbname=test005",
"travis",
"",
$dumpSettings);
$dump->start("mysqldump-php_test005.sql");
$dump = new IMysqldump\Mysqldump(
"mysql:unix_socket=/var/run/mysqld/mysqld.sock;dbname=test006a",
"travis",
"",
array("no-data" => true, "add-drop-table" => true));
$dump->start("mysqldump-php_test006.sql");
exit;