This is a discussion on easy gui mysql diff tools for windows or osx? within the osCMax v2 Installation issues forums, part of the osCMax v2.0 Forums category; Anybody know an easy to use gui or very well laid out text diff tool for windows or osx?...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| Anybody know an easy to use gui or very well laid out text diff tool for windows or osx? |
| Sponsored Links | ||
| ||
|
#2
| ||||
| ||||
| 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...
__________________ JPF - osCMax Fourm Moderator Try out our osCMax at: Live Catalog Demo Limited access Admin: Live Admin Demo Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped! |
|
#3
| ||||
| ||||
| or get it here: http://www.mysqldiff.org/
__________________ Michael Sasek osCMax Developer
|
|
#4
| |||
| |||
| 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. |
|
#5
| |||
| |||
| 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? |
|
#6
| |||
| |||
| 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. |
|
#7
| |||
| |||
| 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 |
|
#8
| |||
| |||
| 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 |
| Sponsored Links | ||
| ||
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| file diff software | chrismole | Off topic & Chit Chat | 4 | 01-15-2007 08:58 PM |
| mysql error - ms2.2 - windows IIS server | red_fraggle | osCommerce 2.2 Discussion | 1 | 05-09-2005 11:08 PM |
| cvs and easy populate help please. DBF to csv to MySql | prisiri | osCMax v1.7 Discussion | 8 | 02-23-2005 02:29 AM |
| Diff. Style for Left & Right boxes | monjurul | osCommerce 2.2 Modification Help | 2 | 05-01-2003 04:26 AM |