move all products to other site vm2

[tselis]

Good evening, because they face some technical problems on the existing site I would like build a new own from scratch and move all my goods there. same versions joomla + vm2.
I would like to move all the product details, images and custom fields ... all ...

I want to use csvi pro ... Has anyone considered a structure of the template, the other option ?!

[GJC Web Design]

can't you just transfer the vm tables & images once you complete the new site?  Job done...

[tselis]

need to rename the prefix?

[GJC Web Design]

if the prefix is different

[tselis]

yes it isnt the same . is it easy to do it from cpanel? is there any point that i need to care on it?

[GJC Web Design]

as long as you backup constantly what can go wrong? If it all falls in a heap restore the last good backup
just export what tables you need - change the prefix - drop or rename in the new - and import

[tselis]

        alterTable CHANGE h9pyn_virtuemart_products_el_gr.product_desc : ALTER TABLE `h9pyn_virtuemart_products_el_gr` CHANGE COLUMN `product_desc` `product_desc` VARCHAR(18400) NOT NULL DEFAULT ''

        Table updated: Tablename h9pyn_virtuemart_products_el_gr dropped: 0 altered: 1 added: 0
        Οι ρυθμίσεις αποθηκεύτηκαν!

this a message when i save virtuemart settings from backend... this configuration (varchar(18400) ) helps to lose the half of product details... could i keep the configuration as longtext?!