import export Error Message

I am running 1.4.9.4 OC

trying to use the import export tool but am getting the following message


Error: Incorrect key file for table '/tmp/#sql_47d_0.MYI'; try to repair it<br />Error No: 126<br />SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories, p.sku, p.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, p.date_added, p.date_modified, p.date_available, p.weight, wc.unit, p.length, p.width, p.height, p.status, p.tax_class_id, p.viewed, p.sort_order, pd.language_id, ua.keyword, pd.description, pd.meta_description, pd.meta_keywords, p.stock_status_id, mc.unit AS length_unit, p.subtract, p.minimum, p.cost, GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related, GROUP_CONCAT( DISTINCT pt.tag SEPARATOR "," ) AS tags FROM `product` p LEFT JOIN `product_description` pd ON p.product_id=pd.product_id AND pd.language_id=1 LEFT JOIN `product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=1 LEFT JOIN `length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=1 LEFT JOIN `product_related` pr ON pr.product_id=p.product_id LEFT JOIN `product_tags` pt ON pt.product_id=p.product_id AND pt.language_id=1 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id;

help:)

Consult the developer of the tool. If you run in to a dead end then perhaps we can assist you.

The developer requests that you place support requests on the forum.

I think it is to enable him to answer faster and to share the outcome with other users


Dave

Tell the developer that he needs to grow a brain, and perhaps not be so lazy as to pawn off his customers to a forum that has nothing to do with his extension;) Especially if you paid for the extension.

I assume you can not help then. You could have just said so. The extension is free by the way.

I would happily pay for one if I could get hold of anyone who could build one. Yes I have tried asking before

Maybe I posted in the wrong category. For that I apologize

I can help. I was just passing along a little advice for your developer. That's shotty customer service.

However, your error:

This happens if you are running a local webserver like xampp and the database gets corrupted. nothing you can do but restore the db from a backup or blow away that table and re-add it

Sorry I am confused.I am getting this message when trying to download the live database from my website.

Is there any way I can correct this problem, The site has around 9000 products listed

Okay,. Then try doing a little at at time. Don't do all at once.

The way that the developer has written the mod. It can only install all in one go or not at all

Exactly. The developer should know MYSQL if releasing such a mod. The error "could" be contributed to a lack of space upon importing, or there could actually be a contaminated table like I said before.

No worries. Thank you for your help.

Would you by any chance happen to know anyone who could write such a mod ?