*We deployed an SVN server on Dropbox(!) and everything works fine, but I'm looking for an easy tutorial
QUESTION #1: how to version control WordPress database for the theme development with several developers
Main tasks:
- Stability
- Easy to update
- Branch, merge, diff conflicts
I've searched a lot of similar topics,
- but many of them just give an overview, not tutorials for dummies
- very few of them show how to code those scripts exactly.
So here are results of three days of research - almost 20 hours(!)
QUESTION #2: The scripts (below) are enough for given tasks (above)? or I need to...
- I need to check triggers, views and strip them (how?)
- This code provides DDL separation (schema and data includes)?
- Is is stable in the long run?
update.bat
if exist TortoiseProc.exe goto work1
exit
:work1
rem call D:\xampp-themes\mysql_stop.bat
rem ping 192.0.2.2 -n 1 -w 3000 > nul
START TortoiseProc.exe /command:update /path:"D:\xampp-themes\htdocs\themes\wp-content\themes\theme1"
rem call D:\xampp-themes\mysql_start.bat
pause
if exist d:\xampp-themes\mysql\bin\mysql.exe goto work2
exit
:work2
d:\xampp-themes\mysql\bin\mysql.exe -u root --default-character-set=utf8 wordpress<"d:\xampp-themes\htdocs\themes\wp-content\themes\theme1\dbcreation.sql"
d:\xampp-themes\mysql\bin\mysql.exe -u root -D --default-character-set=utf8 wordpress<"d:\xampp-themes\htdocs\themes\wp-content\themes\theme1\dbase_data.sql"
rem call D:\xampp-themes\mysql_stop.bat
rem ping 192.0.2.2 -n 1 -w 3000 > nul
rem exit
pause
commit.bat
if exist d:\xampp-themes\mysql\bin\mysqldump.exe goto work1
exit
:work1
d:\xampp-themes\mysql\bin\mysqldump.exe -u root --default-character-set=utf8 wordpress>"d:\xampp-themes\htdocs\themes\wp-content\themes\theme1\dbase_data.sql"
d:\xampp-themes\mysql\bin\mysqldump.exe -u root -d --default-character-set=utf8 wordpress>"d:\xampp-themes\htdocs\themes\wp-content\themes\theme1\dbase_structure.sql"
call D:\xampp-themes\mysql_stop.bat
rem ping 192.0.2.2 -n 1 -w 3000 > nul
if exist TortoiseProc.exe goto work2
exit
:work2
START TortoiseProc.exe /command:commit /path:"D:\xampp-themes\mysql\data"
START TortoiseProc.exe /command:commit /path:"D:\xampp-themes\htdocs\themes\wp-content\themes\theme1"
pause
call D:\xampp-themes\mysql_start.bat
rem exit
All shown above can be pretty lame, but anyway:
Could you suggest a better aproach?
Specs:
- Dropbox as a server on Windows environment (not bash/linux syntax)
- Vanilla WordPress 3.5.1
- XAMPP
- SVN or Subversion with TortoiseSVN Windows client
Please, provide / edit code! Thanks in advance!
