I create a table named as sampletable. I have load data to this table using "load data infile.." query. I have huge data to load in it. So i have split the text files in two parts and run the two parts parallel in two systems. Now i got sampletable.frm, sampletable.MYD and sampletable.MYI in each system. Now i want to merge the sampletable.MYD and sampletable.MYI together in one system. Kindly help me how to merge these files together

thanks in advance