[Skip to main content](#vessel-content) # Copying hikashop data base from a test site to a production site ## - **[gerard1090](/forum/user/69770-gerard1090 "View gerard1090's Profile")** - [![gerard1090's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/69770-gerard1090 "View gerard1090's Profile") Topic Author - [ Offline](/forum/user/69770-gerard1090) Less More - Posts: 4 - Thank you received: 0 - - 3 years 11 months ago [\#346823](#346823) by [gerard1090](/forum/user/69770-gerard1090 "View gerard1090's Profile") *[Copying hikashop data base from a test site to a production site](/forum/37-import-export-csv-xls/905405-copying-hikashop-data-base-from-a-test-site-to-a-production-site#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")* was created by *[gerard1090](/forum/user/69770-gerard1090 "View gerard1090's Profile")* -- url of the page with the problem -- : [ clubfeeling1090.fr/t/category/15-vetements](https://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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDU0MDUtY29weWluZy1oaWthc2hvcC1kYXRhLWJhc2UtZnJvbS1hLXRlc3Qtc2l0ZS10by1hLXByb2R1Y3Rpb24tc2l0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86286 - Thank you received: 14263 - - 3 years 11 months ago [\#346826](#346826) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Copying hikashop data base from a test site to a production site](/forum/37-import-export-csv-xls/905405-copying-hikashop-data-base-from-a-test-site-to-a-production-site#346826 "-- 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")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDU0MDUtY29weWluZy1oaWthc2hvcC1kYXRhLWJhc2UtZnJvbS1hLXRlc3Qtc2l0ZS10by1hLXByb2R1Y3Rpb24tc2l0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[gerard1090](/forum/user/69770-gerard1090 "View gerard1090's Profile")** - [![gerard1090's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/69770-gerard1090 "View gerard1090's Profile") Topic Author - [ Offline](/forum/user/69770-gerard1090) Less More - Posts: 4 - Thank you received: 0 - - 3 years 11 months ago [\#346835](#346835) by [gerard1090](/forum/user/69770-gerard1090 "View gerard1090's Profile") Replied by *[gerard1090](/forum/user/69770-gerard1090 "View gerard1090's Profile")* on topic *[Copying hikashop data base from a test site to a production site](/forum/37-import-export-csv-xls/905405-copying-hikashop-data-base-from-a-test-site-to-a-production-site#346835 "-- 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")* Thanks very much Nicolas, I did it, and it works !! ![:)](/media/kunena/emoticons/8.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDU0MDUtY29weWluZy1oaWthc2hvcC1kYXRhLWJhc2UtZnJvbS1hLXRlc3Qtc2l0ZS10by1hLXByb2R1Y3Rpb24tc2l0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[simonlindsay](/forum/user/32377-simonlindsay "View simonlindsay's Profile")** - [![simonlindsay's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32377-simonlindsay "View simonlindsay's Profile") - [ Offline](/forum/user/32377-simonlindsay) Less More - Posts: 29 - Thank you received: 3 - - 3 years 9 months ago [\#348090](#348090) by [simonlindsay](/forum/user/32377-simonlindsay "View simonlindsay's Profile") Replied by *[simonlindsay](/forum/user/32377-simonlindsay "View simonlindsay's Profile")* on topic *[Copying hikashop data base from a test site to a production site](/forum/37-import-export-csv-xls/905405-copying-hikashop-data-base-from-a-test-site-to-a-production-site#348090 "-- 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")* Hi Nicolas, I am looking to update my Joomla production site from Joomla 3.xxx to 4.xxx but having experienced a major fail updating one site from Joomla 3 to 4, I have decided to copy all of my Hikashop tables to my new site. I can then update the original site to Joomla 4 and reimport the tables. However, I have a copy on my Joomla 4 site of Hikashop with all the data in - shoes, computing, ebooks and automobiles and all their products but I cannot see the new products etc. On my Joomla 3 site the database name is 'g2049' and the tables are 'jm_' and on the Joomla 4 site the database is c667 and the tables are 'c667_'. I have figured out how to export the files but when I import them again having selected the table in phpadmin, it throws up an error. I can see some of the tables that I have imported at the end of the database - 'jm_' - but I can't figure out how to integrate them into the main database - tables c667. I'm sure it must be something simple. Many thanks. Simon Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDU0MDUtY29weWluZy1oaWthc2hvcC1kYXRhLWJhc2UtZnJvbS1hLXRlc3Qtc2l0ZS10by1hLXByb2R1Y3Rpb24tc2l0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[simonlindsay](/forum/user/32377-simonlindsay "View simonlindsay's Profile")** - [![simonlindsay's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32377-simonlindsay "View simonlindsay's Profile") - [ Offline](/forum/user/32377-simonlindsay) Less More - Posts: 29 - Thank you received: 3 - - 3 years 9 months ago [\#348091](#348091) by [simonlindsay](/forum/user/32377-simonlindsay "View simonlindsay's Profile") Replied by *[simonlindsay](/forum/user/32377-simonlindsay "View simonlindsay's Profile")* on topic *[Copying hikashop data base from a test site to a production site](/forum/37-import-export-csv-xls/905405-copying-hikashop-data-base-from-a-test-site-to-a-production-site#348091 "-- 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")* Hi Nicolas, Sorry but the info should read, ....Joomla 4 site the database is c667 and the tables are 'cqld7_'...... Thanks Simon Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDU0MDUtY29weWluZy1oaWthc2hvcC1kYXRhLWJhc2UtZnJvbS1hLXRlc3Qtc2l0ZS10by1hLXByb2R1Y3Rpb24tc2l0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86286 - Thank you received: 14263 - - 3 years 9 months ago [\#348093](#348093) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Copying hikashop data base from a test site to a production site](/forum/37-import-export-csv-xls/905405-copying-hikashop-data-base-from-a-test-site-to-a-production-site#348093 "-- 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")* Hi, Before importing the file, you can open it with notepad and do a search and replace to change one prefix to the other. Once the tables are imported, PHPMyAdmin doesn't have a tool to change the prefix of a bunch of tables at once, so it's better to do it before. Otherwise, you need to change them one by one. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDU0MDUtY29weWluZy1oaWthc2hvcC1kYXRhLWJhc2UtZnJvbS1hLXRlc3Qtc2l0ZS10by1hLXByb2R1Y3Rpb24tc2l0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[simonlindsay](/forum/user/32377-simonlindsay "View simonlindsay's Profile")** - [![simonlindsay's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32377-simonlindsay "View simonlindsay's Profile") - [ Offline](/forum/user/32377-simonlindsay) Less More - Posts: 29 - Thank you received: 3 - - 3 years 9 months ago - 3 years 9 months ago [\#348102](#348102) by [simonlindsay](/forum/user/32377-simonlindsay "View simonlindsay's Profile") Replied by *[simonlindsay](/forum/user/32377-simonlindsay "View simonlindsay's Profile")* on topic *[Copying hikashop data base from a test site to a production site](/forum/37-import-export-csv-xls/905405-copying-hikashop-data-base-from-a-test-site-to-a-production-site#348102 "-- 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")* Hi Nicolas, Thanks, as always, for a speedy reply. Just to clarify, do I need to delete the existing tables that contain your example data or will it integrate into current tables, _product, _product_category etc? Thanks, Simon Last edit: 3 years 9 months ago by [simonlindsay](/forum/user/32377-simonlindsay "View simonlindsay's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDU0MDUtY29weWluZy1oaWthc2hvcC1kYXRhLWJhc2UtZnJvbS1hLXRlc3Qtc2l0ZS10by1hLXByb2R1Y3Rpb24tc2l0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86286 - Thank you received: 14263 - - 3 years 9 months ago [\#348103](#348103) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Copying hikashop data base from a test site to a production site](/forum/37-import-export-csv-xls/905405-copying-hikashop-data-base-from-a-test-site-to-a-production-site#348103 "-- 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")* Hi, You would need to delete them. The import won't clear the data already in the tables. Also, if the version of HikaShop from which you're importing and the one already on the new website are not the same, after the import you can either install the HikaShop install package or use the "check database" button of the HikaShop configuration in order to add back any missing columns in the tables imported from the old website. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDU0MDUtY29weWluZy1oaWthc2hvcC1kYXRhLWJhc2UtZnJvbS1hLXRlc3Qtc2l0ZS10by1hLXByb2R1Y3Rpb24tc2l0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[simonlindsay](/forum/user/32377-simonlindsay "View simonlindsay's Profile")** - [![simonlindsay's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32377-simonlindsay "View simonlindsay's Profile") - [ Offline](/forum/user/32377-simonlindsay) Less More - Posts: 29 - Thank you received: 3 - - 3 years 9 months ago [\#348127](#348127) by [simonlindsay](/forum/user/32377-simonlindsay "View simonlindsay's Profile") Replied by *[simonlindsay](/forum/user/32377-simonlindsay "View simonlindsay's Profile")* on topic *[Copying hikashop data base from a test site to a production site](/forum/37-import-export-csv-xls/905405-copying-hikashop-data-base-from-a-test-site-to-a-production-site#348127 "-- 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")* Hi Nicolas, Thanks!! Simon The following user(s) said Thank You: [Philip](/forum/user/34318-philip "View Philip's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDU0MDUtY29weWluZy1oaWthc2hvcC1kYXRhLWJhc2UtZnJvbS1hLXRlc3Qtc2l0ZS10by1hLXByb2R1Y3Rpb24tc2l0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.289 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)