You have to change database tables to ps_category_lang, and slightly adjust columns -- categories don't have short description, or availablility fields.
Result should look like this
UPDATE ps_category_lang dest
INNER JOIN ps_category_lang src ON (dest.id_category = src.id_category AND dest.id_shop = src.id_shop AND src.id_lang = 6)
SET dest.description = src.description,
dest.link_rewrite = src.link_rewrite,
dest.meta_description = src.meta_description,
dest.meta_keywords = src.meta_keywords,
dest.meta_title = src.meta_title,
dest.name = src.name
WHERE dest.id_lang = 7
AND dest.id_category IN (3, 4, 5)