Roaddoctor

I am unsure as to the best way to do a final sync between two databases prior to making a server switch. Any advice appreciated.

About a month ago I successfully transferred the existing files and moved the database to the new server. While the old server continues its duties, I went to work updating and improving… I’ve made new table and drop table changes to the new server database, removed and added some add-ons, added and updated most of the modules. Therefore I cannot just dump the old database and restore to the new.
The old server is a MySQL3 server, the new is MySQL5.

I am ready to make the DNS switch, but first I need to sync the database, but I am thinking only specified tables. Exactly which I am not sure yet, but the only data to sync I think would be Customers, Orders, Addresses, and ???. Basically I need to move the last 30 days new business from the old to the new dbase, then make the DNS switch.

Is there an easy way? (lol)

Thanks much!

I am in process of moving an existing 2.2rc2a store from a php3/mysql3 server to a php5/mysql5 server, and as anticipated I am having some issues to sort out. I've solved most issues but have one remaining problem that has me stumped.

In admin, when entering tools-> info_manager and/or tools->zzfaq_manager (these two contributions seem to use very similar code), I am able to enter the page, but when clicking on any link, such as create new, or edit existing, etc… the page just refreshes.

The links in catalog, modules, customers, etc, all work just perfectly. It is only these two similarly coded add-ons giving me grief.

I am my own host, so have full access to anything that might be helpful… logs, cfg’s etc…

Could anyone give me a point in the right direction. I am kind of stumped. Where should I start?

Thank you
Dave