CRE Loaded Community

hi, I need help again

I've successfully installed the new shopping cart - loaded commerce 6.5. I had a dump file of my old database, but When I load the dump file into the new database, the new database structure was replace by the old one, which makes the new shop not working correctly.

are there any ways to copy the data from old db to the new one without having the new database structure replaced???

PS: I can't use the copy database feature that are built in in loaded commerce 6.5 since my old db is too big, it won't be copied.

Thanks Thanks

You don't do this - you use a 6.5 upgrader and create a blank database for it to build the tables / data from your old version. Unless you have a lot of time to go through all tables and manually modify / check them.

Simon

Hi Simon,

the problem is that my old Db is really big, it won't be copied through the upgrader. I've tried to leave my computer on for the whole night, the second day i checked, it is still copying .

so what i did was to make a dump file of my old db, then empty all the records in the old db. they copy the old db to new one with loaded commerce upgarder. then load the dump file to the new db, then my new db strucutre was replaced by the old one. I hope you get my point, it's really a headache

I tried to save my old db tables one by one as xls file, then loaded it to the new db. that worked fine, and would keep my new db structure. but since i have more than 100 tables, it's also a lot of work to do it manually.

Thanks.

Sounds unlikely.

So if you truncated all the non-essential tables - eg sessions, visual verify code, whos online, don't copy over configuration or configuration groups, infobox heading, infobox configuration ... optimise all the remaining, what size dbase have you got after that ?

Worse case scenario - you compare table structures and insert rows from each table of the old dbase. Sure, takes a while - depends on what version of cre you're upgrading from (the older the longer that'd take.)

Simon

after i customized table, i managed to have my old db to shrink it's size to 145mb.

I eventually managed to copy the DB over to the new one by duplicating the old db and added a few extra tables from 6.5. although I still can't copy the old db directly from to the new one. my old db is based on loaded 6.2. but by adding few new tables that are existing in 6.5, i managed to copy it over. weird enough, but i think you are right, the older the version you are upgrading from, the harder it will be.

now I'm working on integrating the functions / features from my old shop to the new one. I guess it will be another nightmare since the old shop has been customized a lot to it's original version of 6.2.

I'll come up with more question i believe

Thanks a lot for your suggestions Simon.