DB export from Prestashop 1.2 to Presta 1.4 ?

[meksi]

Hi ,

 

 

I have one store installed Presta 1.2.0.1

 

 

Now I have decided to upgrade to 1.4.4

 

 

but I could not .

 

and & so ı have decided to install not upgrade.

 

 

I have created a new directory in my hosting account and installed Preesta 1.4.

 

My problem is how can I move customer list on PhpMyAdmin ( with account details like passwords, adress, order history etc.) to my newly installed presta store wihic is version 1.4.

 

 

another information; in my former presta store database prefix is Ps_

but new store DB Preffix is Ps1_ .

 

 

Could you help me with this?

 

thanks

[Evona]

Hey!

Did you try in phpMyadmin? There you can export DB. You mark just with new prefix .

[zyko]

i am not sure, if there is any inbuilt functionality in PS for DB upgrade. But with phpmyadmin you can do it easily - you need need to export the needed table with fields from your older version PS DB and import to new version PS DB from phpmyadmin.

 

make sure before importing to new PS DB - do replace of all Ps_ to Ps1_.

 

Quite easy if have a bit knowledge of phpmyadmin, unless you do any customizations in your old PS version

 

Thanks

Delonix

[meksi]

thanks for your answers.

 

 

 

I have tried to many times with phpmyadmin export import. I should confess that ı tried it without changing prefix.

 

but the sql size is 11 mb and

 

phpmyadmin is not allowing it to import it.

[meksi]

should ı export import all the tables

 

or

 

If I export and import just customer related tables ?

 

and if it will be ok, could you advice me which tables are related with customer information in the whole databse.

[zyko]

whole DB import export is not suggestible - do just customer related tables

you can import/export following tables - ps_customer,ps_customer_group,ps_customer_message,ps_customer_thread

[meksi]

ok.

 

thank you very.much.

 

I have managed to import whole customer and order tables from presta 1.2 to presta 1,4,4 as follow;

 

I have used csv type export import method.

 

I have exported customer and order related tables one by one from Presta 1.2 as csv file.

 

then I have opened them with excel to edit as Presta 1.4 tables structure. then saved as csv file again.

 

finally, ı have imported the csv files in to related tables in presta 1.4.4. and it worked ))

 

thanks to all..