Page 1 of 1

Export User Data - Transfer to new Phoca Cart site

Posted: 10 Dec 2020, 15:53
by dmlwebal
Hi Jan

I am looking to create a new Phoca Cart website for an existing customer. Rather than simply build a new template, I would prefer to build a new site on a local server. This way the CMS database will be cleaner and all records of old unused extensions will be removed.

I wish to keep the existing Phoca Cart user information: names, addresses, usernames passwords orders etc. and all order information from the current site. The rest of the site I would prefer to be a clean Joomla, Gantry5 and Phoca Cart install. I can import products data from csv export/import and FTP transfer of images.

To transfer user data, which tables do I need to export from the current database?

I shall make sure that the Joomla database prefix the same as the current site. Also I will test the process on the local server first of course.

Regards

David

Re: Export User Data - Transfer to new Phoca Cart site

Posted: 12 Dec 2020, 15:44
by Jan
Hi,

I do it all the time so, I am preparing everything on localhost, then I just move the files to server with FTP and make export/import of database (from localhost to server host).

- after export of database tables I only change the prefix than I import it
- after sending all the files to FTP I only update the configuration.php (change the database information, and the paths - mostly 4 - 9 items changed in configuration.php)

But if you need to keep current existing data, you need to export the whole database, because there are relations between data, so exporting/importing only some of them can break the relations.

Jan

Re: Export User Data - Transfer to new Phoca Cart site

Posted: 12 Dec 2020, 19:54
by dmlwebal
Ok, that's great. Thanks again Jan :)