| @@ -0,0 +1,5 | |||||
|
|
1 | <?xml version="1.0" encoding="UTF-8"?> | |||
|
|
2 | <buildpath> | |||
|
|
3 | <buildpathentry kind="src" path=""/> | |||
|
|
4 | <buildpathentry kind="con" path="org.eclipse.php.core.LANGUAGE"/> | |||
|
|
5 | </buildpath> | |||
| @@ -0,0 +1,28 | |||||
|
|
1 | <?xml version="1.0" encoding="UTF-8"?> | |||
|
|
2 | <projectDescription> | |||
|
|
3 | <name>markei-dbmigrate</name> | |||
|
|
4 | <comment></comment> | |||
|
|
5 | <projects> | |||
|
|
6 | </projects> | |||
|
|
7 | <buildSpec> | |||
|
|
8 | <buildCommand> | |||
|
|
9 | <name>org.eclipse.wst.common.project.facet.core.builder</name> | |||
|
|
10 | <arguments> | |||
|
|
11 | </arguments> | |||
|
|
12 | </buildCommand> | |||
|
|
13 | <buildCommand> | |||
|
|
14 | <name>org.eclipse.wst.validation.validationbuilder</name> | |||
|
|
15 | <arguments> | |||
|
|
16 | </arguments> | |||
|
|
17 | </buildCommand> | |||
|
|
18 | <buildCommand> | |||
|
|
19 | <name>org.eclipse.dltk.core.scriptbuilder</name> | |||
|
|
20 | <arguments> | |||
|
|
21 | </arguments> | |||
|
|
22 | </buildCommand> | |||
|
|
23 | </buildSpec> | |||
|
|
24 | <natures> | |||
|
|
25 | <nature>org.eclipse.php.core.PHPNature</nature> | |||
|
|
26 | <nature>org.eclipse.wst.common.project.facet.core.nature</nature> | |||
|
|
27 | </natures> | |||
|
|
28 | </projectDescription> | |||
| @@ -0,0 +1,7 | |||||
|
|
1 | <?xml version="1.0" encoding="UTF-8"?> | |||
|
|
2 | <faceted-project> | |||
|
|
3 | <fixed facet="php.component"/> | |||
|
|
4 | <fixed facet="php.core.component"/> | |||
|
|
5 | <installed facet="php.core.component" version="1"/> | |||
|
|
6 | <installed facet="php.component" version="5.4"/> | |||
|
|
7 | </faceted-project> | |||
| @@ -0,0 +1,22 | |||||
|
|
1 | Copyright (c) 2014 Markei.nl | |||
|
|
2 | ||||
|
|
3 | Permission is hereby granted, free of charge, to any person | |||
|
|
4 | obtaining a copy of this software and associated documentation | |||
|
|
5 | files (the "Software"), to deal in the Software without | |||
|
|
6 | restriction, including without limitation the rights to use, | |||
|
|
7 | copy, modify, merge, publish, distribute, sublicense, and/or sell | |||
|
|
8 | copies of the Software, and to permit persons to whom the | |||
|
|
9 | Software is furnished to do so, subject to the following | |||
|
|
10 | conditions: | |||
|
|
11 | ||||
|
|
12 | The above copyright notice and this permission notice shall be | |||
|
|
13 | included in all copies or substantial portions of the Software. | |||
|
|
14 | ||||
|
|
15 | THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, | |||
|
|
16 | EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES | |||
|
|
17 | OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND | |||
|
|
18 | NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT | |||
|
|
19 | HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, | |||
|
|
20 | WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING | |||
|
|
21 | FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR | |||
|
|
22 | OTHER DEALINGS IN THE SOFTWARE. No newline at end of file | |||
| @@ -0,0 +1,69 | |||||
|
|
1 | <?php | |||
|
|
2 | ||||
|
|
3 | $base_dir = realpath(__DIR__ . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . '..'); | |||
|
|
4 | $config_file = $base_dir . DIRECTORY_SEPARATOR . 'config' . DIRECTORY_SEPARATOR . 'dbmigrate' . DIRECTORY_SEPARATOR . 'env.ini'; | |||
|
|
5 | ||||
|
|
6 | $config = parse_ini_file($config_file, true); | |||
|
|
7 | $envs = array(); | |||
|
|
8 | foreach ($config as $name => $section) | |||
|
|
9 | { | |||
|
|
10 | if (substr($name, 0, strlen('env_')) === 'env_') | |||
|
|
11 | { | |||
|
|
12 | $envs[substr($name, strlen('env_'))] = $section; | |||
|
|
13 | } | |||
|
|
14 | } | |||
|
|
15 | ||||
|
|
16 | echo 'Available environments:' . PHP_EOL; | |||
|
|
17 | foreach ($envs as $name => $env_config) | |||
|
|
18 | echo '* ' . $name . PHP_EOL; | |||
|
|
19 | echo PHP_EOL; | |||
|
|
20 | ||||
|
|
21 | echo 'Select the source env:' . PHP_EOL; | |||
|
|
22 | $source = trim(fgets(STDIN)); | |||
|
|
23 | echo PHP_EOL; | |||
|
|
24 | ||||
|
|
25 | echo 'Select the destination env:' . PHP_EOL; | |||
|
|
26 | $dest = trim(fgets(STDIN)); | |||
|
|
27 | echo PHP_EOL; | |||
|
|
28 | ||||
|
|
29 | echo 'Please make sure: You want to export the ' . $source . ' database to ' . $dest . '? Y|N' . PHP_EOL; | |||
|
|
30 | $confirm = strtolower(trim(fgets(STDIN))); | |||
|
|
31 | echo PHP_EOL; | |||
|
|
32 | if (in_array($confirm, array('y', 'yes', 'j', 'ja', 'ok')) === false) | |||
|
|
33 | exit('Okay, exit!'); | |||
|
|
34 | ||||
|
|
35 | if (file_exists($base_dir . DIRECTORY_SEPARATOR . 'backup') === false) | |||
|
|
36 | mkdir($base_dir . DIRECTORY_SEPARATOR . 'backup'); | |||
|
|
37 | ||||
|
|
38 | echo 'Dump source database:' . PHP_EOL; | |||
|
|
39 | $source_dump = $file = $base_dir . DIRECTORY_SEPARATOR . 'backup' . DIRECTORY_SEPARATOR . 'dbbackup_' . $source . '_' . date('YmdHis') . '.sql'; | |||
|
|
40 | $command = 'mysqldump --add-drop-table --comments --host=' . $envs[$source]['host'] . ' --no-create-db --password=' . $envs[$source]['password'] . ' --port=' . $envs[$source]['port'] . ' --result-file=' . $file . ' --default-character-set=utf8 --user=' . $envs[$source]['user'] . ' ' . $envs[$source]['name']; | |||
|
|
41 | echo ' target file: ' . $file . PHP_EOL; | |||
|
|
42 | echo ' command: ' . $command . PHP_EOL; | |||
|
|
43 | system($command); | |||
|
|
44 | echo PHP_EOL . 'Complete' . PHP_EOL . PHP_EOL; | |||
|
|
45 | ||||
|
|
46 | echo 'Dump source database:' . PHP_EOL; | |||
|
|
47 | $dest_dump = $file = $base_dir . DIRECTORY_SEPARATOR . 'backup' . DIRECTORY_SEPARATOR . 'dbbackup_' . $dest . '_' . date('YmdHis') . '.sql'; | |||
|
|
48 | $command = 'mysqldump --add-drop-table --comments --host=' . $envs[$dest]['host'] . ' --no-create-db --password=' . $envs[$dest]['password'] . ' --port=' . $envs[$dest]['port'] . ' --result-file=' . $file . ' --default-character-set=utf8 --user=' . $envs[$dest]['user'] . ' ' . $envs[$dest]['name']; | |||
|
|
49 | echo ' target file: ' . $file . PHP_EOL; | |||
|
|
50 | echo ' command: ' . $command . PHP_EOL; | |||
|
|
51 | system($command); | |||
|
|
52 | echo PHP_EOL . 'Complete' . PHP_EOL . PHP_EOL; | |||
|
|
53 | ||||
|
|
54 | echo 'Load data on destination database:' . PHP_EOL; | |||
|
|
55 | $command = 'mysql --host=' . $envs[$dest]['host'] . ' --password=' . $envs[$dest]['password'] . ' --port=' . $envs[$dest]['port'] . ' --default-character-set=utf8 --user=' . $envs[$dest]['user'] . ' --database=' . $envs[$dest]['name'] . ' < ' . $source_dump; | |||
|
|
56 | echo ' load sql: ' . $source_dump . PHP_EOL; | |||
|
|
57 | echo ' command: ' . $command . PHP_EOL; | |||
|
|
58 | system($command); | |||
|
|
59 | echo PHP_EOL . 'Complete' . PHP_EOL . PHP_EOL; | |||
|
|
60 | ||||
|
|
61 | echo 'Replace domain information in database:' . PHP_EOL; | |||
|
|
62 | $command = 'php vendor\dvdgiessen\dbsr\index.php --host ' . $envs[$dest]['host'] . ' --user ' . $envs[$dest]['user'] . ' --password ' . $envs[$dest]['password'] . ' --database ' . $envs[$dest]['name'] . ' --charset utf8 -- ' . $envs[$source]['domain'] . ' ' . $envs[$dest]['domain']; | |||
|
|
63 | echo ' search for: ' . $envs[$source]['domain'] . PHP_EOL; | |||
|
|
64 | echo ' replace with: ' . $envs[$dest]['domain'] . PHP_EOL; | |||
|
|
65 | echo ' command: ' . $command . PHP_EOL; | |||
|
|
66 | system($command); | |||
|
|
67 | echo PHP_EOL . 'Complete' . PHP_EOL . PHP_EOL; | |||
|
|
68 | ||||
|
|
69 | echo PHP_EOL . 'Done!' . PHP_EOL . PHP_EOL; No newline at end of file | |||
| @@ -0,0 +1,14 | |||||
|
|
1 | { | |||
|
|
2 | "name": "markei/dbmigrate", | |||
|
|
3 | "version": "1", | |||
|
|
4 | "description": "Script for migrating databases between environments, easy for use in a situation of Wordpress and DTAP", | |||
|
|
5 | "license": "MIT", | |||
|
|
6 | "authors": [ | |||
|
|
7 | { | |||
|
|
8 | "name": "Maarten de Keizer", | |||
|
|
9 | "email": "m.de.keizer@markei.nl", | |||
|
|
10 | "role": "Lead Developer" | |||
|
|
11 | } | |||
|
|
12 | ], | |||
|
|
13 | "bin": ["bin/dbmigratie.php"] | |||
|
|
14 | } | |||
General Comments 0
You need to be logged in to leave comments.
Login now