PDA

View Full Version : easy gui mysql diff tools for windows or osx?



miahac
06-24-2005, 08:28 AM
Anybody know an easy to use gui or very well laid out text diff tool for windows or osx?

jpf
06-24-2005, 01:22 PM
MySQL_Diff

....a free php program to compare 2 mysql database and make a 3rd SQL quiry to upgrade from and OLD database format to a new format.

It's included with the orginal MS2 version...

michael_s
06-24-2005, 04:50 PM
or get it here:
http://www.mysqldiff.org/

miahac
06-25-2005, 08:52 AM
I must have been asking the wrong question. I mostly just want to import the products and customers data. This tool looks very usefull but I guess I don't need to see the table differences. Just the differences in the content of a few tables.

miahac
06-25-2005, 09:17 AM
ok, here is what I am trying. I ran the diff utility to generate some sql that should upgrade my old database to the new format. back up the old db, Then using php my admin i ran the sql against the old db. Then i backed up the old db again with the new tables. Restore the first backup, so my old db is back to normal. Upload the modified old db to the backups dir of the new cart and now I should restore it to the new cart and all the stuff should be there?

miahac
06-25-2005, 11:29 AM
close, forget about restoring directly. After I had the old db upgraded, I exported the data it from phpmyadmin (not the structure) then I took the export file and manually copied each tables data into the new database via phpmy admin. This took 30 minutes but gave me a better chance to pour over data conflicts.

case510
06-26-2005, 11:21 AM
If you have Apache or other server installed, try this one:
http://www.mysqldatamanager.com/products/mdm
You can install it on the same host where your oscommerce is installed and connect to mysql locally

miahac
06-27-2005, 07:30 PM
Thanks Guys!

I was able to get my modified ms2 database updated with http://www.mysqldiff.org/
Then I exported the data using phpmyadmin
Then I imported the new data, a few tables at a time (skipping stuff that did not need imported) with copy and paste.

Sorry I did not get to try http://www.mysqldatamanager.com/products/mdm