Thread: Migration tools

I'm new in dolphin-terms, but and old-timer when it comes to maintaining software, so I know the drill and what needs to be done ..... before I spend to much time developing my own migrating procedures a combined survey/tips

Found these (free!) MYSQL-tools for migrating DB

http://www.adamspiers.org/computing/mysqldiff/
mysqldiff -- a utility for comparing MySQL database structures

http://www.mrjoy.com/datadiff/

DataDiff is a utility for comparing the contents of two identical sets of tables in MySQL and returning the rows that differ between the two.

http://www.databasejournal.com/featu...le.php/1584401
Synchronizing Your MySQL Databases Using a Free MySQL Admin Tool - SQLyog


http://www.prestosoft.com/ps.asp?page=edp_examdiff
For filechanges ExamDiff (via a post in this forum)

ExamDiff is a freeware Windows 95/98/Me/NT/2000/XP/2003/Vista tool for visual file comparison. It has a number of simple and convenient features that many users have been asking for a long time from a file comparison tool.
The paid Pro version offers directory and bytelevel comparison

Any experiences with above or good alternatives ?!

We generally use SQLyog (the software) - plus eyeballs (the human kind). LOL!

Smoge

Adding free WinScp to the utility part

http://winscp.net/

quite easy to use with shell like interface
and can be scripted, e.g. made a scriptfile to set initial 777 and 666 permissions

executing WinSCP3

C:\Programs\WinSCP3\winscp3.exe /console /script=chmod.txt

with this input

# Automatically answer all prompts negatively not to stall
# the script on errors
option batch on

# Disable overwrite confirmations that conflict with the previous
option confirm off
# Connect using a password
# open user: password + site
# Connect
open your-user-here@www.yoursite-here.com

# Change remote directory
cd dolphin
# Set permissions

chmod 0777 ./backup
chmod 0777 ./cache
chmod 0777 ./inc
chmod 0777 ./langs
chmod 0777 ./media/images/banners
chmod 0777 ./media/images/blog
chmod 0777 ./media/images/gallery
chmod 0777 ./media/images/profile
chmod 0777 ./media/images/profile_bg
chmod 0777 ./media/images/sdating
chmod 0777 ./media/sound
chmod 0777 ./media/video
chmod 0777 ./periodic
chmod 0777 ./tmp

chmod 0666 ./periodic/cmd.php
chmod 0666 ./periodic/notifies.php
chmod 0666 ./inc/menu_content.inc.php
chmod 0666 ./inc/params.inc.php
chmod 0666 ./ray/inc/header.inc.php
chmod 0666 ./ray/inc/cron.inc.php
chmod 0666 ./ray/modules/chat/js/admin.js
chmod 0666 ./ray/modules/im/js/invite.js
chmod 0666 ./ray/modules/im/js/open.js
chmod 0666 ./ray/modules/presence/js/update.js
chmod 0666 ./orca/inc/header.inc.php

Originally Posted by skyrider

Adding free WinScp to the utility part

http://winscp.net/

quite easy to use with shell like interface
and can be scripted, e.g. made a scriptfile to set initial 777 and 666 permissions

executing WinSCP3

Followup on this; Finally got the upload scriptet also

1) Unzip the original dolphin zip-file

2) make a new zip, without folder in root (otherwise you will get an unwanted subfolder when unzipping), zipfile content are going to be unzipped into your target directory (probably root) on server

3) Make a command file for upload directives

# Automatically answer all prompts negatively not to stall
# the script on errors
option batch on
# Disable overwrite confirmations that conflict with the previous
option confirm off
# Connect using a password
# open user password@example.com
# Connect
open user@yourdomain
# Change remote directory if needed
cd test
# Upload the zip-file to current working directory
put "your-directory\v6.0.3-clean.zip"
# unzip new version
call unzip v6.0.3-clean.zip

and all there is left is to start WinSCP3 in a DOS prompt with the script

4)

C:\Programs\WinSCP3\winscp3.exe /console /script=upload-test.txt


works perfectly and much faster than doing a FTP file-by-file upload