Alter all table's - discard tablespace

After having an awful experience with a dedicated server and spending 3 whole days repairing corrupted databases (Yes I know.... backup!).... I have narrowed the issues down to a few websites. The trouble is, these websites are Magento websites.

I am having to import the .ibd files into the /var/lib/mysql folder and DISCARD/IMPORT the tablespace.

Is there a way to alter ALL tables in the database at once, i.e ALTER TABLE * DISCARD TABLESPACE and then move the files across... Then ALTER TABLE * IMPORT TABLESPACE ?