osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

easy gui mysql diff tools for windows or osx?

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?...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Installation issues

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 06-24-2005, 08:28 AM
Member
 
Join Date: Dec 2004
Posts: 46
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
miahac
Default easy gui mysql diff tools for windows or osx?

Anybody know an easy to use gui or very well laid out text diff tool for windows or osx?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
  #2  
Old 06-24-2005, 01:22 PM
jpf's Avatar
jpf jpf is offline
Moderator

 
Join Date: Sep 2003
Location: Manitoba, Canada
Posts: 1,665
Thanks: 2
Thanked 93 Times in 79 Posts
Rep Power: 12
jpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of light
Default RE: easy gui mysql diff tools for windows or osx?

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!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 06-24-2005, 04:50 PM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,446
Thanks: 73
Thanked 334 Times in 313 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default RE: easy gui mysql diff tools for windows or osx?

or get it here:
http://www.mysqldiff.org/
__________________
Michael Sasek
osCMax Developer


  • osCMax Templates - Hundreds of premium quality templates. New designs every month!

  • xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience.

  • osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host.

  • osCMax Template Tutorial - Learn how to make your own custom templates and how to use the powerful features of the osCMax template system.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #4  
Old 06-25-2005, 08:52 AM
Member
 
Join Date: Dec 2004
Posts: 46
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
miahac
Default RE: easy gui mysql diff tools for windows or osx?

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.
__________________
Network Administrator
Kansas Hosting
http://www.kansashosting.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #5  
Old 06-25-2005, 09:17 AM
Member
 
Join Date: Dec 2004
Posts: 46
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
miahac
Default RE: easy gui mysql diff tools for windows or osx?

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?
__________________
Network Administrator
Kansas Hosting
http://www.kansashosting.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #6  
Old 06-25-2005, 11:29 AM
Member
 
Join Date: Dec 2004
Posts: 46
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
miahac
Default RE: easy gui mysql diff tools for windows or osx?

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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #7  
Old 06-26-2005, 11:21 AM
New Member
 
Join Date: Dec 2003
Location: Moscow
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
case510
Default RE: easy gui mysql diff tools for windows or osx?

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #8  
Old 06-27-2005, 07:30 PM
Member
 
Join Date: Dec 2004
Posts: 46
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
miahac
Default RE: easy gui mysql diff tools for windows or osx?

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

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


All times are GMT -8. The time now is 11:28 PM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax