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 ?