This is a discussion on Database Structure Comparison OSCMax 1.7 vs. 2RC2 within the osCMax v2 Features Discussion forums, part of the osCMax v2.0 Forums category; This is a diff, using Beyond Compare. I use this to tell me what to expect when I move my ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| This is a diff, using Beyond Compare. I use this to tell me what to expect when I move my data from one database to another. I hope this is helpful to someone. If it's old news, or redundant, or something, let me know, too. Thanks, Ken |
|
#2
| ||||
| ||||
| Looks good to me.... However I would not use this DIFF package to upgrade... Use MYSQLDIFF tool would be MUCH safer/easier....
__________________ 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
| |||
| |||
| Is there an alternative to MYSQLDIFF tool? It does not work on my shared server. |
|
#4
| ||||
| ||||
| Set it up locally on your development computer, and do your 'diffing' from the desktop...
__________________ Michael Sasek osCMax Developer
|
|
#5
| |||
| |||
| Gents, If the diff, using whatever method, shows that the only issue appears to be added tables and fields (and maybe that one primary key change).... If you just do an export of the old database with complete and/or extended inserts, that will make sure that all the fields align themselves correctly. I've been lucky with this in the past. Or should I suck it up, and learn a new tool, for my own good? |
|
#6
| ||||
| ||||
| Is not hard to learn.... Beyond Compare is a great tool however it is still DUM about correct SQL script. Like I said at first glance - it looks good. No harm in trying..provided all has been backuped...perfered if you tested on a "test" site (see below). As for setting up a 'localhost' (to do your delveloping/testing ect.. on your local PC) - download a WAMP like EasyPHP to install Apache/MySQL/PHP on your local computer. 30 sec install - load the program - PUT the files in the WWW or web directory (each wamp is a bit differnt where this is - but can be changed if need be) - Go into phpmyadmin and setup your MYSQL username & password. Then load up your perfered browser like FireFox and put 'localhost' as the URL...good to go!
__________________ 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! |
|
#7
| |||
| |||
| OK, ya big stud. I tried installing mysqldiff on my hosting account, and couldn't connect to my databases, even though I can use ODBC to connect to them. I read some stuff about WAMP, etc., that the uninstalls can be messy. Is there a chance that you can run this 107->2.0 mysqldiff and post it for those of us less technically fortunate? Thanks, K |
|
#8
| |||
| |||
| I reinstalled mysqldiff, and found a few bugs, but the script at least ran to completion, although I had to re-run the section where it failed. This script will convert the database to the new structure. I'd suggest running it against a copy of your production database, of course. I will be assessing whether the patched database works under the 2.0 RC2 code base. Anyone care to join me? Thanks, K |
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| New to OSCMax 2.0 - looking for a fair comparison | djgizmo | osCMax v2 Features Discussion | 6 | 10-24-2006 03:26 PM |
| how do i convert oscommerce database backups to oscmax? | chuan | osCMax v2 Installation issues | 1 | 10-07-2006 06:43 PM |
| Point of Sale program that will use Oscmax database? | Redeye_Joe | osCMax v2 Customization/Mods | 3 | 02-08-2006 12:18 AM |
| OSCMax v2 - Stuck on New Installation Database Import | Geno11x11 | osCMax v2 Installation issues | 2 | 12-04-2005 10:27 AM |
| Printing the Database Structure PDF | DenverDave | osCommerce 2.2 Modification Help | 1 | 04-10-2003 01:50 PM |