Copying hikashop data base from a test site to a production site

  • Posts: 4
  • Thank you received: 0
1 week 6 days ago #346823

-- url of the page with the problem -- : clubfeeling1090.fr/t/category/15-vetements
-- HikaShop version -- : 4.6.1
-- Joomla version -- : 3.10
-- PHP version -- : 7.4.25
-- Browser(s) name and version -- : chrome 107

Hello,
I have configured new products, characteristics, variants on a testing web site. And I would like to copy the DBs impacted by this configuration to my production site.
- Which are the impacted data bases , their names ?
- Where are they located, which directory ?
- Can I push them with FTP transfer (Filezilla) to the production site ?
Many thanks,
Gerard

Please Log in or Create an account to join the conversation.

  • Posts: 77249
  • Thank you received: 12165
  • MODERATOR
1 week 6 days ago #346826

Hi,

1. It's not data bases but tables. The tables impacted if you only want to migrate the products data are: hikashop_product, hikashop_product_related, hikashop_product_category, hikashop_file, hikashop_variant, hikashop_characteristic and hikashop_price

2. The database is not accessible via FTP. The database is normally accessible via the PHPMyAdmin access provided by your hosting. Usually, it can be accessed through cpanel or a similar hosting management tool.
In PHPMyAdmin, you can export the tables mentioned in point 1 and import the file in the PHPMyAdmin of the other website.

3. FTP won't do for the data. However, if you've also added images or files for these products, these are stored in the media/com_hikashop/upload and images/com_hikashop/upload folders of your website. So you'll want to download/upload them via FTP so that HikaShop can use them with the data pointing to them in the database tables.

Please Log in or Create an account to join the conversation.

  • Posts: 4
  • Thank you received: 0
1 week 5 days ago #346835

Thanks very much Nicolas,
I did it, and it works !! :)

Please Log in or Create an account to join the conversation.

Time to create page: 0.066 seconds
Powered by Kunena Forum