[Skip to main content](#vessel-content) # Moving HikaShop to new website - copying tables in ## - **[sweet-print.co.uk](/forum/user/2930-sweet-print-co-uk "View sweet-print.co.uk's Profile")** - [![sweet-print.co.uk's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2930-sweet-print-co-uk "View sweet-print.co.uk's Profile") Topic Author - [ Offline](/forum/user/2930-sweet-print-co-uk) Less More - Posts: 4 - Thank you received: 0 - - 15 years 1 month ago [\#25546](#25546) by [sweet-print.co.uk](/forum/user/2930-sweet-print-co-uk "View sweet-print.co.uk's Profile") *[Moving HikaShop to new website - copying tables in](/forum/4-how-to/25546-moving-hikashop-to-new-website-copying-tables-in#25546 "Hi, I have very little knowledge when it comes to databases so was wondering if someone could help me out. I am trying to move my shop to a new website. But I can not work out how to move the HikaShop tables in the old websites database to the new one's. I can move a whole database, rename and whatever but im pretty sure I just need to move the tables right? Thanks in advance for any help.")* was created by *[sweet-print.co.uk](/forum/user/2930-sweet-print-co-uk "View sweet-print.co.uk's Profile")* Hi, I have very little knowledge when it comes to databases so was wondering if someone could help me out. I am trying to move my shop to a new website. But I can not work out how to move the HikaShop tables in the old websites database to the new one's. I can move a whole database, rename and whatever but im pretty sure I just need to move the tables right? Thanks in advance for any help. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI1NTQ2LW1vdmluZy1oaWthc2hvcC10by1uZXctd2Vic2l0ZS1jb3B5aW5nLXRhYmxlcy1pbj90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14276 - - 15 years 1 month ago [\#25549](#25549) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Moving HikaShop to new website - copying tables in](/forum/4-how-to/25546-moving-hikashop-to-new-website-copying-tables-in#25549 "Hi, I have very little knowledge when it comes to databases so was wondering if someone could help me out. I am trying to move my shop to a new website. But I can not work out how to move the HikaShop tables in the old websites database to the new one's. I can move a whole database, rename and whatever but im pretty sure I just need to move the tables right? Thanks in advance for any help.")* Hi, You can of course move only the tables but moving the database all together and renaming it is easier. In phpmyadmin, once you opened the database of your website, you can click on the export button and then select the tables you want to export. all the hikashop tables are prefixed with "hikashop" however, the modules and menus that you created for HikaShop are stored by joomla in the tables jos_menus and jos_modules. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI1NTQ2LW1vdmluZy1oaWthc2hvcC10by1uZXctd2Vic2l0ZS1jb3B5aW5nLXRhYmxlcy1pbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[boopoo](/forum/user/8365-boopoo "View boopoo's Profile")** - [![boopoo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8365-boopoo "View boopoo's Profile") - [ Offline](/forum/user/8365-boopoo) Less More - Posts: 272 - Thank you received: 7 - - 12 years 2 months ago [\#167252](#167252) by [boopoo](/forum/user/8365-boopoo "View boopoo's Profile") Replied by *[boopoo](/forum/user/8365-boopoo "View boopoo's Profile")* on topic *[Re: Moving HikaShop to new website - copying tables in](/forum/4-how-to/25546-moving-hikashop-to-new-website-copying-tables-in#167252 "Hi, I have very little knowledge when it comes to databases so was wondering if someone could help me out. I am trying to move my shop to a new website. But I can not work out how to move the HikaShop tables in the old websites database to the new one's. I can move a whole database, rename and whatever but im pretty sure I just need to move the tables right? Thanks in advance for any help.")* Hi Nicolas, I am moving hikashop to a new site. I will copy all users and the tables of hikashop to the new site (and try catch as many hikashop modules as I can). However, can you tell me if I need to first install the latest copy of hikashop on my new website, then import the tables and users from old site? Basically not sure if I need to install Hikashop first (moving from a Joomla 2.5 site to a Joomla 3 site). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI1NTQ2LW1vdmluZy1oaWthc2hvcC10by1uZXctd2Vic2l0ZS1jb3B5aW5nLXRhYmxlcy1pbj90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14276 - - 12 years 2 months ago [\#167285](#167285) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Moving HikaShop to new website - copying tables in](/forum/4-how-to/25546-moving-hikashop-to-new-website-copying-tables-in#167285 "Hi, I have very little knowledge when it comes to databases so was wondering if someone could help me out. I am trying to move my shop to a new website. But I can not work out how to move the HikaShop tables in the old websites database to the new one's. I can move a whole database, rename and whatever but im pretty sure I just need to move the tables right? Thanks in advance for any help.")* Hi, When you move HikaShop between websites, it's recommended to have the same version on both websites. If on your 2.5 website you have an old version of HikaShop which doesn't support 3.x or if you don't have the install package of the version of HikaShop that you have on your 2.5 website, then, it's better to first update HikaShop on the 2.5 website. Then, you can copy the database tables form the old to the new website, and finally you can install Hikashop on the new website. The following user(s) said Thank You: [boopoo](/forum/user/8365-boopoo "View boopoo's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI1NTQ2LW1vdmluZy1oaWthc2hvcC10by1uZXctd2Vic2l0ZS1jb3B5aW5nLXRhYmxlcy1pbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[boopoo](/forum/user/8365-boopoo "View boopoo's Profile")** - [![boopoo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8365-boopoo "View boopoo's Profile") - [ Offline](/forum/user/8365-boopoo) Less More - Posts: 272 - Thank you received: 7 - - 12 years 2 months ago [\#167720](#167720) by [boopoo](/forum/user/8365-boopoo "View boopoo's Profile") Replied by *[boopoo](/forum/user/8365-boopoo "View boopoo's Profile")* on topic *[Re: Moving HikaShop to new website - copying tables in](/forum/4-how-to/25546-moving-hikashop-to-new-website-copying-tables-in#167720 "Hi, I have very little knowledge when it comes to databases so was wondering if someone could help me out. I am trying to move my shop to a new website. But I can not work out how to move the HikaShop tables in the old websites database to the new one's. I can move a whole database, rename and whatever but im pretty sure I just need to move the tables right? Thanks in advance for any help.")* I have actually setup hikashop from scratch on new site. I just need to transfer users and my shop orders. Can you tell me which tables are for all the orders, which I need to copy to just take all the details from the orders across to new database? I am changing from a Joomla2.5 (MySQL) to a Joomla3.3 (MySQLi) setup. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI1NTQ2LW1vdmluZy1oaWthc2hvcC10by1uZXctd2Vic2l0ZS1jb3B5aW5nLXRhYmxlcy1pbj90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14276 - - 12 years 2 months ago [\#167722](#167722) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Moving HikaShop to new website - copying tables in](/forum/4-how-to/25546-moving-hikashop-to-new-website-copying-tables-in#167722 "Hi, I have very little knowledge when it comes to databases so was wondering if someone could help me out. I am trying to move my shop to a new website. But I can not work out how to move the HikaShop tables in the old websites database to the new one's. I can move a whole database, rename and whatever but im pretty sure I just need to move the tables right? Thanks in advance for any help.")* it's the tables hikashop_order hikashop_order_product hikashop_history hikashop_address and hikashop_user. Note that you should also make sure that you copy all the joomla users from the old website to the new one and that they keep the same ids. If they don't keep the same ids, you need to install HikaShop again on the website in order to synchornize the ids again. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI1NTQ2LW1vdmluZy1oaWthc2hvcC10by1uZXctd2Vic2l0ZS1jb3B5aW5nLXRhYmxlcy1pbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[boopoo](/forum/user/8365-boopoo "View boopoo's Profile")** - [![boopoo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8365-boopoo "View boopoo's Profile") - [ Offline](/forum/user/8365-boopoo) Less More - Posts: 272 - Thank you received: 7 - - 12 years 2 months ago [\#167843](#167843) by [boopoo](/forum/user/8365-boopoo "View boopoo's Profile") Replied by *[boopoo](/forum/user/8365-boopoo "View boopoo's Profile")* on topic *[Re: Moving HikaShop to new website - copying tables in](/forum/4-how-to/25546-moving-hikashop-to-new-website-copying-tables-in#167843 "Hi, I have very little knowledge when it comes to databases so was wondering if someone could help me out. I am trying to move my shop to a new website. But I can not work out how to move the HikaShop tables in the old websites database to the new one's. I can move a whole database, rename and whatever but im pretty sure I just need to move the tables right? Thanks in advance for any help.")* Many thanks Nicolas. I tried that but the transfer of the database tables did not work - possibly an issue with migrating them from a 2.5 site to a J3.3 site. Who knows. What other option, if any, do I have for importing the order / cutomer from my old site to new site. I have already imported all the Joomla users. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI1NTQ2LW1vdmluZy1oaWthc2hvcC10by1uZXctd2Vic2l0ZS1jb3B5aW5nLXRhYmxlcy1pbj90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14276 - - 12 years 2 months ago [\#167846](#167846) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Moving HikaShop to new website - copying tables in](/forum/4-how-to/25546-moving-hikashop-to-new-website-copying-tables-in#167846 "Hi, I have very little knowledge when it comes to databases so was wondering if someone could help me out. I am trying to move my shop to a new website. But I can not work out how to move the HikaShop tables in the old websites database to the new one's. I can move a whole database, rename and whatever but im pretty sure I just need to move the tables right? Thanks in advance for any help.")* There is no other options than the process I explained above. If you have a hard time doing it, you might want to hire someone to do it for you. We have partners you can contact for that: [ www.hikashop.com/home/our-partners.html](http://www.hikashop.com/home/our-partners.html) And you can also look for someone on our commercial jobs forum or joomlancers.com Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI1NTQ2LW1vdmluZy1oaWthc2hvcC10by1uZXctd2Vic2l0ZS1jb3B5aW5nLXRhYmxlcy1pbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[boopoo](/forum/user/8365-boopoo "View boopoo's Profile")** - [![boopoo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8365-boopoo "View boopoo's Profile") - [ Offline](/forum/user/8365-boopoo) Less More - Posts: 272 - Thank you received: 7 - - 12 years 2 months ago [\#167956](#167956) by [boopoo](/forum/user/8365-boopoo "View boopoo's Profile") Replied by *[boopoo](/forum/user/8365-boopoo "View boopoo's Profile")* on topic *[Re: Moving HikaShop to new website - copying tables in](/forum/4-how-to/25546-moving-hikashop-to-new-website-copying-tables-in#167956 "Hi, I have very little knowledge when it comes to databases so was wondering if someone could help me out. I am trying to move my shop to a new website. But I can not work out how to move the HikaShop tables in the old websites database to the new one's. I can move a whole database, rename and whatever but im pretty sure I just need to move the tables right? Thanks in advance for any help.")* Hi Nicolas, Is there no way to export some of the data as a .CSV, at least just to have the records of what people ordered? The hosting company said that they could not help - as quite often they do. If there is no .csv option, I will see if any of the source you have supplied can come up with database professionals. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI1NTQ2LW1vdmluZy1oaWthc2hvcC10by1uZXctd2Vic2l0ZS1jb3B5aW5nLXRhYmxlcy1pbj90bXBsPW1hcmtkb3du) 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) - 12 years 2 months ago [\#167965](#167965) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Re: Moving HikaShop to new website - copying tables in](/forum/4-how-to/25546-moving-hikashop-to-new-website-copying-tables-in#167965 "Hi, I have very little knowledge when it comes to databases so was wondering if someone could help me out. I am trying to move my shop to a new website. But I can not work out how to move the HikaShop tables in the old websites database to the new one's. I can move a whole database, rename and whatever but im pretty sure I just need to move the tables right? Thanks in advance for any help.")* Hi, Sorry to jump into this topic, hope my answer will be correct. Thanks to the mass actions, you can export the order data, in the csv file you can put all the order, customer and address data. Hope this will help you, but there is maybe missing things. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI1NTQ2LW1vdmluZy1oaWthc2hvcC10by1uZXctd2Vic2l0ZS1jb3B5aW5nLXRhYmxlcy1pbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[boopoo](/forum/user/8365-boopoo "View boopoo's Profile")** - [![boopoo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8365-boopoo "View boopoo's Profile") - [ Offline](/forum/user/8365-boopoo) Less More - Posts: 272 - Thank you received: 7 - - 12 years 2 months ago [\#168206](#168206) by [boopoo](/forum/user/8365-boopoo "View boopoo's Profile") Replied by *[boopoo](/forum/user/8365-boopoo "View boopoo's Profile")* on topic *[Re: Moving HikaShop to new website - copying tables in](/forum/4-how-to/25546-moving-hikashop-to-new-website-copying-tables-in#168206 "Hi, I have very little knowledge when it comes to databases so was wondering if someone could help me out. I am trying to move my shop to a new website. But I can not work out how to move the HikaShop tables in the old websites database to the new one's. I can move a whole database, rename and whatever but im pretty sure I just need to move the tables right? Thanks in advance for any help.")* Thank you Xavier.... sadly your comments came a day too late! Thank you in any case. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI1NTQ2LW1vdmluZy1oaWthc2hvcC10by1uZXctd2Vic2l0ZS1jb3B5aW5nLXRhYmxlcy1pbj90bXBsPW1hcmtkb3du) 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.108 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)