[Skip to main content](#vessel-content) # Migration of DB tables ## - **[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")** - [![olivnewton's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9482-olivnewton "View olivnewton's Profile") Topic Author - [ Offline](/forum/user/9482-olivnewton) Less More - Posts: 154 - Thank you received: 4 - - 10 years 5 months ago [\#239675](#239675) by [olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile") *[Migration of DB tables](/forum/25-install-update/884426-migration-of-db-tables#239675 "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.6 dear team, after finally fixed all issues on a clients website, we would like to proceed with migrating all the necessary DB tables for hikashop from the old site to the new site. this is our setup: OLD SITE: joomla: 3.4.7 hika: 2.5.0 NEW SITE joomla: 3.4.8 hika: 2.6.1 what are the tables to migrate? is there anything we need to be aware of`? (maybe new columns in the new hika version etc.?)")* was created by *[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")* -- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.6 dear team, after finally fixed all issues on a clients website, we would like to proceed with migrating all the necessary DB tables for hikashop from the old site to the new site. this is our setup: **OLD SITE:** joomla: 3.4.7 hika: 2.5.0 **NEW SITE** joomla: 3.4.8 hika: 2.6.1 what are the tables to migrate? is there anything we need to be aware of`? (maybe new columns in the new hika version etc.?) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NDQyNi1taWdyYXRpb24tb2YtZGItdGFibGVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 10 years 5 months ago [\#239676](#239676) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Migration of DB tables](/forum/25-install-update/884426-migration-of-db-tables#239676 "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.6 dear team, after finally fixed all issues on a clients website, we would like to proceed with migrating all the necessary DB tables for hikashop from the old site to the new site. this is our setup: OLD SITE: joomla: 3.4.7 hika: 2.5.0 NEW SITE joomla: 3.4.8 hika: 2.6.1 what are the tables to migrate? is there anything we need to be aware of`? (maybe new columns in the new hika version etc.?)")* Hi, The best would be to create a new development environment and duplicate the old site. Then on this dev version, update HikaShop to the latest version, the 2.6.3, same thing for the new site, update it to the latest version. Then migrate all the HikaShop tables from the old to the new site, that way you are sure to migrate all the data and using the dev environment will not broke the production website. You will need to have the latest data from the Joomla user table up to date too, but this is a Joomla thing ![;)](/media/kunena/emoticons/11.png ";)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NDQyNi1taWdyYXRpb24tb2YtZGItdGFibGVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")** - [![olivnewton's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9482-olivnewton "View olivnewton's Profile") Topic Author - [ Offline](/forum/user/9482-olivnewton) Less More - Posts: 154 - Thank you received: 4 - - 10 years 5 months ago [\#239784](#239784) by [olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile") Replied by *[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")* on topic *[Migration of DB tables](/forum/25-install-update/884426-migration-of-db-tables#239784 "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.6 dear team, after finally fixed all issues on a clients website, we would like to proceed with migrating all the necessary DB tables for hikashop from the old site to the new site. this is our setup: OLD SITE: joomla: 3.4.7 hika: 2.5.0 NEW SITE joomla: 3.4.8 hika: 2.6.1 what are the tables to migrate? is there anything we need to be aware of`? (maybe new columns in the new hika version etc.?)")* thank you for the quick reply! we did that already. NEW SITE is the duplicate dev environment of the OLD SITE (see my first post). OLD SITE is right now the LIVE SITE, which will be switched to NEW SITE as soon as we finished migrating the tables (orders etc.?) problem is, we cannot update HIKA on the OLD SITE (which is currently live and on another server we dont have access). but we need (and can) to import the orders from the OLD SITE (currently live) to the NEW/DEV SITE prior to the switch. have there been changes to the table structures we need to migrate, from hika 2.5.0 to 2.6.1 ? 1. if yes, can you help in finding a solution on how to migrate (eg. what columns should we add to the tables of the DB)? 2. if not, what are the hika tables we need to migrate? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NDQyNi1taWdyYXRpb24tb2YtZGItdGFibGVzP3RtcGw9bWFya2Rvd24=) 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: 86289 - Thank you received: 14265 - - 10 years 5 months ago [\#239801](#239801) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Migration of DB tables](/forum/25-install-update/884426-migration-of-db-tables#239801 "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.6 dear team, after finally fixed all issues on a clients website, we would like to proceed with migrating all the necessary DB tables for hikashop from the old site to the new site. this is our setup: OLD SITE: joomla: 3.4.7 hika: 2.5.0 NEW SITE joomla: 3.4.8 hika: 2.6.1 what are the tables to migrate? is there anything we need to be aware of`? (maybe new columns in the new hika version etc.?)")* Hi, Then why not simply duplicate the old website somewhere else and update HikaShop on that copy of the website and then use the tables and files from that copy to add in the new website ? Otherwise, you can try with the old version but yes, columns and tables have been modified/added between the versions of HikaShop. So you can try to fix them with the "check database" button of the HikaShop configuration after the migration. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NDQyNi1taWdyYXRpb24tb2YtZGItdGFibGVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")** - [![olivnewton's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9482-olivnewton "View olivnewton's Profile") Topic Author - [ Offline](/forum/user/9482-olivnewton) Less More - Posts: 154 - Thank you received: 4 - - 10 years 5 months ago - 10 years 5 months ago [\#240579](#240579) by [olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile") Replied by *[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")* on topic *[Migration of DB tables](/forum/25-install-update/884426-migration-of-db-tables#240579 "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.6 dear team, after finally fixed all issues on a clients website, we would like to proceed with migrating all the necessary DB tables for hikashop from the old site to the new site. this is our setup: OLD SITE: joomla: 3.4.7 hika: 2.5.0 NEW SITE joomla: 3.4.8 hika: 2.6.1 what are the tables to migrate? is there anything we need to be aware of`? (maybe new columns in the new hika version etc.?)")* that is also an option. thanks for the suggestion, we will think of it. but the most important thing is our question: **- what are the hika tables we need to migrate?** (in order to have all shop orders up to date) (we are planning to manually add the new entries) PS. we do not use a user login, so i guess not users need to be imported from joomla? i suspect the following tables (please confirm): Code: _hikashop_address = 1981 entries _hikashop_history = 1486 entries _hikashop_order = 1483 entries _hikashop_order_product = 3190 entries _hikashop_user = 1277 entries am i missing any? Last edit: 10 years 5 months ago by [olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NDQyNi1taWdyYXRpb24tb2YtZGItdGFibGVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 10 years 5 months ago [\#240580](#240580) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Migration of DB tables](/forum/25-install-update/884426-migration-of-db-tables#240580 "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.6 dear team, after finally fixed all issues on a clients website, we would like to proceed with migrating all the necessary DB tables for hikashop from the old site to the new site. this is our setup: OLD SITE: joomla: 3.4.7 hika: 2.5.0 NEW SITE joomla: 3.4.8 hika: 2.6.1 what are the tables to migrate? is there anything we need to be aware of`? (maybe new columns in the new hika version etc.?)")* Hi, Yes the main table to migrate are the ones you mentioned. In some case the table "_hikashop_file" could be useful too. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NDQyNi1taWdyYXRpb24tb2YtZGItdGFibGVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")** - [![olivnewton's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9482-olivnewton "View olivnewton's Profile") Topic Author - [ Offline](/forum/user/9482-olivnewton) Less More - Posts: 154 - Thank you received: 4 - - 10 years 5 months ago [\#240707](#240707) by [olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile") Replied by *[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")* on topic *[Migration of DB tables](/forum/25-install-update/884426-migration-of-db-tables#240707 "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.6 dear team, after finally fixed all issues on a clients website, we would like to proceed with migrating all the necessary DB tables for hikashop from the old site to the new site. this is our setup: OLD SITE: joomla: 3.4.7 hika: 2.5.0 NEW SITE joomla: 3.4.8 hika: 2.6.1 what are the tables to migrate? is there anything we need to be aware of`? (maybe new columns in the new hika version etc.?)")* all worked great, i did not even need to fix any tables! The following user(s) said Thank You: [Jerome](/forum/user/80-jerome "View Jerome's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NDQyNi1taWdyYXRpb24tb2YtZGItdGFibGVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[rocky123](/forum/user/43322-rocky123 "View rocky123's Profile")** - [![rocky123's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/43322-rocky123 "View rocky123's Profile") - [ Offline](/forum/user/43322-rocky123) Less More - Posts: 3 - Thank you received: 1 - - 10 years 4 months ago [\#241247](#241247) by [rocky123](/forum/user/43322-rocky123 "View rocky123's Profile") Replied by *[rocky123](/forum/user/43322-rocky123 "View rocky123's Profile")* on topic *[Migration of DB tables](/forum/25-install-update/884426-migration-of-db-tables#241247 "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.6 dear team, after finally fixed all issues on a clients website, we would like to proceed with migrating all the necessary DB tables for hikashop from the old site to the new site. this is our setup: OLD SITE: joomla: 3.4.7 hika: 2.5.0 NEW SITE joomla: 3.4.8 hika: 2.6.1 what are the tables to migrate? is there anything we need to be aware of`? (maybe new columns in the new hika version etc.?)")* In Components >>> Joomla update ... options ... set LTS save and close. Purge cache. If no update shows then use the extension manager to install the latest version Install a fresh latest version without sample data export/import from original to new version In the new Components >>> Joomla update ... options ... set STS save and close Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NDQyNi1taWdyYXRpb24tb2YtZGItdGFibGVzP3RtcGw9bWFya2Rvd24=) 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.303 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)