How to Copy Hikashop Menu Tables using Phpmyadmin

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.

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.

• 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.

Hoooooold it.....!

"Menu data"? What do you mean? Maybe I was too quick with my post...

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.