| @@ -0,0 +1,39 | |||||
|
|
1 | ||||
|
|
2 | Markei DB migrate | |||
|
|
3 | ================= | |||
|
|
4 | ||||
|
|
5 | ||||
|
|
6 | Script for easy DTAP for Wordpress sites | |||
|
|
7 | ||||
|
|
8 | ||||
|
|
9 | ||||
|
|
10 | Installation | |||
|
|
11 | ------------ | |||
|
|
12 | ||||
|
|
13 | ||||
|
|
14 | Add markei/dbmigrate to require-lines in composer.json | |||
|
|
15 | ||||
|
|
16 | Run composer update | |||
|
|
17 | ||||
|
|
18 | Copy the example config to {project-root}/config/dbmigrate/dbmigrate.ini | |||
|
|
19 | ||||
|
|
20 | Update the configuration with your own parameters | |||
|
|
21 | ||||
|
|
22 | ||||
|
|
23 | ||||
|
|
24 | Usage | |||
|
|
25 | ----- | |||
|
|
26 | ||||
|
|
27 | For Windows | |||
|
|
28 | cd {project-root} | |||
|
|
29 | vendor\bin\dbmigrate.php.bat | |||
|
|
30 | ||||
|
|
31 | The script will list the configured environments | |||
|
|
32 | ||||
|
|
33 | First fill in the source environment, second fill in the destination. | |||
|
|
34 | Check your input and start. | |||
|
|
35 | ||||
|
|
36 | 1. a backup of the source database will be made. | |||
|
|
37 | 2. a backup of the destination database will be made. | |||
|
|
38 | 3. the backup of the source database will be imported by the destination database | |||
|
|
39 | 4. the source domain will be replaced with the destination domain in the destination database No newline at end of file | |||
| @@ -0,0 +1,32 | |||||
|
|
1 | ||||
|
|
2 | [env_dev] | |||
|
|
3 | host = localhost | |||
|
|
4 | user = my_user | |||
|
|
5 | password = secret_password | |||
|
|
6 | name = my_wp_site | |||
|
|
7 | port = 3306 | |||
|
|
8 | domain = dev-www.my-site.tld | |||
|
|
9 | ||||
|
|
10 | [env_test] | |||
|
|
11 | host = db01 | |||
|
|
12 | user = my_user | |||
|
|
13 | password = secret_password | |||
|
|
14 | name = my_wp_site | |||
|
|
15 | port = 3306 | |||
|
|
16 | domain = test-www.my-site.tld | |||
|
|
17 | ||||
|
|
18 | [env_acc] | |||
|
|
19 | host = db02 | |||
|
|
20 | user = my_user | |||
|
|
21 | password = secret_password | |||
|
|
22 | name = my_wp_site | |||
|
|
23 | port = 3306 | |||
|
|
24 | domain = acc-www.my-site.tld | |||
|
|
25 | ||||
|
|
26 | [env_prod] | |||
|
|
27 | host = db03 | |||
|
|
28 | user = my_user | |||
|
|
29 | password = secret_password | |||
|
|
30 | name = my_wp_site | |||
|
|
31 | port = 3306 | |||
|
|
32 | domain = www.my-site.tld | |||
General Comments 0
You need to be logged in to leave comments.
Login now