Simple Question?

[ActiveTuning]

Quick question, when you guys are doing development, does anything ever change in terms of the structure of the database? Like if I used a snapshot from a while ago, but used a snapshot now just by overwriting the files...is there any need to update the database structure?

[burt]

Never use an old db structure on a newer snapshot. It can only cause trouble for you.

[ActiveTuning]

If that's the case, what's the best way to move all your data?

[wizardsandwars]

Well, first of all, you should take a look at hte old and new table structures.

 

If they are the same, then you won't need to.

 

If anything is different, you can export the old data from each tabe into CSV or tab delimited files. Then open them in excel and make the necessary changes, and finally, import them into the new database.

[ActiveTuning]

The only problem with looking at the old and new structure, is I only have 1 database from my host....and I've asked on here a bunch of times if there is any way to install the tables with like a prefix or something, but nobody knows....which means I have no way of installing the tables to compare to in the first place...

[wizardsandwars]

You can create each table, 1 at a time, with a different prefix, or name.

 

Than you can compare them. :D

[Ajeh]

Beyond Compare is handy on sql files too ... 8)

 

You can make a backup of your current database table structures and then compare it to the new structure in the oscommerce.sql file.