[Skip to main content](#vessel-content) # How to Copy Hikashop Menu Tables using Phpmyadmin ## - **[cimran12](/forum/user/32887-cimran12 "View cimran12's Profile")** - [![cimran12's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar32887.jpg)](/forum/user/32887-cimran12 "View cimran12's Profile") Topic Author - [ Offline](/forum/user/32887-cimran12) Less More - Posts: 11 - Thank you received: 0 - - 12 years 4 months ago [\#159843](#159843) by [cimran12](/forum/user/32887-cimran12 "View cimran12's Profile") *[How to Copy Hikashop Menu Tables using Phpmyadmin](/forum/25-install-update/868937-how-to-copy-hikashop-menu-tables-using-phpmyadmin#159843 "I want to copy hikashop menu data from one host to another, for this i need only copy the tables of hikashop menu items using phpmyadmin Can you help me doing this?")* was created by *[cimran12](/forum/user/32887-cimran12 "View cimran12's Profile")* I want to copy hikashop menu data from one host to another, for this i need only copy the tables of hikashop menu items using phpmyadmin Can you help me doing this? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2ODkzNy1ob3ctdG8tY29weS1oaWthc2hvcC1tZW51LXRhYmxlcy11c2luZy1waHBteWFkbWluP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile")** - [![lousyfool's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar28604.jpg)](/forum/user/28604-lousyfool "View lousyfool's Profile") - [ Offline](/forum/user/28604-lousyfool) Less More - Posts: 2143 - Thank you received: 747 - - [](http://www.inphase.one) - 12 years 4 months ago - 12 years 4 months ago [\#159854](#159854) by [lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile") Replied by *[lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile")* on topic *[How to Copy Hikashop Menu Tables using Phpmyadmin](/forum/25-install-update/868937-how-to-copy-hikashop-menu-tables-using-phpmyadmin#159854 "I want to copy hikashop menu data from one host to another, for this i need only copy the tables of hikashop menu items using phpmyadmin Can you help me doing this?")* You're doing so at your own risk! In any case, make a backup of the complete database before starting! (In case you wonder how, follow the "**A:** Export..." steps here below, only for ALL tables in the database.) **A:** Export from source database: 1. In phpMyAdmin, in its left pane, click on the database containing the HikaShop tables. 2. Now you should have a list of all tables in the right pane, too. 3. Further up in the right pane you have a tab "Export". Click it, then select "Custom - ...". 4. Now you see below a frame with a scrollable list of all tables in the database. By default they're all selected. However, you want to select only the HikaShop tables. They're easy to find since they are all named xyz\_hikashop\_..., where "xyz" the prefix of probably all tables in your database is. Make the selection with by clicking the first, then the last while holding the Shift key. 5. Below the frame, select "Save output to a file". Leave everything else further below as is, don't change any other setting. 6. Click "Go" at the bottom of the pane. A short while later you'll have the tables in one file. **B:** Import into target database: 1. You guess it: The target database wants to be selected in the left pane. 2. And by now you've seen the "Import" tab at the upper edge of the right pane. 3. The rest is simple: choose the previously exported file, don't touch anything else, and click "Go" at the bottom of the pane. 4. Now the HikaShop tables should be part of the target database. Notes: - If you had tables of the same name in the target database before (which is very likely - otherwise I'd wonder why you'd want to move those tables), you'll first need to decide what to do with them. Again, whatever you do, BACKUP - this time the complete target database! - The suffix ("xyz" in my example above) is ideally the same as the rest of the target database tables. If needed, the freshly imported tables can be renamed - but that's a different subject... to be covered, well, if needed. ![;)](/media/kunena/emoticons/11.png ";)") --- Need help with customisations of layouts, style or other site development? [ PM me!](/component/uddeim/?task=new) (Don't forget to turn on [ "E-mail notification of new messages"](/component/uddeim/?task=settings)) Last edit: 12 years 4 months ago by [lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile"). The following user(s) said Thank You: [cimran12](/forum/user/32887-cimran12 "View cimran12's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2ODkzNy1ob3ctdG8tY29weS1oaWthc2hvcC1tZW51LXRhYmxlcy11c2luZy1waHBteWFkbWluP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile")** - [![lousyfool's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar28604.jpg)](/forum/user/28604-lousyfool "View lousyfool's Profile") - [ Offline](/forum/user/28604-lousyfool) Less More - Posts: 2143 - Thank you received: 747 - - [](http://www.inphase.one) - 12 years 4 months ago [\#159857](#159857) by [lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile") Replied by *[lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile")* on topic *[How to Copy Hikashop Menu Tables using Phpmyadmin](/forum/25-install-update/868937-how-to-copy-hikashop-menu-tables-using-phpmyadmin#159857 "I want to copy hikashop menu data from one host to another, for this i need only copy the tables of hikashop menu items using phpmyadmin Can you help me doing this?")* **Hoooooold it.....!** "Menu data"? What do you mean? Maybe I was too quick with my post... --- Need help with customisations of layouts, style or other site development? [ PM me!](/component/uddeim/?task=new) (Don't forget to turn on [ "E-mail notification of new messages"](/component/uddeim/?task=settings)) The following user(s) said Thank You: [cimran12](/forum/user/32887-cimran12 "View cimran12's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2ODkzNy1ob3ctdG8tY29weS1oaWthc2hvcC1tZW51LXRhYmxlcy11c2luZy1waHBteWFkbWluP3RtcGw9bWFya2Rvd24=) 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 4 months ago [\#159852](#159852) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[How to Copy Hikashop Menu Tables using Phpmyadmin](/forum/25-install-update/868937-how-to-copy-hikashop-menu-tables-using-phpmyadmin#159852 "I want to copy hikashop menu data from one host to another, for this i need only copy the tables of hikashop menu items using phpmyadmin Can you help me doing this?")* Hi, The hikashop menus are stored in the Joomla menu tables. What can be done, is to export the menu tables from the current host via phpMyAdmin, and then open the sql file with notepad++ for example and remove the undesired data, then import the content in the phpMyAdmin of the other host. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2ODkzNy1ob3ctdG8tY29weS1oaWthc2hvcC1tZW51LXRhYmxlcy11c2luZy1waHBteWFkbWluP3RtcGw9bWFya2Rvd24=) 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.210 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)