how to move date from 206 to 207 ?

General Installation & Upgrade
1

Hi,

Upgrade from 206 to 207 does not work for me… (I’m not the only one.)

So I thought lets install a fresh 207



installing a fresh 207 was fine,



Now I would like to move my data from the old 206 to the 207., so far I was not able to.



I used the DB Backup /restaure and I get

```php

Database error: Unknown column ‘a.regexp’ in ‘field list’ (1054)

Invalid query: SELECT a.option_id, a.option_type, a.position, a.inventory, a.product_id, a.regexp, a.required, b.option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, a.status FROM cscart_product_options as a LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = ‘EN’ LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE (a.product_id = 29783 OR c.product_id = 29783) ORDER BY a.position



```



any help welcome

2

[quote name=‘rdr’]Hi,

Upgrade from 206 to 207 does not work for me… (I’m not the only one.)

So I thought lets install a fresh 207



installing a fresh 207 was fine,



Now I would like to move my data from the old 206 to the 207., so far I was not able to.



I used the DB Backup /restaure and I get

```php

Database error: Unknown column ‘a.regexp’ in ‘field list’ (1054)

Invalid query: SELECT a.option_id, a.option_type, a.position, a.inventory, a.product_id, a.regexp, a.required, b.option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, a.status FROM cscart_product_options as a LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = ‘EN’ LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE (a.product_id = 29783 OR c.product_id = 29783) ORDER BY a.position



```



any help welcome[/QUOTE]



I don’t think this is possible. You must restore backup to same version backup was made.

3

I nailed it… at last I’m running 207 and its working:







Install [COLOR=“Red”]20[B]6 [/B[/COLOR]]in a new directoty “upme” with no data

on a new db “db207” for exemple



export your main 206 DB [COLOR=“Red”]to[/COLOR] your “upme” cscart instalation

upgrade the “Upme” cscart instalation using the upgrade from the control panel



Upgrade manualy the main cs cart using uc.tgz



edit your configlocal from the main cs cart and make it use the “db207” you created for up me.



delete the up me directory